mysql基础知识

mysql创建数据表

CREATE  TABLE `user`(
//创建里面的内容并且设置里面的类型
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `uname` varchar(20) COLLATE utf8mb4_unicode_ci NO NULL COMMENT '用户名',
   `pwd` varchar(20) COLLATE utf8mb4_unicode_ci NO NULL ,
   `gender`  tinyint(1)  unsigned NOT NULL  COMMENT' 1男0女',
   `create_time` int(10)  unsigned NOT NULL,
   `updata_time` timeStamp NOT NULL DEFAULT current_timestamp() ON UPDATE;
   current_timestamp(),
   PRIMARY KEY(`id`),
   UNIQUE KEY  `uname`(`uname`)
)