/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

15 votes324 views3 answers
Mysql update add to existing value
SQL
0 vote385 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
2 votes287 views2 answers
Mamp connect mysql terminal
SQL
7 votes279 views1 answer
Safe mode mysql
SQL
0 vote265 views1 answer
Format the money fied with comma in international system using sql
SQL
17 votes285 views3 answers
Cast in sql server
SQL
1 vote301 views1 answer
Oracle compile schema
SQL
2 votes284 views1 answer
Sql ends with string
SQL
20 votes300 views3 answers
How to open postgresql in mac
SQL
0 vote345 views2 answers
How to check if a column exists in a SQL Server table?
SQL

Share