Drop all tables in a MySQL Database — text — codestacker

you are in: codestacker → codes [RSS] → Drop all tables in a MySQL Database

Drop all tables in a MySQL Database

run in shell:

show/hide lines

   1  echo DROP TABLE `echo 'SHOW TABLES;' | mysql -u USER -p DATABASE | tail -n +2 | sed -e 's/$/,/'` | sed -e 's/,$/;/'

echo DROP TABLE `echo 'SHOW TABLES;' | mysql -u USER -p DATABASE | tail -n +2 | sed -e 's/$/,/'` | sed -e 's/,$/;/'

created by leozera — 31 July 2008 — get a short url — tags: mysql — embed

Comments