Delete from orgData Where AttackName in('frooed','kitattack','bread') 建議分開寫,效率高
Delete from orgData Where AttackName='bread' Or AttackName='frooed' Or AttackName='kitattack' 就是這樣
Delete from orgData Where AttackName in('frooed','kitattack','bread')
Delete from orgData Where AttackName='bread' Or AttackName='frooed' Or AttackName='kitattack' 就是這樣。
同时请问一下:如果是把以 b开头的、f开头的、 k开头的一次性全部删除这个语句如何写?请高手回复!
delete from table1 where colum1 like 'b%' or colum1 like 'f%' or colum1 like 'k%'
posonhuang(自知才疏学浅) 写的是正确的。
问题是再来个brad,food,kick什么的,你这个 like 'b%' or colum1 like 'f%' or colum1 like 'k%' 怎么区分?
Delete from orgData Where AttackName in('frooed','kitattack','bread') delete from table1 where colum1 like 'b%' or colum1 like 'f%' or colum1 like 'k%'
Delete from orgData Where AttackName in('frooed','kitattack','bread')
建議分開寫,效率高
就是這樣
就是這樣。
like 'b%' or colum1 like 'f%' or colum1 like 'k%'
怎么区分?
delete from table1 where colum1 like 'b%' or colum1 like 'f%' or colum1 like 'k%'
posonhuang(自知才疏学浅) 写的就是正确的啊,晕。