欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

mysql不能执行两条insert吗?

程序员文章站 2024-01-31 15:57:01
...
$sql = "INSERT INTO typecho_contents( title, created, modified, text, authorId, allowComment, allowPing, allowFeed )VALUES ('秘密#$mimiId', '$mimitime', '$mimitime', '$mimicontent', '1', '1', '1', '1');INSERT INTO typecho_relationships(cid, mid) VALUES ('$mimiId', '1')";

这样就不行,报错提示: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 'INSERT INTO typecho_relationships(cid, mid) VALUES ('23', '1')' at line 2

单独一句句写就只执行一句,在数据库直接执行下面这两句则可以成功。
INSERT INTO typecho_contents( title, created, modified, text, authorId, allowComment, allowPing, allowFeed )VALUES ('秘密#23', '147852369', '147852369', '为什么', '1', '1', '1', '1');INSERT INTO typecho_relationships(cid, mid) VALUES ('23', '1')


回复讨论(解决方案)

改成

$sql1=mysql_query("INSERT INTO typecho_contents( title, created, modified, text, authorId, allowComment, allowPing, allowFeed )VALUES ('秘密#$mimiId', '$mimitime', '$mimitime', '$mimicontent', '1', '1', '1', '1')");$sql2=mysql_query("INSERT INTO typecho_relationships(cid, mid) VALUES ('$mimiId', '1')");
就成功了