删除一个表中ID=11 到ID=130 所有的记录，怎么写SQL 语句

[seima]

删除一个表中ID=11 到ID=130 所有的记录，怎么写SQL 语句

[cheny1234]

delete * from 表 where id>=11 and id<=130

[aierong]

delete from tablename
where id between 11 and 130

[haoguozhong]

同意cheny1234

[tqqonline]

delete * from yourtable where id between 11 and 130

[zjcxc]

delete from 表 where id between 11 and 130

[happy_0325]

delete * from yourtable where id between 11 and 130

[welyngj]

delete * from yourtable where id between 11 and 130
有语法错误。delete 后面不可以接*.

[maoyesky]

delete from yourtable where id between 11 and 130

[st_2000]

delete from yourtable where id between 11 and 130

[sdhdy]

delete 表 where id between 11 and 130