为什么我的mysql_query($insert)添加不到数据库_百度知道
为什么我的mysql_query($insert)添加不到数据库
mysql_select_db(&insert into login(user$conne=mysql_connect(&root&quot,&),&){ $insert=&submit&quot,$_POST[password])& }else{
echo&& echo mysql_query($insert);
echo $insert,$conne);bbs&;;提交& }}一会可以添加;localhost&;
if(mysql_query($insert)){
echo &;添加成功&添加失败&if ($_POST[&quot,password) values($_POST[user];]==&;
提问者采纳
at row 1这个错误则是因为新版本的MySQL对字段的严格检查导致的 解决方法;&#39：在语句后面添加echo mysql_error(); 可以看到具体的原因 如果是Out of range value adjusted for column &#39。2。重新启动MySQL;改为sql-mode=&ID&#39：1：修改set sql_mode=&#39.ini：在sql语句前加入mysql_query(&quot,将sql-mode=&NO_AUTO_CREATE_USER;STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION&quot,NO_ENGINE_SUBSTITUTION&;&)mysql_query执行insert报错举例说明
提问者评价
3q 我已经自己解决了 呵呵
其他类似问题
为您推荐：
mysql的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁UCenter info: MySQL Query Error SQL:INSERT INTO [Table]memberfields SET uid='13' Error:1062_百度知道
UCenter info: MySQL Query Error SQL:INSERT INTO [Table]memberfields SET uid='13' Error:1062
提问者采纳
这个是因为uc数据库里的memberfields 表里的uid重复了　，清空了就可以了。
提问者评价
采纳率100%
其他类似问题
为您推荐：
ucenter的相关知识
其他1条回答
insert into 的语法应该不是这样写的吧
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁mysql insert语句怎么插入变量_百度知道
mysql insert语句怎么插入变量
)));对于其中的xyz是三个变量，应该怎么写;if(mysql_real_query(sock,&#39,&y';z'insert into phone(phone,&#39,code？要具体的代码;x&#39,time)values(&#39
提问者采纳
%dchar sql[] = &quot.., z);insert into phone(char sqlBuf[1024],sqlBuf)), y, sql, x,code,%d)&quot,time)values(%d.;sprintf(sqlBif(mysql_real_query(sock
提问者评价
谢谢你帮我大忙了
相关专业回答
建立ACCESS数据库db1.mdb，在其中建立数据表user,字段分别为：
u_uid（自动）
u_user（用户名：文本型）
u_pass(密码：文本型) 建立接收register.asp中发送过来的表单数据，并插入到数据表user中的注册成功显示页面：result2.asp代码如下：
&%@ language=vbscript %& &!-- #include file=&con1.asp&--& &html & &head& &meta http-equiv=&Content-Type& c...
其他类似问题
为您推荐：
mysql的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁mysql - SQL - IF EXISTS UPDATE ELSE INSERT INTO - Stack Overflow
to customize your list.
Stack Overflow is a community of 4.7 million programmers, just like you, helping each other.
J it only takes a minute:
Join the Stack Overflow community to:
Ask programming questions
Answer and help your peers
Get recognized for your expertise
What I'm trying to do is INSERT subscribers in my database, but IF EXISTS it should UPDATE the row, ELSE INSERT INTO a new row.
Ofcourse I connect to the database first and GET the $name, $email and $birthday from the url string.
$con=mysqli_connect("localhost","---","---","---");
// Check connection
if (mysqli_connect_errno())
echo "Failed to connect to MySQL: " . mysqli_connect_error();
$name=$_GET['name'];
$email=$_GET['email'];
$birthday=$_GET['birthday'];
This works, but j
mysqli_query($con,"INSERT INTO subs (subs_name, subs_email, subs_birthday)
VALUES ('$name', '$email', '$birthday')");
mysqli_close($con);
Here's what I
mysqli_query($con,"INSERT INTO subs (subs_name, subs_email, subs_birthday)
VALUES '$name', '$email', '$birthday'
ON DUPLICATE KEY UPDATE subs_name = VALUES($name), subs_birthday = VALUES($birthday)");
mysqli_close($con);
mysqli_query($con,"IF EXISTS (SELECT * FROM subs WHERE subs_email='$email')
UPDATE subs SET subs_name='$name', subs_birthday='$birthday' WHERE subs_email='$email'
INSERT INTO subs (subs_name, subs_email, subs_birthday) VALUES ('$name', '$email', '$birthday')");
mysqli_close($con);
mysqli_query($con,"IF NOT EXISTS(SELECT * FROM subs WHERE subs_email='$email')
INSERT INTO subs (subs_name, subs_email, subs_birthday)
VALUES ('$name', '$email', '$birthday')
mysqli_close($con);
But none of them work, what am I doing wrong?
Any help is greatly appreciated!
on your subs_email column, if one does not already exist:
ALTER TABLE subs ADD UNIQUE (subs_email)
INSERT INTO subs
(subs_name, subs_email, subs_birthday)
ON DUPLICATE KEY UPDATE
= VALUES(subs_name),
subs_birthday = VALUES(subs_birthday)
You can use the VALUES(col_name) function in the UPDATE clause to
refer to column values from the INSERT portion of the INSERT ... ON
DUPLICATE KEY UPDATE -
Note that I have used parameter placeholders in the place of string literals, as one really should be using parameterised statements to .
2,53554187
76.8k1290132
Your Answer
Sign up or
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Post as a guest
By posting your answer, you agree to the
Not the answer you're looking for?
Browse other questions tagged
Stack Overflow works best with JavaScript enabled}