Horje
sql truncate table referencing itself Code Example
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



Sql

Related
sqlite3 pragma foreign keys Code Example sqlite3 pragma foreign keys Code Example
many rows to 1 string mysql Code Example many rows to 1 string mysql Code Example
configurer mysqlwampserver a distance Code Example configurer mysqlwampserver a distance Code Example
implicit inner join table alias with id values Code Example implicit inner join table alias with id values Code Example
convert mongodb to sql Code Example convert mongodb to sql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 10



 

Horje