Home [SQL] Delete 刪除全部的資料
Post
Cancel

[SQL] Delete 刪除全部的資料

Posted Apr 16, 2011
By R
1 min read

要刪除所有資料時，若刪除的資料只有幾百或幾千筆還不會有什麼問題。
如果刪除幾百萬筆資料，或是刪除筆數相當多的時候，還是刪除資料本身來重做會比較快。

語法

1

DELETE FROM table_name

範例

刪除所有販賣資料

1

delete from 販賣資料
Notes, SQL
delete
This post is licensed under CC BY 4.0 by the author.
Contents