How to remove all MySQL tables from the command-line without DROP database permissions? [duplicate]

by

You can generate statement like this: DROP TABLE t1, t2, t3, ... and then use prepared statements to execute it:

SET FOREIGN_KEY_CHECKS = 0; 
SET @tables = NULL;
SELECT GROUP_CONCAT('`', table_schema, '`.`', table_name, '`') INTO @tables
  FROM information_schema.tables 
  WHERE table_schema="database_name"; -- specify DB name here.

SET @tables = CONCAT('DROP TABLE ', @tables);
PREPARE stmt FROM @tables;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
SET FOREIGN_KEY_CHECKS = 1;

More Related Contents:

  1. How do I import an SQL file using the command line in MySQL?
  2. How to export and import a .sql file from command line with options? [duplicate]
  3. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  4. Downloading MySQL dump from command line
  5. How to run SQL script in MySQL?
  6. List of Stored Procedures/Functions Mysql Command Line
  7. Dump a mysql database to a plaintext (CSV) backup from the command line
  8. How to connect to MySQL from the command line
  9. SQL: deleting tables with prefix
  10. MySQL DROP all tables, ignoring foreign keys
  11. How to start MySQL server from command line on Mac OS Lion?
  12. MySQL string replace
  13. How do I find the MySQL my.cnf location
  14. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  15. MySQL select one column DISTINCT, with corresponding other columns
  16. How to use mysql JOIN without ON condition?
  17. Define a variable within select and use it within the same select
  18. ERROR: Error 1005: Can’t create table (errno: 121)
  19. Mysql Convert Column to row (Pivot table )
  20. Merge two tables in one SQL query and make the date values unique
  21. MYSQL select DISTINCT values in two columns
  22. MySQL Select ID’s which occur on different rows with multiple specific values for a column
  23. Use promise to process MySQL return value in node.js
  24. How can I achieve initcap functionality in MySQL?
  25. MySQL vs. JSON – Why? [closed]
  26. Find method to store an IP in MySQL for better performance
  27. MySQL add 12 hours to a time field
  28. OSX ld: library not found for -lssl
  29. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  30. MySQL: Find Missing Dates Between a Date Range

Leave a Comment