哪出错了,我看一个教程跟着做的,数据库能创建出来,但里面的表却建不出来
[code=PHP][mysql_query("CREATE DATABASE `$mysql_dbname`");
mysql_select_db($mysql_dbname); $sql_query[] = "CREATE TABLE `".$mysql_tag."admin_log1`" .
"(`id` int(8) unsigned NOT_NULL auto_increment," .
"`username` varchar(40) NOT_NULL COMMENT '操作用户名称'," .
"`types` varchar(60) NOT_NULL," .
"PRIMARY KEY(`id`))";
$sql_query[] = "CREATE TABLE `".$mysql_tag."admin_log2`" .
"(`id` int(8) unsigned NOT_NULL auto_increment," .
"`username` varchar(40) NOT_NULL COMMENT '操作用户名称'," .
"`types` varchar(60) NOT_NULL," .
"PRIMARY KEY(`id`))"; $sql_query[] = "CREATE TABLE `".$mysql_tag."admin_log3`" .
"(`id` int(8) unsigned NOT_NULL auto_increment," .
"`username` varchar(40) NOT_NULL COMMENT '操作用户名称'," .
"`types` varchar(60) NOT_NULL," .
"PRIMARY KEY(`id`))";/code]
[code=PHP][mysql_query("CREATE DATABASE `$mysql_dbname`");
mysql_select_db($mysql_dbname); $sql_query[] = "CREATE TABLE `".$mysql_tag."admin_log1`" .
"(`id` int(8) unsigned NOT_NULL auto_increment," .
"`username` varchar(40) NOT_NULL COMMENT '操作用户名称'," .
"`types` varchar(60) NOT_NULL," .
"PRIMARY KEY(`id`))";
$sql_query[] = "CREATE TABLE `".$mysql_tag."admin_log2`" .
"(`id` int(8) unsigned NOT_NULL auto_increment," .
"`username` varchar(40) NOT_NULL COMMENT '操作用户名称'," .
"`types` varchar(60) NOT_NULL," .
"PRIMARY KEY(`id`))"; $sql_query[] = "CREATE TABLE `".$mysql_tag."admin_log3`" .
"(`id` int(8) unsigned NOT_NULL auto_increment," .
"`username` varchar(40) NOT_NULL COMMENT '操作用户名称'," .
"`types` varchar(60) NOT_NULL," .
"PRIMARY KEY(`id`))";/code]
用楼上的方法先确定一下SQL语句是否正确,拼接字符串的方式比较容易出错,特别是单引号这些
`id` int( 8 ) unsignedNOT_NULL AUTO_INCREMENT ,
`username` varchar( 40 ) NOT_NULL COMMENT '操作用户名称',
`types` varchar( 60 ) NOT_NULL,
PRIMARY KEY ( `id` )
)
#1064 - 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 'NOT_NULL auto_increment,`username` varchar(40) NOT_NULL COMMENT 'æ“语法错误,在哪里呢?
中间没有下划线