Drop all tables, MySQL.
SELECT concat('DROP TABLE IF EXISTS `', table_name, '`;')
FROM information_schema.tables
WHERE table_schema = 'MyDatabaseName';
Copy and paste the result and run it.
Friday, May 13, 2022
Drop all tables, MySQL
Popular Posts
-
The Planescape Online website has been a labor of love. Since the beginning of my time at Conestoga College, in the Web Design and Developm... -
Drop all tables, MySQL. SELECT concat('DROP TABLE IF EXISTS `', table_name, '`;') FROM information_schema.tables WHERE tab...
-
Compared to Dreamweaver, the process for creating a website in Flash is very simple. Drag and drop to the next level. The actionscript cov...
-
Notes on weird IE things: IMAGES Images saved in CKMY mode cannot be displayed in IE. TRANSPARENCYS img { opacity:0.4; filter:alpha(op...
-
There are many options to preload images in HTML pages. The simplest would be to create a div and move it off the screen. In this div, I ...
-
Using the terminal can be a pain in the ass. So let's make a shell script, so we can avoid typing in the same commands over and over ag...
-
I'm enjoying this program is more and more every day! Now that we've finished the second course, I'm feeling great about where ...
-
thibaud.be This is an amazing site because of it's interactivity. It's fun to just click around and see the pages move around. It ...
-
Here are a few tips for absolute positioning with CSS: 1) Default Position By default, if you don't give values for the top and left ...
-
The design process for this course was very different from the last course (customer service). I found that with the customer service proje...
0 comments:
Post a Comment