MySQL学习笔记-Part2

MySQL 学习笔记 Part2

学习链接来自黑马程序员： https://www.bilibili.com/video/BV1Kr4y1i7ru/?p=22&share_source=copy_web&vd_source=c76bb3d6e0326c966bf1bf32db90eb22

创建一个表

create table emp(
    id int comment "编号",
    workno varchar(10) comment "工号",
    name varchar(10) comment "姓名",
    gender char(1) comment "性别",
    age tinyint unsigned comment "年龄",
    idcard char(18) comment "身份证号",
    entrydate date comment "入职时间"
) comment "员工表";