nixCraft
Linux / UNIX Tech Support Forum
Delete all tables mysql under Linux
This is a discussion on Delete all tables mysql under Linux within the Databases servers forums, part of the Mastering Servers category; How do I delete all tables in mysql database server??? I need to delete all tables for database called wp ...
|
Register free or login to your existing account and remove all advertisements. |
|
|||||||
| Databases servers Discussions of databases of all types - especially MySQL. |
 |
|
|
LinkBack | Thread Tools | Display Modes |
06-09-2007, 01:40 AM
|
|||
|
|||
Delete all tables mysql under Linux
How do I delete all tables in mysql database server??? I need to delete all tables for database called wp from command line. I' using CentOS linux
thanks 
|
| Sponsored Links | ||
|
|
|
06-09-2007, 05:50 PM
|
||||
|
||||
|
To delete all tables just drop database :P
Code:
drop database foo; Code:
TRUNCATE TABLE bar;
__________________
Vivek Gite Linux Evangelist  Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group. Always use CODE tags for posting system output and commands! Do you run a Linux? Let's face it, you need help
|
|
«
PhpmyAdmin-Can browse/search some tables, but not others
|
Ubuntu server allow tcp Mysql connection from remote system
»
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Linux Recursively Delete Subdirectories | raj | Linux software | 0 | 04-22-2008 01:50 AM |
| Linux delete mail for root or any other user from a shell prompt | raj | Getting started tutorials | 0 | 05-05-2007 01:36 AM |
| Linux delete empty directories | raj | Getting started tutorials | 0 | 05-05-2007 01:29 AM |
| Linux find and delete files | cbzee | Linux software | 4 | 12-20-2006 12:01 PM |
| delete directory linux | chiku | Linux software | 4 | 07-22-2006 06:56 PM |
All times are GMT +5.5. The time now is 10:05 AM.
