/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 vote179 views1 answer
Sql column as header
SQL
1 vote191 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote191 views1 answer
Sql query for select from specific columns in a table
SQL
1 vote208 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote196 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote227 views1 answer
Mysql enter ubuntu
SQL
0 vote185 views1 answer
SAP Return
SQL
4 votes287 views1 answer
Mysql store ip address
SQL
11 votes230 views2 answers
Mysql disable safe mode
SQL
0 vote214 views4 answers
Convert databse to achieve log mode oracle
SQL