Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Drop specified tables
- Thread starter blekfis
- Start date
Drop the database and recreate the database and 5 tables.
Or write a sql script that says:
Drop table name of table 1;
Drop table name of table 2;
etc
then run the script.
c:>mysql -u username password databasename< sqlscript.sql
or
[user@hostname]mysql -u username password databasename< sqlscript.sql
Let me know how it turns out!
NixerX
kernel_Killer@hotmail.com
Or write a sql script that says:
Drop table name of table 1;
Drop table name of table 2;
etc
then run the script.
c:>mysql -u username password databasename< sqlscript.sql
or
[user@hostname]mysql -u username password databasename< sqlscript.sql
Let me know how it turns out!
NixerX
kernel_Killer@hotmail.com
- Thread starter
- #3
Thanx for the tip, but it's already been solved...
In PHPmyadmin I marked all the tables in my db, then copied them into Textpad, changed all 'space' to ',' and just run what I got in myadmin after drop table. Like this "drop table ***, ****, ****". Maybe it's not the best way, but it worked for me and was kinda easy!!
/N!cklas
In PHPmyadmin I marked all the tables in my db, then copied them into Textpad, changed all 'space' to ',' and just run what I got in myadmin after drop table. Like this "drop table ***, ****, ****". Maybe it's not the best way, but it worked for me and was kinda easy!!
/N!cklas
- Status
Similar threads
