/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 vote357 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
1 vote336 views1 answer
Get url of cpanel database hostname
SQL
-1 vote339 views1 answer
How to open blade file from blade in laravel
SQL
0 vote364 views1 answer
Mysql error 1452
SQL
2 votes382 views1 answer
Sql server find columns list in tables
SQL
0 vote379 views1 answer
Sql get year from datetime field
SQL
0 vote336 views1 answer
Sql cross apply vs join
SQL
0 vote340 views1 answer
Sql change date format
SQL
53 votes668 views6 answers
How to install mysql ubuntu
SQL
0 vote384 views2 answers
Dbms transaction tutorialspoint
SQL