Answers for "mysql delete row and all references"

delete all rows from table mysql

-- Quick, no possible rollback
TRUNCATE TABLE my_table;
-- With rollback
DELETE FROM my_table;
COMMIT;

Posted by: Guest on January-23-2021

forcefully delete a row in mysql which has references

SET FOREIGN_KEY_CHECKS=0;
DELETE FROM forum WHERE Owner_Id = 1 ORDER BY nright;
SET FOREIGN_KEY_CHECKS=1;

Posted by: Guest on April-13-2021

Code answers related to "mysql delete row and all references"