Change a table name ALTER TABLE old_table RENAME new_table; Move a table from one database to another CREATE TABLE new_database_name.new_table_name LIKE original_database_name.original_table_name; INSERT new_database_name.new_table_name SELECT * FROM original_database_name.original_table_name; Difference between…
A foreign key with cascade delete means that if a record in the parent table is deleted, then the corresponding records in the child table (using the foreign key) will…
CREATE TABLE devices ( id INT AUTO_INCREMENT PRIMARY KEY, uniqueID int NOT NULL UNIQUE, firstName VARCHAR(100), secondName VARCHAR(100) ); INSERT INTO devices (firstName, secondName)VALUES ('James','Froggatt'); ... now INSERT INTO devices…