MySQL第七章保险管理系统建表源代码

CREATE DATABASE insurance

USE insurance

CREATE TABLE uses
(
    nameId INT(4) PRIMARY KEY AUTO_INCREMENT COMMENT'用户id',
    NAME VARCHAR(20) NOT NULL COMMENT'姓名',
    sex VARCHAR(10) NOT NULL COMMENT'性别',
    birthday VARCHAR(30) NOT NULL COMMENT'生日',
    identityCard VARCHAR(18) UNIQUE KEY NOT NULL COMMENT'身份证',
    iphoneNum VARCHAR(11) NOT NULL COMMENT'联系电话',
    address VARCHAR(20) COMMENT'地址',
    pwd VARCHAR(20) NOT NULL COMMENT'密码'
)COMMENT'用户表'
DROP TABLE uses 

SELECT * FROM uses

INSERT INTO uses(NAME,sex,birthday,identityCard,iphoneNum,address,pwd)
VALUES('王文利','男','1994/2/4','430681199402045653','13612345678','上海','123456'),
('任仙怡','女','2000/1/3','450000200001034500','13812345678','北京','1