CREATE TABLE x2 mislykkedes
Når jeg prøver at køre følgende i PHP:$sql = "CREATE TABLE table1
(
FirstName varchar(15)
);
CREATE TABLE tabl2
(
FirstName varchar(15)
);"
mysql_query($sql,$con) or die('Could not connect: ' . mysql_error());;
mysql_close($con);
Får jeg følgende fejlmeddelelse:
"Could not connect: 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 'CREATE TABLE tabl2 ( FirstName varchar(15) )' at line 5"
MYSQL 5.1.36
PHP: 5.3.0