վsqlָϤǧҲߴһЩsql

1ȵ˽ݿеݱ,ǳõݱ(ͽΪ):
   b             Ʒݱ
   l             ¼ݱ
   npc           npcݱ
   p             ݱ
   r             ݱ
   û          ûݱ
2һǶǶݿеûвģûкֶܶΣ磺IDԱ书ȼgradeȵȣЩҶ֪ģҲ׼ǵסģһЩƷֶЩüǵģ
    w1   ҩƷ
    w2   ҩ
    w3   װ
    w4   
    w5   Ƭ
    w6   Ʒ
    w7   ʻ
    w8   ҩ
    w9   ħ
    w10  
    z1   ͷ
    z2   װ
    z3   
    z4   
    z5   
    z6   ˫
3SQLָõľ޸ĺɾˣ﷨
   ޸ģupdate ݱ set ֶ1=ִʽ1,ֶ2=ִʽ2... where ʽ
   ɾdelete * from ݱ where ʽ

   whereıʽ˵磬Եȼ100ϲ2Ա˲ʽдΪȼ>100 and Աȼ=2  (notandor㲻ĻͲҪЩˣԲûƣֱʡwhereԼݼ
   һ㶼ǶûݽдģֻЩûsqlָ
   1update û set =+100,Ա='' where =''
       sql޸Ϊû100ͬʱԱĳУжԱ=''ĺӶٸϱʽˣעĶűǰǷ,һҿԿΪʲôû'ĵأΪֵݣַֻͺͱעͲſ߼ӵ'ģֻǵ˫ŵģμ
   2delete * from û where allvalue<5
       sqlɾܻС5û

4кüͲˣͨsqlֶݱȣЩôҲȽ٣ᳫʹõ
5йسsqlָҿں̨sqlָҵ