CREATE DATABASE test;
use test;
CREATE table table2
(
STOCK varchar(20),
SYMBOL char(6),
SHARETYPE char(6),
TRADEDATE date(1),
PRICE decimal(10,2)
);
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('ST星源',000005, 'A', 1.82, '广东省');
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('北京城乡',600861, 'A', 14.38, '北京市') ;
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('三环集团',300408, 'A',37.41, '广东省') ;
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('万科A',000002, 'A',26.77, '广东省') ;
INSERT INTO TABLE2(STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE) VALUES('南玻B',200012, 'B',3.58, '广东省') ;
UPDATE TABLE2 SET PRICE=16.25 WHERE STOCK='平安银行';
DELETE FROM TABLE2 WHERE STOCK='平安银行';
INSERT INTO TABLE2 (STOCK,SYMBOL,SHARETYPE,PRICE,PROVINCE)VALUES('平安银行',000001, 'A',16.25, '广东省');
CREATE table table3
(
STOCK varchar(20),
SYMBOL char(6),
SHARETYPE char(6),
TRADEDATE date(1),
PRICE decimal(10,2)
);
INSERT INTO TABLE3 (Bankcd, Shortbtm, Stkcd, Typrep, Cash) VALUES
('000021', '北京银行', '601169', 'B', 184491000000),
('000077', '杭州银行', '600927', 'D', 689016750000);
UPDATE TABLE3 SET Stkcd = '600926' WHERE Shortbtm = '杭州银行' AND Stkcd = '600927';
DELETE FROM TABLE3 WHERE Typrep = 'D';
INSERT INTO TABLE3 (Bankcd, Shortbtm, Stkcd, Typrep, Cash) VALUES
('000014', '招商银行', '600036', 'B', 599416000000);