Zapytania SQL

Czyszczenie tabeli z pominięciem sprawdzania kluczy obcych

SET FOREIGN_KEY_CHECKS = 0; 
TRUNCATE TABLE nazwa_tabeli;
SET FOREIGN_KEY_CHECKS = 1;

SELECT TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, 
REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME 
FROM INFORMATION_SCHEMA. KEY_COLUMN_USAGE 
WHERE REFERENCED_TABLE_SCHEMA = 'db_name' 
AND REFERENCED_TABLE_NAME = 'table_name' 
AND REFERENCED_COLUMN_NAME = 'column_name'

SET FOREIGN_KEY_CHECKS=0;