/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

9 votes148 views2 answers
Sql limit to 5 results
SQL
0 vote137 views1 answer
Get number of tables in database sql
SQL
6 votes135 views1 answer
Oracle desc table primary key
SQL
19 votes130 views2 answers
Mysql tinyint max value
SQL
0 vote118 views1 answer
Import sql mysql ubuntu
SQL
0 vote178 views1 answer
Oracle plsql sleep
SQL
36 votes150 views3 answers
Add column in mysq
SQL
0 vote138 views1 answer
Mysql select where field is a value
SQL
0 vote141 views1 answer
Sql select all records from all tables where not empty
SQL
4 votes130 views1 answer
Oracle show error line number
SQL