Search
 
SCRIPT & CODE EXAMPLE
 

SQL

uncheck constraints and delete from table

alter table MyOtherTable nocheck constraint all
delete from MyTable
alter table MyOtherTable check constraint all
Comment

PREVIOUS NEXT
Code Example
Sql :: truncate your answer to decimal places mysql 
Sql :: docker add mysql to image 
Sql :: psql get last rows 
Sql :: sqlite alter table add multiple column 
Sql :: like in postgresql 
Sql :: what is intersect in sql 
Sql :: mysql get max value and id 
Sql :: generate random & unique mysql string 
Sql :: len sql 
Sql :: temp tables in sql server 
Sql :: mysql best tutorial for beginners 
Sql :: mysqli inner join (php) 
Sql :: sql select all tables from database change url 
Sql :: set mysql password 
Sql :: how to find total working hour in sql 
Sql :: how to change server name in sql server 
Sql :: mysql into outfile with headers 
Sql :: delete all duplicate rows keep the latest except for one in mysql 
Sql :: grant create db postgres 
Sql :: sql server datetime 
Sql :: how to relationship query two different tables in MySQL 
Sql :: sql join on comma separated field 
Sql :: sql distinct vs unique 
Sql :: SQL Primary Key multiple column 
Sql :: sql add calculated column 
Sql :: oracle sql developer 
Sql :: carbon mysql d m y to y-m-d 
Sql :: sqlyog clear cache query 
Sql :: how to check common records in 2 table 
Sql :: mysql range of dates overlap 
ADD CONTENT
Topic
Content
Source link
Name
6+7 =