MySQL创建表语句

最新推荐文章于 2024-09-19 16:47:21 发布

iteye_8264

最新推荐文章于 2024-09-19 16:47:21 发布

阅读量144

点赞数

文章标签：数据库

/*表： t_admin_tabs*/---------------------

/*列信息*/-----------

Field       Type              Collation        Null    Key     Default  Extra   Privileges                       Comment       
----------  ----------------  ---------------  ------  ------  -------  ------  -------------------------------  --------------
admin_id    int(11) unsigned  (NULL)           NO      PRI     (NULL)           select,insert,update,references  编号        
name        varchar(50)       utf8_general_ci  NO              (NULL)           select,insert,update,references  用户名     
password    varchar(50)       utf8_general_ci  NO              (NULL)           select,insert,update,references  密码        
login_time  datetime          (NULL)           NO              (NULL)           select,insert,update,references  登录时间  

/*索引信息*/--------------

Table         Non_unique  Key_name  Seq_in_index  Column_name  Collation  Cardinality  Sub_part  Packed  Null    Index_type  Comment  
------------  ----------  --------  ------------  -----------  ---------  -----------  --------  ------  ------  ----------  ---------
t_admin_tabs           0  PRIMARY              1  admin_id     A                    0    (NULL)  (NULL)          BTREE                

/*DDL 信息*/------------

CREATE TABLE `t_admin_tabs` (
  `admin_id` int(11) unsigned NOT NULL COMMENT '编号',
  `name` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(50) NOT NULL COMMENT '密码',
  `login_time` datetime NOT NULL COMMENT '登录时间',
  PRIMARY KEY  (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8