Home  >  Article  >  Backend Development  >  mysql不能执行两条insert吗?

mysql不能执行两条insert吗?

WBOY
WBOYOriginal
2016-06-23 09:15:051113browse

$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')");
就成功了

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn