/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 vote272 views1 answer
Mysql return if it contains
SQL
0 vote252 views1 answer
Postgres 11 add primary key
SQL
0 vote266 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
0 vote282 views1 answer
How to write if case in select query in select statement
SQL
0 vote270 views1 answer
Mysql beautifier terminla
SQL
0 vote294 views1 answer
Add week ending date sql server
SQL
2 votes244 views1 answer
Convert series number to date in sql
SQL
8 votes303 views6 answers
Insert command in sql
SQL
3 votes263 views1 answer
Force using index plsql
SQL
6 votes276 views2 answers
Mysql interval 1 day
SQL