/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 vote221 views1 answer
How to find date from date table in sql
SQL
7 votes218 views2 answers
How to create index mysql
SQL
-1 vote206 views1 answer
Can pandas fetch data from sql
SQL
0 vote148 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
8 votes181 views2 answers
Phpmyadmin password
SQL
4 votes186 views1 answer
Wilayah indonesia sql
SQL
7 votes198 views2 answers
Sql empty table
SQL
0 vote192 views1 answer
Como hacer un select entre fechas mysql
SQL
9 votes203 views2 answers
Nosql databases
SQL
1 vote190 views1 answer
Mysql dump specific tables
SQL