/SQL/How to DROP a table in mysql

How to DROP a table in mysql

How to DROP a table in mysql

-- 'DROP TABLE' followed by the name of the table you would like
-- to drop.
DROP TABLE `test_table`;

2

Mysql drop tables

mysql --silent --skip-column-names -e "SHOW TABLES" DB_NAME | xargs -L1 -I% echo 'DROP TABLE `%`;' | mysql -v DB_NAME

0

Source: superuser.com

Similar codes

0 vote165 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
0 vote130 views1 answer
Get date ISO in psql
SQL
4 votes162 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
-1 vote131 views3 answers
My sql alter table
SQL
0 vote130 views1 answer
How to add unique key constraint in mysql
SQL
4 votes211 views1 answer
What are the data types
SQL
0 vote126 views1 answer
How to check xampp mysql password
SQL
0 vote126 views1 answer
Top 3 salary in sql
SQL
-1 vote131 views2 answers
First letter capital in mysql query
SQL
1 vote119 views2 answers
Drop function in sql
SQL

Share