/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 vote332 views1 answer
Sql pad left 0
SQL
0 vote340 views1 answer
Varchar2 length in oracle
SQL
16 votes339 views6 answers
Install sqlite3 python
SQL
0 vote321 views1 answer
SQL add a totals of differemt rows of the same id
SQL
8 votes341 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote381 views1 answer
Mysql get nth highest
SQL
2 votes317 views1 answer
Add 2 hours to current time in MySQL
SQL
0 vote328 views1 answer
WHERE not regex in SQL
SQL
0 vote352 views1 answer
Show specific events on mysql
SQL
4 votes321 views2 answers
SELECT table_name FROM user_tables;
SQL