删除一个指定日期的所有的数据的SQL语句怎么写？很急！

delete 表 where Edate between '2007-11-15' and '2007-11-16'

ok

delete from table_name where 日期='2007-11-15'

一楼的语句把16号也删除了，between and是一个闭区间
二楼的语法不对

delete 表 where Edate='2007-11-15'

delte * from 表 where EDATE = '2007-11-15'