/SQL/How to force truncate a table in mysql

How to force truncate a table in mysql

Cannot truncate a table referenced in a foreign key constraint

SET FOREIGN_KEY_CHECKS = 0; 
TRUNCATE table $table_name; 
SET FOREIGN_KEY_CHECKS = 1;

3

Source: stackoverflow.com

How to force truncate a table in mysql

DELETE FROM mytest.instance;
ALTER TABLE mytest.instance AUTO_INCREMENT = 1;

0

Similar codes

0 vote202 views1 answer
Mssql check if date is greater than today
SQL
-1 vote169 views2 answers
Datetime sql server week
SQL
0 vote205 views2 answers
Mysql on update current_timestamp
SQL
0 vote196 views1 answer
How to find unique key in sql
SQL
0 vote333 views1 answer
Sql developer export connections
SQL
11 votes196 views4 answers
Query DISTINCT
SQL
0 vote228 views1 answer
What is delimiter in mysql
SQL
-1 vote221 views3 answers
PS5
SQL
0 vote244 views3 answers
How to find all role in mysql
SQL
0 vote199 views2 answers
Soql last year
SQL

Share