/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 vote181 views1 answer
Select into table variable
SQL
1 vote157 views1 answer
Sql upsert
SQL
38 votes234 views6 answers
Alter table mysql
SQL
1 vote155 views4 answers
Between vs in sql
SQL
0 vote170 views1 answer
Pl/ sql change currency
SQL
0 vote172 views1 answer
Mysql begin statement
SQL
0 vote167 views1 answer
What is metadata in sql
SQL
0 vote396 views1 answer
Sql datum formatieren
SQL
0 vote160 views1 answer
Sql with example
SQL
1 vote173 views1 answer
How to select multiple columns from different tables in mysql
SQL