CREATE DATABASE test;
use test;
CREATE TABLE TABLE2
(
STOCK varchar(20),
SYMBOL char(6),
SHARETYPE char(1),
TRADEDATE date,
PRICE decimal(10,2),
PROVINCE varchar(10)
);
INSERT INTO TABLE2(STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE) VALUES('平安银行', '200012','B',3.58, '广东省') ;
INSERT INTO TABLE2(STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE) VALUES('长安B', '200625','B',7.11, '重庆市');
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.88, '广东省');
UPDATE TABLE2 SET PRICE=16.25 WHERE STOCK='平安银行';
DELETE FROM TABLE2 WHERE STOCK='B';
DELETE FROM TABLE2 WHERE STOCK='平安银行';
INSERT INTO TABLE2(STOCK, SYMBOL, SHARETYPE, PRICE, PROVINCE) VALUES('平安银行', '000001', 'A', 16.25, '广东省');