/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 vote272 views1 answer
Mssql view column data type
SQL
0 vote264 views1 answer
Sql track modification
SQL
3 votes283 views2 answers
Postgres download
SQL
0 vote256 views4 answers
Sql limit 1 offset 1
SQL
0 vote264 views1 answer
Mysql pv progres
SQL
3 votes269 views3 answers
How to add month in update sql
SQL
0 vote266 views1 answer
Sqlite update where exists
SQL
1 vote213 views1 answer
File /etc/init.d/mysql not exists
SQL
8 votes285 views1 answer
Oracle search code in packages
SQL
0 vote267 views1 answer
Find invalid datetime field
SQL