/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

0 vote307 views1 answer
Mysql streaming example
SQL
0 vote286 views1 answer
How to create notes in mysql
SQL
11 votes268 views4 answers
Update row in mysql
SQL
0 vote300 views1 answer
Sql query for login with email or username
SQL
0 vote266 views1 answer
Oracle table free space
SQL
-2 votes242 views1 answer
How to open database
SQL
-1 vote233 views2 answers
On delete set default sql server
SQL
1 vote292 views1 answer
Nvl postgres
SQL
2 votes250 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote296 views1 answer
Create table using the clause with as
SQL