/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 vote207 views1 answer
Reset keys in sql
SQL
1 vote209 views1 answer
Install postgresql on raspberry pi
SQL
0 vote210 views1 answer
Create date sql
SQL
1 vote199 views1 answer
User privileges postgresql information_schema
SQL
1 vote203 views1 answer
Stop mysql server mac
SQL
0 vote211 views1 answer
Mariadb select limit offset
SQL
1 vote210 views2 answers
Pad zero sql server
SQL
0 vote213 views1 answer
Influxdb clone measurement
SQL
0 vote227 views1 answer
Sql out file formate
SQL
0 vote196 views1 answer
Sql server update top n records
SQL