mysql数据库——错误

 

正确：

DROP TABLE IF EXISTS `t_manager_info1`;
CREATE TABLE `t_manager_info1` (
  `mid` int(11) NOT NULL AUTO_INCREMENT,
  `username` char(20) not null,
  `password` char(20) not null,
  `system_role`  int(2) default 0 , 
  `user_role`  int(2)  default 0,
  `book_manage_role`  int(2) default 0,
  primary key(`mid`)
) ENGINE=InnoDB 

错误：

DROP TABLE IF EXISTS `t_manager_info1`;
CREATE TABLE `t_manager_info1` (
  `mid` int(11) NOT NULL AUTO_INCREMENT,
  `username` char(20) not null,
  `password` char(20) not null,
  `system_role`  int(2) default 0 , 
  `user_role`  int(2)  default 0,
  `book_manage_role`  int(2) default 0 
) ENGINE=InnoDB