mysql at lin1_MYSQL错误：MySQL server version for the right syntax to use near '1' at line 1

PHP插入数据$linkDB01=mysql_connect("local","amount","code");mysql_select_db("blueShine01",$linkDB01);mysql_query("setnamesutf8;");$insert01=mysql_query("INSERTINTObarCode...

PHP插入数据

$linkDB01 = mysql_connect("local","amount","code");

mysql_select_db("blueShine01", $linkDB01);

mysql_query("set names utf8;");

$insert01 = mysql_query( "INSERT INTO barCodeTB01 (barCode, uploadTime, agencyName, queryTime, checkTime)VALUES('112233445566', '20140908', '哈哈', NOW(), '1') ");

//插入数据

if (!mysql_query($insert01,$linkDB01)) { die('Error: ' . mysql_error()); } else { echo "1 record added"; };

//询问是否插入数据成功

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') ");

//赋值插入数据这一句是不能加mysql_query()的

改成：

$insert01 = "INSERT INTO barCodeTB01 (barCode, uploadTime, agencyName, queryTime, checkTime)VALUES('112233445566', '20140908', '哈哈', NOW(), '1')";

//这样就没问题了萌萌哒~~

展开