Horje
how to force truncate a table in mysql Code Example
cannot truncate a table referenced in a foreign key constraint 
SET FOREIGN_KEY_CHECKS = 0; 
TRUNCATE table $table_name; 
SET FOREIGN_KEY_CHECKS = 1;
Source: stackoverflow.com
how to force truncate a table in mysql 
DELETE FROM mytest.instance;
ALTER TABLE mytest.instance AUTO_INCREMENT = 1;



Sql

Related
See Foreign Key Code Example See Foreign Key Code Example
add column in sql Code Example add column in sql Code Example
consecutive numbers sql Code Example consecutive numbers sql Code Example
sql inner join Code Example sql inner join Code Example
Create table Statement Syntax in SQL Server Code Example Create table Statement Syntax in SQL Server Code Example

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



 

Horje