/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

1 vote98 views3 answers
How to truncate foreign key constraint table
SQL
2 votes99 views1 answer
Oracle find unusable indexes
SQL
0 vote95 views1 answer
Install mysql 8 linux
SQL
1 vote107 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote102 views2 answers
Mysql on update current_timestamp
SQL
13 votes140 views4 answers
Mysql remove foreign key constraint
SQL
1 vote106 views1 answer
Sql find column name like
SQL
3 votes95 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
9 votes118 views3 answers
Find all tables with column name
SQL
3 votes99 views1 answer
Select without null values sql
SQL