Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Drop all tables from database in single query in mysql [duplicate]

Tags:

mysql

Yes i have searched for this but got solution for this in single query.

Any solution in MySQL to drop all tables(NOT TRUNCATE) from database in single query.

like image 659
Prashant Shilimkar Avatar asked Dec 18 '13 12:12

Prashant Shilimkar

1 Answers

As far as I know you have to do it individually: DROP TABLE user, settings, images

like image 71
Darren Lilley Avatar answered Oct 23 '22 06:10

Darren Lilley
Sign in to Comment

Related questions

visualizing crosstab tables with a plot in R
c++ futures/promises like javascript?
Angular js - show/hide loading gif every new route
Valid use case for @PostAuthorize And @PostFilter annotations
Python scikit learn Linear Model Parameter Standard Error
Android change and set default locale within the app
Send email to multiple recipients using win32com module in Python
WebAPI method that takes a file upload and additional arguments
Restart Node.js server programmatically
python: mock a module
Pandas - conditionally select source column of data for a new column based on row value
Swift: Subclassing a UIViewController's root view

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!