/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 vote168 views1 answer
Sql select max value from multiple rows
SQL
4 votes158 views1 answer
Create table if not exist in sqlite
SQL
3 votes154 views3 answers
Sql last week
SQL
5 votes168 views1 answer
Add column table sql default value
SQL
0 vote185 views1 answer
Mysql config slave
SQL
0 vote177 views1 answer
MySQL import data from large CSV file
SQL
3 votes143 views2 answers
To_char oracle
SQL
9 votes169 views2 answers
Sql limit to 5 results
SQL
6 votes160 views2 answers
Drop foreign key
SQL
0 vote145 views1 answer
How to get data between a last week in mysql
SQL