有無邊個statement 可以將成個table delete???
急要.. 唔該!!
SQL 問題
2007-01-15 2:34 am
回答 (2)
2007-01-15 3:03 am
✔ 最佳答案
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]
2007-01-16 1:46 am
delete from table_name where condition
舉例
delete from history_table where acdate < current date - 1 year
即在 history_table 刪去一年以前的記錄
舉例
delete from history_table where acdate < current date - 1 year
即在 history_table 刪去一年以前的記錄
收錄日期: 2021-05-03 12:26:00
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070114000051KK04047