/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

2 votes388 views1 answer
Sql compare strings
SQL
0 vote356 views1 answer
Set column in all row mysql
SQL
37 votes523 views3 answers
Sql check duplicate value in column
SQL
0 vote375 views1 answer
Python sqlalchemy connection show server
SQL
0 vote311 views1 answer
How to insert same table data using mysql query
SQL
0 vote315 views1 answer
Insert or update cassandra
SQL
32 votes356 views6 answers
Sql count where
SQL
1 vote358 views1 answer
Update from select oracle
SQL
0 vote331 views1 answer
Declare date variable sql
SQL
15 votes501 views2 answers
Sql order by alphabetical
SQL