What are DDL and DML?
I have heard the terms DDL and DML in reference to databases, but I don’t understand what they are. What are they and how do they relate to SQL? 13 Answers 13
dml
How to truncate a foreign key constrained table?
Why doesn’t a TRUNCATE on mygroup work? Even though I have ON DELETE CASCADE SET I get: ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (mytest.instance, CONSTRAINT instance_ibfk_1 FOREIGN KEY (GroupID) REFERENCES mytest.mygroup (ID)) drop database mytest; create database mytest; use mytest; CREATE TABLE mygroup ( ID INT NOT NULL … Read more
