Skip to content

Instantly share code, notes, and snippets.

@Ikhiloya

Ikhiloya/console.sql

Last active October 9, 2018 14:21
Show Gist options
  • Save Ikhiloya/9fa75ed7bcbcdf0eef03a09a23340b0f to your computer and use it in GitHub Desktop.
Save Ikhiloya/9fa75ed7bcbcdf0eef03a09a23340b0f to your computer and use it in GitHub Desktop.
Download ZIP
Delete a table with foreign key constraints mysql
Raw
console.sql
set foreign_key_checks = 0;
drop table sla_matrix_config cascade;
set foreign_key_checks = 1;
--OR--
drop table gender_tab cascade constraints;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment