/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 vote96 views1 answer
Sql remove last x char
SQL
25 votes186 views6 answers
Change column name mysql
SQL
1 vote98 views1 answer
Mysql show current queries
SQL
0 vote103 views2 answers
Azure sql-datenbank
SQL
23 votes102 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote101 views1 answer
FIND most frequent word in sql server
SQL
10 votes103 views1 answer
Oracle view dependencies
SQL
1 vote88 views1 answer
Can we drop a primary key
SQL
0 vote105 views1 answer
Mysql count number of occurrences in a column
SQL
31 votes111 views4 answers
How to get duplicate records with multiple field in sql
SQL

Share