利用mysql建立一个犯罪人员信息表包括姓名性别出生日期身份证号随机插入十条信息

CREATE TABLE criminal_info ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), gender VARCHAR(10), birthday DATE, id_card VARCHAR(18) );

INSERT INTO criminal_info (name, gender, birthday, id_card) VALUES ('张三', '男', '1990-01-01', '310101199001010001'), ('李四', '男', '1985-02-02', '310101198502020002'), ('王五', '男', '1992-03-03', '310101199203030003'), ('赵六', '女', '1988-04-04', '310101198804040004'), ('钱七', '男', '1995-05-05', '310101199505050005'), ('周八', '女', '1986-06-06', '310101198606060006'), ('吴九', '男', '1991-07-07', '310101199107070007'), ('郑十', '女', '1987-08-08', '310101198708080008'), ('孙十一', '男', '1994-09-09', '310101199409090009'), ('朱十二', '女', '1989-10-10', '310101198910100010')