编辑代码

CREATE DATABASE 项目a;
use 项目a;
show TABLES;
CREATE TABLE khjbxxb(zha int primary key,sfz int,xm varchar(10),xb char(2),sr date,zz varchar(10),
dh int,yx int,gs varchar(10),nl int);
show TABLES;
desc khjbxxb;
INSERT INTO khjbxxb VALUES(1,1,'小王','男','1992-09-11','王家',12345678,12345678,'王氏集团',28);
INSERT INTO khjbxxb VALUES(2,2,'小李','男','1992-12-11','李家',2345678,2345678,'李氏集团',26);
INSERT INTO khjbxxb VALUES(3,3,'小东','男','1992-10-11','东家',345678,345678,'东氏集团',24);
INSERT INTO khjbxxb VALUES(4,4,'小明','男','1992-04-11','明家',45678,45678,'明氏集团',22);
INSERT INTO khjbxxb VALUES(5,5,'小贝','男','1992-06-11','贝家',2345678,2345678,'贝氏集团',26);
SELECT * FROM khjbxxb;