λ°μν
delete : λ°μ΄ν° μμ
DELETE FROM table
WHERE condition ;
delete from departments
where department_name = 'Finance';
-- departments λΆμμμ λΆμ μ΄λ¦μ΄ Finance μΈ νμ μμ
* Error Code: 1451. Cannot delete or update a parent row: a foreign key constraint fails
- foeign keyμ primary key κ΄κ³κ° μμ κ²½μ° μμκ°μ΄ μμ λ λΆλͺ¨κ°μ μμ νλ©΄ μλ¬ λ°μ
select *
from employees
where department_name = 'Finace';
-- department_name μ΄ 'Finace'μΈ μ§μμ΄ μ‘΄μ¬νλ μ§ νμΈ
* delete μμ μ where μ μλ΅ν κ²½μ°
=> ν΄λΉ ν μ΄λΈμ λͺ¨λ νμ΄ μμ λ¨
* Query λ©λ΄μμ Auto-Commit Transactions μ μ²΄ν¬ λμ΄ μμΌλ©΄ DML μ€ν μ λ°λ‘ μ μ₯λμ΄ μμ λΆκ°.
= μλ 컀λ°
Auto-Commit Transactions μ²΄ν¬ ν΄μ μ μμ κ°λ₯
= μλ 컀λ°, μλ λ‘€λ°± κ°λ₯
-- mysql λ¬Έλ²(commit, rollback)
commit;
rollback;
λ°μν
'STUDY > DATABASE' μΉ΄ν κ³ λ¦¬μ λ€λ₯Έ κΈ
MYSQL - μ°μ΅λ¬Έμ (DML) (0) | 2022.05.02 |
---|---|
MYSQL - TCL(νΈλμμ μ μ΄μ΄) (0) | 2022.05.02 |
MySQL - λ¨μΌ ν ν¨μ(λ¬Έμν¨μ) (0) | 2022.04.15 |
MySQL - JOIN (0) | 2022.04.12 |
MySQL - ERD λ§λ€κΈ° (0) | 2022.04.12 |