Pokud mezi employees a departments existuje FK bez ON DELETE CASCADE, jak lze ručně simulovat kaskádové mazání pro oddělení 50?

Question

Pokud mezi employees a departments existuje FK bez ON DELETE CASCADE, jak lze  ručně simulovat kaskádové mazání  pro oddělení 50?

Answer

Nelze, bez ON DELETE CASCADE není mazání povoleno.

Answer

DELETE FROM employees; DELETE FROM departments;

Answer

DELETE FROM departments WHERE departmentid = 50; následně DELETE FROM employees WHERE departmentid = 50;

Answer

DELETE FROM employees WHERE departmentid = 50; následně DELETE FROM departments WHERE departmentid = 50;

Crowdly