SQL+parser 源代码

select 光盘编号=gph ,光盘名称=gpmc,光盘语言=gpyy from gpb where gph between 2 and 7

select * from employee where ygbh in ( 2,4,6)

select count(gpsm) as 'count',count(*) AS 'count(*)' from gpb

select exp(4) as '4的指数',log(100)as '100的对数', pi()as 圆周率,rand(3) as 随机函数 select sign(-19) as '-19的符号函数',sqrt(25) as '25的根号', squ…

select * from employee where ygxm like '[^李]%'

select * from ghsb order by 3 DESC

use diskrent select top 4 gph ,gpmc,gpyy,gpdj from gpb order by gph ASC

select gpcd as 光盘产地,gpyy as 光盘语言 , avg(gpdj) as 平均价格, sum(qnt) as 光盘总数 from gpb WHERE gph

select gpmc as 光盘名称 ,gpcd as 光盘产地 ,gpsm as 光盘说明 from gpb where gpmc like '[我垂]%'

update gpb_view set 数量=5 where 供货商编号=3 go select * from gpb_view