Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql how to truncate table with foreign keys

SET FOREIGN_KEY_CHECKS = 0;

TRUNCATE table1;

SET FOREIGN_KEY_CHECKS = 1;
Comment

PREVIOUS NEXT
Code Example
Sql :: delete mysql ubuntu 20.04 
Sql :: fatal error: libpq-fe.h: No such file or directory 
Sql :: all workbenches in minecraft 
Sql :: postgres get running query 
Sql :: sql server reset id 
Sql :: guid to string sql 
Sql :: Find all triggers in database 
Sql :: oracle create directory 
Sql :: freemysqlhosting keeps deleting tables 
Sql :: mysql change user password 
Sql :: print in pl sql 
Sql :: sql server conection string 
Sql :: mysql CURRENT_TIMESTAMP() 
Sql :: starts and end with vowel sql 
Sql :: oracle string length 
Sql :: mysql drop database if exists 
Sql :: import sql file from laravel 
Sql :: his is incompatible with sql_mode=only_full_group_by 
Sql :: dbms_output sql developer 
Sql :: find table for column name in sql 
Sql :: postgres install unaccent extension 
Sql :: sql database size 
Sql :: mysql delete row 
Sql :: oracle current date without time 
Sql :: sql server select top 2 of each group 
Sql :: install mysql workbench ubuntu 20.04 terminal 
Sql :: mysql select greater than yesterday 
Sql :: count mysql server db tables 
Sql :: mysql id reset 
Sql :: sqlite create integer column with limit 
ADD CONTENT
Topic
Content
Source link
Name
1+5 =