■ 在线等待 小问题 如何删除数据库中所有的记录 !

[zzlcn]

如果用一个 sql 语句删除所有记录?

如何删除 id 从 10-100 的所有记录?

[Jaron]

delete [tablename] where (id>=10 and id<=100)

[fusoft]

delect * ..会报错的！！！不能加* 号

delete [tablename] where id>=10 and id<=100

[trysun]

删除所有　　delete from tablename
删10-100　　delete from tablename where id>=10 and id<=100

[xieyj]

delete [tablename] where id between 10 and 100

[tianjy]

同上

[linzhifeng]

同上

[潜水的鱼]

楼上%已经说完了

[programmer11]

很简单的
删除所有记录　　 delete [tablename]
删10-100的记录　　delete [tablename] where id>=10 and id<=100
或者delete [tablename] where id between 10 and 100
不能加*，也不能用from的

[iamsangster]

来晚了，该说的都说了
删除所有　　 delete （from） tablename
删10-100　　delete from tablename where id>=10 and id<=100
好象删除所有的from可以省略！

[keekeep]

1. delete * from [tablename]
2. delete * from [tablename] where 字段=条件