/SQL/Sql truncate table referencing itself

Sql truncate table referencing itself

-- Original:
UPDATE 'recursive' SET 'parent_id' = NULL WHERE 'parent_id' IS NOT NULL;
DELETE FROM 'recursive';

-- For Example:
UPDATE Items
	SET Items.ParentItemId = NULL 
    WHERE Items.ParentItemId IS NOT NULL;
DELETE FROM Items;
-- Or 
TRUNCATE TABLE Items;

Source: stackoverflow.com

Similar codes

0 vote104 views1 answer
List all permissions on a table in postgres
SQL
4 votes121 views2 answers
Bulk kill mysql processlist
SQL
1 vote114 views1 answer
Mysql select from outside
SQL
1 vote119 views1 answer
Mysql return if it contains
SQL
4 votes108 views3 answers
Mysql update with join
SQL
0 vote62 views1 answer
Sql injection mitigation
SQL
2 votes108 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote108 views1 answer
Sql column as header
SQL
0 vote133 views1 answer
How to check foreign key constraint in sql
SQL
3 votes143 views1 answer
Mysql cli connect with password
SQL