## 刪除/軟刪除 **警告**刪除記錄時，需要確保其主要字段具有值，GORM將使用主鍵刪除記錄，如果主要字段為空，GORM將刪除模型的所有記錄 ~~~ // 刪除存在的記錄 db.Delete(&email) //// DELETE from emails where id=10; // 為Delete語句添加額外的SQL選項 db.Set("gorm:delete_option", "OPTION (OPTIMIZE FOR UNKNOWN)").Delete(&email) //// DELETE from emails where id=10 OPTION (OPTIMIZE FOR UNKNOWN); ~~~ ### 1. 批量刪除 刪除所有匹配記錄 ~~~ db.Where("email LIKE ?", "%jinzhu%").Delete(Email{}) //// DELETE from emails where email LIKE "%jinhu%"; db.Delete(Email{}, "email LIKE ?", "%jinzhu%") //// DELETE from emails where email LIKE "%jinhu%"; ~~~ ### 2. 軟刪除 如果模型有`DeletedAt`字段，它將自動獲得軟刪除功能！ 那么在調用`Delete`時不會從數據庫中永久刪除，而是只將字段`DeletedAt`的值設置為當前時間。 ~~~ db.Delete(&user) //// UPDATE users SET deleted_at="2013-10-29 10:23" WHERE id = 111; // 批量刪除 db.Where("age = ?", 20).Delete(&User{}) //// UPDATE users SET deleted_at="2013-10-29 10:23" WHERE age = 20; // 軟刪除的記錄將在查詢時被忽略 db.Where("age = 20").Find(&user) //// SELECT * FROM users WHERE age = 20 AND deleted_at IS NULL; // 使用Unscoped查找軟刪除的記錄 db.Unscoped().Where("age = 20").Find(&users) //// SELECT * FROM users WHERE age = 20; // 使用Unscoped永久刪除記錄 db.Unscoped().Delete(&order) //// DELETE FROM orders WHERE id=10; ~~~