CREATE TABLE `dtserver`.`tab_user` (
`user_id` INTEGER UNSIGNED NOT NULL DEFAULT 0 AUTO_INCREMENT COMMENT '编号',
`user_user` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '用户名',
PRIMARY KEY(`user_id`)
)
ENGINE = InnoDB;Mysql Error Number 1067
invalid default value for 'user_id'
`user_id` INTEGER UNSIGNED NOT NULL DEFAULT 0 AUTO_INCREMENT COMMENT '编号',
`user_user` VARCHAR(20) NOT NULL DEFAULT '' COMMENT '用户名',
PRIMARY KEY(`user_id`)
)
ENGINE = InnoDB;Mysql Error Number 1067
invalid default value for 'user_id'
user_id INTEGER UNSIGNED NOT NULL DEFAULT 0 AUTO_INCREMENT,
user_user VARCHAR(20) NOT NULL DEFAULT '',
PRIMARY KEY(user_id)
);
我英文不好,,是什么意思??还有,在命令模式,怎么进mysql?
msyql