编辑代码

CREATE DATABASE 项目a;
show DATABASES;
use 项目a:
show TABLES:
CREATE TABLE sdb(sdbh int primary key not null,sdm varchar(10)
not null,dz varchar(10)not null,dh int not null );
show TABLES:
desc sdb:
INSERT INTO sdb VALUES(1,'京东','火星'，123);
INSERT INTO sdb VALUES(2,'京南','太阳'，456);
INSERT INTO sdb VALUES(3,'京西','地球'，789);
SELECT * FROM sdb;
use 项目a;
CREATE TABLE gkd(gkdh int primary key not null,xm char(10)
not null,dz varchar(10) null,nl int null,xb char(10) null );
show TABLES;
desc gkd;
INSERT INTO gkd VALUES(1,'小明','小明家',20,'男');
INSERT INTO gkd VALUES(2,'小吴','小吴家',30,'男');
INSERT INTO gkd VALUES(3,'小南','小南家',40,'男');
SELECT * FROM gkd;
use 项目a;
CREATE TABLE gmb(sdbh int not null,gkbh int not null,primary key(sdbh,gkbh),
xfje double null,rq datetime null );
show TABLES;
desc gmb;
INSERT INTO gmb VALUES(1,1,'11.1','2022-11-2 11:18:30');
INSERT INTO gmb VALUES(2,2,'13.7','2022-10-9 17:12:20');
INSERT INTO gmb VALUES(3,3,'16.9','2022-9-9 18:11:10');
SELECT * FROM gmb;

CREATE DATABASE 项目b;
show DATABASES;
use 项目b;
show TABLES;
CREATE TABLE xsb(xh int primary key not null,xm char(10)
not null,dz varchar(10)null,nl int null,xb char(10)null );
show TABLES;
desc xsb;
INSERT INTO xsb VALUES(1,'小李','小李家',10,'男');
INSERT INTO xsb VALUES(2,'小楠','小楠家',11,'女');
INSERT INTO xsb VALUES(3,'小萧','小萧家',14,'女');
SELECT *FROM xsb;
use 项目b;
CREATE TABLE kcb(kch int primary key not null,kcm char(10)not null );
show TABLES;
desc kcb;
INSERT INTO kcb VALUES(1,'英语');
INSERT INTO kcb VALUES(2,'数学');
INSERT INTO kcb VALUES(3,'语文');
SELECT * FROM kcb;
use 项目b;
CREATE TABLE xxb(xh int not null,kch int not null,primary key(xh,kch),
cj float(10)not null);
show TABLES;
desc xxb;
INSERT INTO xxb VALUES(1,1,90.5);
INSERT INTO xxb VALUES(2,2,95.5);
INSERT INTO xxb VALUES(3,3,99.5);
SELECT * FROM xxb;
use 项目b;
show TABLES;
CREATE TABLE jsb(zgh int primary key not null,jsm char(10)
not null,zc varchar(10)null,kch int not null);
show TABLES;
desc jsb;
INSERT INTO jsb VALUES(1,'李老师','英语老师'，1);
INSERT INTO jsb VALUES(2,'吴老师','数学老师',2);
INSERT INTO jsb VALUES(3,'张老师','语文老师',3);
SELECT * FROM jsb;

CREATE DATABASE 项目c;
show DATABASES;
use 项目c;
show TABLES;
CREATE TABLE splbb(lbid int primary key not null,lbmc char(10)nit null );
show TABLES;
desc splbb;
INSERT INTO splbb VALUES(1,'消耗类');
INSERT INTO splbb VALUES(2,'工具类');
INSERT INTO splbb VALUES(3,'食品类');
SELECT * FROM splbb;
use 项目c;
CREATE TABLE spd(spid int primary key not null,lbid int not null,spbh int not null，
spmc char(10) not null ,jg float(10) not null,kcsl int null,xssl int null sjsj datetime null,
sfrx char(10) null);
show TABLES;
desc spd;
INSERT INTO spb VALUES(1,1,1,'小布丁','2020-9-20 11:18:40','是');
INSERT INTO spb VALUES(2,2,2,'碎冰冰','2021-8-23 14:19:30','是');
INSERT INTO spb VALUES(3,3,3,'老冰棍','2020-9-21 18:16:20','是');
SELECT * FROM spb;
use 项目c;
CREATE  TABLE hyb(hyid int primary key not null, yhm char (10) not null,mm int null,
xb char（10)null,jf float(10) null,zcsj datetime null）;
show TABLESl;
desc hyb;
INSERT INTO hyb VALUES(1,'第一',123,'男',50.8,'2023-9-20 12:00:01');
INSERT INTO hyb VALUES(2,'第二',456,'男',53.4,'2023-9-20 12:00:20');
INSERT INTO hyb VALUES(3,'第三',789,'男',55.5,'2023-9-20 12:00:28');
SELECT * FROM hyb;
use 项目c;
show TABLES;
CREATE TABLE ddb(ddib int primary key not null,
ddje float(10) null,xdsj datetime null);