Thread: Delete all tables mysql under Linux
View Single Post

  #2 (permalink)  
Old 06-09-2007, 06:50 PM
nixcraft's Avatar
nixcraft nixcraft is offline
Never say die
User
  
Join Date: Jan 2005
Location: BIOS
My distro: Ubuntu
Posts: 1,060
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default
To delete all tables just drop database :P
Code:
drop database foo;
To delete all data from table bar:
Code:
TRUNCATE TABLE bar;
__________________
Vivek | My personal blog
Linux Evangelist
Play hard stay cool
Reply With Quote