编辑代码

CREATE DATABASE 项目1;
use 项目1;
show TABLES;
CREATE TABLE qwe(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 qwe;
INSERT INTO qwe VALUES(1,1,'小w','男','1992-09-11','w家',123678,125678,'w氏集团',28);
INSERT INTO qwe VALUES(2,2,'小e','男','1992-12-11','e家',23478,23478,'e氏集团',26);
INSERT INTO qwe VALUES(3,3,'小r','男','1992-10-11','r家',34578,34578,'r氏集团',24);
INSERT INTO qwe VALUES(4,4,'小q','男','1992-04-11','q家',4578,4578,'q氏集团',22);
INSERT INTO qwe VALUES(5,5,'小t','男','1992-06-11','t家',235678,235678,'t氏集团',26);
SELECT * FROM qwe;

CREATE TABLE qwr(zhb int primary key,je float(10),nx char(10),blrq date,lx float(10),
zhye float(10));
show TABLES;
desc qwr;
INSERT INTO qwr VALUES(1,16373.3,'取钱','1958-09-17',20.4,16002.2);
INSERT INTO qwr VALUES(2,26465.4,'存钱','1968-08-11',120.4,2693.2);
INSERT INTO qwr VALUES(3,37805.3,'存钱','1969-03-11',397.3,5679.3);
INSERT INTO qwr VALUES(4,46792.4,'取钱','1973-02-11',456.2,4387.2);
INSERT INTO qwr VALUES(5,57988.6,'存钱','1792-09-11',454.6,678.9);
SELECT * FROM qwr;

CREATE TABLE qwt(cpdm int primary key,cpnx varchar(10),cpmc varchar(10),cpjg float(10),
sysc datetime);
show TABLES;
desc qwt;
INSERT INTO qwt VALUES(1,'理财','理财',1989.9,'1998-09-11 12:45:32');
INSERT INTO qwt VALUES(2,'发财','发财',1779.9,'1999-09-11 13:56:21');
INSERT INTO qwt VALUES(3,'赚钱','赚钱',1659.9,'1995-09-11 11:23:12');
INSERT INTO qwt VALUES(4,'投资','投资',1489.9,'1993-09-11 14:45:12');
INSERT INTO qwt VALUES(5,'炒股','炒股',1259.9,'1592-09-11 16:12:10');
SELECT * FROM qwt;