mysql建表语句有什么错误

Question

CREATE TABLE `test` (
`username` varchar(20) NOT NULL DEFAULT ,
`password` varchar(20) NOT NULL ,
`userid` integer(100) NOT NULL AUTO_INCREMENT ,
INDEX `username` (`username`)
)
;

Answer 1

CREATE TABLE `test` (
`username` varchar(20) NOT NULL DEFAULT '',
`password` varchar(20) NOT NULL ,
`userid` integer(100) NOT NULL AUTO_INCREMENT PRIMARY KEY,
INDEX `username` (`username`)
)
;本回答被提问者和网友采纳