2）delete
示例：
delete from personinfo
delete from personinfo where index cardid cardid =
'123456789012345680'
3）update
示例：
update personinfo set age = age + 1
update personinfo set Sex = 0, name= '王0', Age = 21, address = ,
'广东省深圳市南山区0栋', email = 'wangling@cacheserver.com.cn' where
index cardid cardid = '123456789012345680'
4）insert
5）match
6）group by
Cache SQL支持分组聚合函数：max、min、sum、count、avg和多列分组
功能, 示例如下：
select sum(remainder) + min(remainder), avg(remainder), count(*) from orderinfo group by phone
select phone, sum(remainder) + min(remainder), avg(remainder), count(*) from orderinfo group by phone
select phone, sum(remainder) + min(remainder), avg(remainder), count(*) from orderinfo group by phone
select spid,servicecode, count(*), sum(remainder) from orderinfo group by spid, servicecode
7）having
select phone, count(*),from orderinfo group by phone having filter sum(remainder) > 1000
select phone, sum(remainder) + min(remainder), avg(remainder),count(*) from orderinfo group by phone having index phone phone = '13912345671' filter count(*) > 1
8）order by
支持单列和多列排序，支持分组排序功能，示例如下：
select cardid, age, name from personinfo order by age
select cardid, age, name from personinfo order by age asc
select cardid, age, name from personinfo order by age desc
select * from orderinfo order by spid, serviceid, phone
select phone, count(*) from orderinfo group by phone order by
count(remainder)
select phone, count(*) from orderinfo group by phone order by count(remainder)
open personcursor for select * from personinfo
fetch first from personcursor into @cardid,@sex,@name,@age,@address,@salary
while(@@fetch_status = 0)
begin
print i64tos(@cardid, 10) + ' ' +itos(@sex, 10) + ' ' + @name+ ' ' + itos(@age, 10) + ' ' + @address + ' '+ itos(@salary , 10)
fetch next from personcursor into
@cardid,@sex,@name,@age,@address,@salary
end
close personcursor
