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

mysql不能执行两条insert吗?

WBOY
Release: 2016-06-23 09:15:05
Original
1150 people have browsed it

$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')";
Copy after login

这样就不行,报错提示: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')
Copy after login


回复讨论(解决方案)

改成

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

source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template