/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

3 votes309 views4 answers
Mysql decimal
SQL
3 votes319 views1 answer
Select database in sql
SQL
0 vote311 views1 answer
Psql list view rules
SQL
6 votes390 views3 answers
What is where in sql
SQL
1 vote301 views1 answer
How to select department from table
SQL
1 vote309 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote260 views1 answer
Ms sql print more than 1 variable
SQL
0 vote330 views2 answers
Mysql where in maintain order group_concat
SQL
2 votes358 views3 answers
Xampp mysql database not starting
SQL
0 vote312 views1 answer
Select odd records sql
SQL