SQL 問題

drop table [table name]

2007-01-16 08:40:45 補充：
迷之企鵝, 你句delete from table where condition係delete 個 table 既Row, 唔係delete成個table~要delete table 係要用drop table [table name]

delete from table_name where condition

舉例

delete from history_table where acdate < current date - 1 year

即在 history_table 刪去一年以前的記錄