/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 votes388 views6 answers
Jwt laravel
SQL
1 vote347 views3 answers
Mysql disable foreign keys check
SQL
0 vote345 views1 answer
Mysql update privileges
SQL
7 votes382 views1 answer
Sql disable safe mode
SQL
0 vote371 views1 answer
Mysql calculated column
SQL
0 vote371 views1 answer
Sql server create constraint
SQL
0 vote361 views1 answer
Set root password mysql xampp
SQL
3 votes340 views3 answers
Sql current year
SQL
0 vote342 views1 answer
Mysql select where text contains
SQL
0 vote353 views1 answer
Count characters of string mysql
SQL