create table userdef(
'id' INT NOT NULL AUTO_INCREMENT,'username' VARCHAR(30),'password' VARCHAR(30),'sex' VARCHAR(8),'email' VARCHAR(50),'time' DATETIME,'sale' VARCHAR(4),'level' VARCHAR(20),'point' INT,PRIMARY KEY('id'),UNIQUE KEY'username'('username')
);ERROR 1064 (42000): 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 ''id'
int NOT NULL AUTO_INCREMENT,'username' varchar(30),'password' varchar(30),'' at
line 1请帮忙解答下!搜了些帖子 大部分出现这种问题好像是因为版本问题?
请帮忙告诉 我创建表的语法里应该怎么修改!
'id' INT NOT NULL AUTO_INCREMENT,'username' VARCHAR(30),'password' VARCHAR(30),'sex' VARCHAR(8),'email' VARCHAR(50),'time' DATETIME,'sale' VARCHAR(4),'level' VARCHAR(20),'point' INT,PRIMARY KEY('id'),UNIQUE KEY'username'('username')
);ERROR 1064 (42000): 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 ''id'
int NOT NULL AUTO_INCREMENT,'username' varchar(30),'password' varchar(30),'' at
line 1请帮忙解答下!搜了些帖子 大部分出现这种问题好像是因为版本问题?
请帮忙告诉 我创建表的语法里应该怎么修改!
[align=center]==== 思想重于技巧 ====
[/align]
);就不行 还是1064错误!可我直接用MYSQL控制台 DOS窗口 就可以执行! 这是什么原因?