CREATE DATABASE test;
use test;

CREATE TABLE stock_info
(
STOCK varchar(20),
SYMBOL char(6),
SHARETYPE char(1),
PRICE decimal(10,2),
PROVINCE varchar(20)
);
SELECT * FROM stock_info;
SELECT SYMBOL FROM stock_info;
SELECT DISTINCT SHARETYPE FROM stock_info;
SELECT STOCK,SYMBOL FROM stock_info;
SELECT * FROM stock_info;
SELECT * FROM stock_info WHERE SHARETYPE='A';
SELECT STOCK FROM stock_info WHERE SHARETYPE='A';
select * FROM stock_info WHERE SYMBOL LIKE '0%';
select * FROM stock_info WHERE SYMBOL LIKE '%1';
select * FROM stock_info WHERE SYMBOL LIKE '%9%';
select * FROM stock_info WHERE SYMBOL NOT LIKE '%9%';
select * FROM stock_info WHERE SHARETYPE='A'AND PROVINCE='广东省';
SELECT * FROM stock_info WHERE PRICE=7.11 OR SHARETYPE='B';
SELECT * FROM stock_info WHERE SHARETYPE='B' AND (PROVINCE='广东省'OR PROVINCE='浙江省');
SELECT * FROM stock_info WHERE SHARETYPE='A' AND PROVINCE='广东省';
SELECT * FROM stock_info WHERE PRICE NOT BETWEEN 0 AND 10;
SELECT * FROM stock_info ORDER BY SHARETYPE;
SELECT * FROM stock_info ORDER BY SHARETYPE,PRICE;
SELECT * FROM stock_info ORDER BY PRICE DESC;
SELECT * FROM stock_info ORDER BY SHARETYPE ASC,PRICE DESC;
/*
CREATE TABLE TABLE4
(
STOCK varchar(20),
SYMBOL char(6),
SHARETYPE char(1),
PRICE decimal(10,2),
PROVINCE varchar(20)
);
SELECT * FROM TABLE4;
SELECT STOCK,SYMBOL FROM TABLE4;
SELECT STOCK,SYMBOL,PRICE FROM TABLE4 WHERE PRICE BETWEEN 30 AND 100 ORDER BY PRICE DESC;
*/
CREATE TABLE TABLE6
(
Stkcd varchar(20),
Trddt date,
Opnprc decimal(10,2),
Clsprc decimal(10,2),
Dnshrtrd varchar(20)
);
SELECT Stkcd,Dnshrtrd FROM TABLE6;
SELECT Stkcd,Opnprc FROM TABLE6;
SELECT Stkcd,Trddt,Clsprc FROM TABLE6 WHERE Clsprc BETWEEN 10 AND 20 ORDER BY Clsprc DESC;