record >
delete

delete a Record or records(delete a raw data)

删除符合的数据(删除全列数据)

delete records from a Column's sell which is ___

删除整列数据,而数据某字段数据
必须完全符合条件值

<%

SQLDelete = "Delete  from aTable where aColumm='___' " 
conn.Execute SQLDelete

%>
-----------------------------------------

<%
Set rs= conn.Execute ("select * from aTable " )
if not rs.eof then 
 id=rs("id")
 FT=rs("Ftime")
 DD=DateDiff("m",FT,now)
   if DD>1 then
   SQLDelete = "Delete  from aTabl1 where id1='"&id&"'" 
   conn.Execute SQLDelete
   end if
end if
%>
Do not use [ Delete * from ] no *

<%
'----- to delete all datas from tb1 ----- no need " * "
SQLDelete = "Delete from tb1 " 
conn.Execute SQLDelete

%>

注意:是删除所有符合的数据列
可能是多于一笔....
所以不用使用:下一个(next)或计数(count)

compare with now
delete all raws which time different is bigger than one month

删除与现在时间有相差大于一个月时间的数据