$sql.="INSERT INTO gt_photo(path,time)VALUES('1',NOW());";
$sql.="INSERT INTO gt_photo(path,time)VALUES('5',NOW());";
$sql.="INSERT INTO gt_photo(path,time)VALUES('3',NOW());";
$sql.="INSERT INTO gt_photo(path,time)VALUES('4',NOW());";
mysql_query($sql);
sql语句错误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 'INSERT INTO gt_photo(path,time)VALUES('5',NOW());INSERT INTO gt_photo(path,time)' at line 1
我记得原来这样写过是可以的,但不知道现在为什么不行了,难道是php,mysql版本换了,不支持了吗,还是我写错了
$sql.="INSERT INTO gt_photo(path,time)VALUES('5',NOW());";
$sql.="INSERT INTO gt_photo(path,time)VALUES('3',NOW());";
$sql.="INSERT INTO gt_photo(path,time)VALUES('4',NOW());";
mysql_query($sql);
sql语句错误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 'INSERT INTO gt_photo(path,time)VALUES('5',NOW());INSERT INTO gt_photo(path,time)' at line 1
我记得原来这样写过是可以的,但不知道现在为什么不行了,难道是php,mysql版本换了,不支持了吗,还是我写错了
解决方案 »
- mysql导入.sql好慢?
- MySQL怎么写if语句?
- mysql中的一对多查询问题
- 菜鸟问题:请问这个query如何写最简单?
- 求一个sql语句啊,查询一个字段里所有非数字的数据
- Mysql5.0, 我用Mysql administrator里edit table设置列的charset为gb2312可以生效,为啥设置table option为gb2312却不生效?
- MySQL5.0 MySQL4.1.15 MySQL4.0.26中的汉字问题
- 在mysql中,一个数据库内最多可以建立多少个表?
- create table 问题
- 数据中心linux系统会用workbench之类的图形界面工具吗?
- 再次发帖,求解Select的问题,一旦排序就无记录,郁闷啊~~~
- mysql在大文本里(longtext),模糊查询出一个单词,用like好像太慢了,有什么好的方法么?
('2',NOW()),('3',NOW()),('4',NOW())";
$sql.="INSERT INTO gt_photo(path,time)VALUES('1',NOW());";
mysql_query($sql);
$sql.="INSERT INTO gt_photo(path,time)VALUES('5',NOW());";
mysql_query($sql);
$sql.="INSERT INTO gt_photo(path,time)VALUES('3',NOW());";
mysql_query($sql);
$sql.="INSERT INTO gt_photo(path,time)VALUES('4',NOW());";
mysql_query($sql);
$sql.=$sql+"INSERT INTO gt_photo(path,time)VALUES('4',NOW());";