CREATE DATABASE test;
use test;
create table TABLE1 (
stock varchar(20),
symbol char(6),
sharetype char(1),
tradedate date,
price decimal(10,2)
);
insert into TABLE1 (stock,symbol,sharetype,tradedate,price) values('平安银行','000001','A','2021-05-28', 69.97);
insert into TABLE1(stock,symbol,sharetype,tradedate,price) values ('平安银行', '000001', 'A', '2021-05-20', 69.97);
insert into TABLE1(stock,symbol,sharetype,tradedate,price) values ('长安B', '200625', 'B', '2021-05-20', 7.11);
insert into TABLE1(stock,symbol,sharetype,tradedate,price) values ('ST星源', '000005', 'A', '2021-05-20', 1.82);
INSERT INTO TABLE1(STOCK,SHARETYPE)VALUES('比亚迪', 'A');
ALTER TABLE TABLE1 ADD (PROVINCE varchar(10));
UPDATE TABLE1 SET PRICE=70.2 WHERE STOCK='平安银行';
UPDATE TABLE1 SET PRICE=70.15,SYMBOL='000002' WHERE STOCK='平安银行';
DELETE FROM TABLE1 WHERE STOCK='平安银行';
DELETE FROM TABLE1;
INSERT INTO TABLE1(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('ST星源',000005, 'A', 1.82, '广东省');
INSERT INTO TABLE1(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('北京城乡',600861, 'A', 14.38, '北京市') ;
INSERT INTO TABLE1(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('三环集团',300408, 'A',37.41, '广东省') ;
INSERT INTO TABLE1(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('万科A',000002, 'A',26.77, '广东省') ;
INSERT INTO TABLE1(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('南玻B',200012, 'B',3.58, '广东省') ;
UPDATE TABLE1 SET PRICE=16.25 WHERE STOCK='平安银行';
DELETE FROM TABLE1 WHERE STOCK='B';
DELETE FROM TABLE1 WHERE STOCK='平安银行';
INSERT INTO TABLE1 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)VALUES('平安银行',000001, 'A',16.25, '广东省');
create table TABLE3 (
bankcd varchar(20),
shortbnm char(6),
stkcd char(1),
typrep char,
cash decimal(20)
);
insert into TABLE3 (bankcd,shortbnm,stkcd,typrep,cash) values('北京银行','000021','601169','B', 184491000000);
insert into TABLE3 (bankcd,shortbnm,stkcd,typrep,cash) values('杭州银行','000077','600927','D', 68901675000);