/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

48 votes305 views3 answers
Psql create database
SQL
6 votes226 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote296 views1 answer
Dynamic where clause in sql server stored procedure
SQL
1 vote265 views1 answer
Sqlite show columns in table
SQL
0 vote254 views1 answer
Mysqlimport
SQL
0 vote266 views1 answer
C# mysql update statement set value to null
SQL
0 vote252 views1 answer
Stuff in sql server
SQL
0 vote258 views1 answer
Select from another database
SQL
0 vote262 views2 answers
Insert into
SQL
0 vote292 views1 answer
Sql date time query find
SQL