drop mysql code example

Example 1: mysql drop

DROP TABLE table_name

Example 2: remove mysql

sudo apt-get remove --purge mysql* -y
sudo apt-get autoremove -y
sudo apt-get autoclean

Example 3: drop table in mysql

DROP TABLE table_name;

Example 4: to delete a table in mysl

drop table table_name;

Example 5: mysql drop table cascade

SET FOREIGN_KEY_CHECKS = 0;
drop table if exists <your_1st_table>;
drop table if exists <your_2nd_table>;
SET FOREIGN_KEY_CHECKS = 1;

Example 6: mysql database drop

mysql -e "DROP DATABASE db_name;"