Search
 
SCRIPT & CODE EXAMPLE
 

SQL

Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]

SET FOREIGN_KEY_CHECKS = 0; 

truncate table "yourTableName";

SET FOREIGN_KEY_CHECKS = 1;
Comment

PREVIOUS NEXT
Code Example
Sql :: sort order on two columns sql 
Sql :: ms sql mac 
Sql :: sql trim from string 
Sql :: SQL Copy to Another Database 
Sql :: sql right join 
Sql :: sql use not in 
Sql :: query to find second highest salary 
Sql :: python mysql create table if not exists 
Sql :: mysql table schema 
Sql :: coalesce sql 
Sql :: postgres sum when 
Sql :: try catch sql 
Sql :: power query add row 
Sql :: if null put 0 sql 
Sql :: truncate your answer to decimal places mysql 
Sql :: mysql changer nom table 
Sql :: raiserror with nowait 
Sql :: SQL Server query to get data for a particular date and time 
Sql :: mysql in 
Sql :: group by por mes sql mysql 
Sql :: soql more than today 
Sql :: mysql concat and use as where column 
Sql :: mysql into outfile with headers 
Sql :: relation does not exist postgresql 
Sql :: could not assemble any primary key columns for mapped table sqlalchemy 
Sql :: mysql default port number 
Sql :: download sql server 2014 
Sql :: how to update sql server version 
Sql :: mysql select inside sum 
Sql :: sql select on string 
ADD CONTENT
Topic
Content
Source link
Name
6+5 =