CREATE DATABASE test;
use test;
create table TABLE5(
  	STOCK varchar(20),
	SYMBOL varchar(20),
	SHARETYPE varchar(10),
	PRICE float,
    PROVINCE VARCHAR(20)
);
insert into TABLE5 values('平安银行','000001','A',69.97,'广东省');
insert into TABLE5  values('长安B','200625','B',7.11,'重庆市');
insert into TABLE5  values('比亚迪','002594','A',172.78,'广东省');
insert into TABLE5  values('东信B','900941','B',0.47,'浙江省');

select * from TABLE5;
select symbol from TABLE5;
select distinct sharetype from TABLE5;
select stock,symbol from TABLE5;
select * from TABLE5 limit 2;
select * from TABLE5 where SHARETYPE='A';
select stock from TABLE5 where sharetype='A';
select * from TABLE5 where symbol like '0%';
select * from TABLE5 where symbol like '%1';
select * from TABLE5 where symbol like '%9%';
select * from TABLE5 where symbol not like '%9%';
select * from TABLE5 where sharetype='A' and PROVINCE='广东省';
select * from TABLE5 where price='7.11' or sharetype='B';
select * from TABLE5 where sharetype='B' and (PROVINCE='广东省'
or PROVINCE='浙江省');
select * from TABLE5 where price between 0 and 10;
select * from TABLE5 where price not between 0 and 10;

select * from TABLE5 order by sharetype;
select * from TABLE5 order by sharetype,price;
select * from TABLE5 order by price desc;
select * from TABLE5 order by sharetype asc,price desc;