MYSQL错误:MySQL server version for the right syntax to use near '1' at line 1PHP插入数据$linkDB01 = mysql_connect("local","amount","code");\x05mysql_select_db("blueShine01",$linkDB01);\x05mysql_query("set names utf8;");\x05$insert01 = mysql_q
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/02 02:47:11
![MYSQL错误:MySQL server version for the right syntax to use near '1' at line 1PHP插入数据$linkDB01 = mysql_connect(](/uploads/image/z/15089867-35-7.jpg?t=MYSQL%E9%94%99%E8%AF%AF%EF%BC%9AMySQL+server+version+for+the+right+syntax+to+use+near+%271%27+at+line+1PHP%E6%8F%92%E5%85%A5%E6%95%B0%E6%8D%AE%24linkDB01+%3D+mysql_connect%28%22local%22%2C%22amount%22%2C%22code%22%29%3B%5Cx05mysql_select_db%28%22blueShine01%22%2C%24linkDB01%29%3B%5Cx05mysql_query%28%22set+names+utf8%3B%22%29%3B%5Cx05%24insert01+%3D+mysql_q)
MYSQL错误:MySQL server version for the right syntax to use near '1' at line 1PHP插入数据$linkDB01 = mysql_connect("local","amount","code");\x05mysql_select_db("blueShine01",$linkDB01);\x05mysql_query("set names utf8;");\x05$insert01 = mysql_q
MYSQL错误:MySQL server version for the right syntax to use near '1' at line 1
PHP插入数据
$linkDB01 = mysql_connect("local","amount","code");
\x05mysql_select_db("blueShine01",$linkDB01);
\x05mysql_query("set names utf8;");
\x05$insert01 = mysql_query( "INSERT INTO barCodeTB01 (barCode,uploadTime,agencyName,queryTime,checkTime)VALUES('112233445566','20140908','哈哈',NOW(),'1') ");\x05
//插入数据
\x05if mysql_query($insert01,$linkDB01)) { die('Error:' .mysql_error()); } else { echo "1 record added"; };\x05
//询问是否插入数据成功
mysql_close($linkDB01);
数据可以成功插入,在数据库内能查到.但是同时的会页面也会返回
Error:You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '1' at line 1.
噢···知道了
$insert01 = mysql_query( "INSERT INTO barCodeTB01 (barCode,uploadTime,agencyName,queryTime,checkTime)VALUES('112233445566','20140908','哈哈',NOW(),'1') ");\x05
//赋值插入数据这一句是不能加mysql_query()的
改成:
$insert01 = "INSERT INTO barCodeTB01 (barCode,uploadTime,agencyName,queryTime,checkTime)VALUES('112233445566','20140908','哈哈',NOW(),'1')";
//这样就没问题了萌萌哒~
MYSQL错误:MySQL server version for the right syntax to use near '1' at line 1PHP插入数据$linkDB01 = mysql_connect("local","amount","code");\x05mysql_select_db("blueShine01",$linkDB01);\x05mysql_query("set names utf8;");\x05$insert01 = mysql_q
最好是能够有代码行的错误信息,就是说明你哪行代码对应的SQL语句出的问题,这样更好分析.
根据代码,目测可能有以下问题:
1
pstmt=conn.prepareStatement("select username from user where username=?");
pstmt.setString(1,shopname);
这段中如果shopname是null的话执行结果可能有问题,所以最好先判断以下shopname是否非null.
2
String sql ="insert into shop(shopname,price,number,brand,date) values ('"+shopname+"','"+price+"','"+number+"','"+brand+",'"+date+"');";
这个段中是否都是字符型?,还有就是'"+brand+",少了一个引号
这样可以么?