database-delete from table_name 和 delete * from table_name 區別？

delete from table_name 和 delete * from table_name 區別？

sql標准中有 delete * from 這樣的語句嗎？為什麼有的數據庫可以用 delete * from table_name ?

最佳回答：

delete * from table_name僅僅能刪除表中數據，不能清空標識，刪除表中數據後再重新寫入數據時，標識符會從刪除前標識最大加1開始。希望對您有幫助！