Re: Dropping tables in MySQL
| From: | Marcus Tobias | Date: | Mon, 03 Sep 2001 12:22:38 +0000 |
| Subject: | Re: Dropping tables in MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-12116@lists.php.net to get a copy of this message | ||
Hi Ali!
- export the database into a dump file.
- strip the table from the dump.
- drop the database
- import the new dump
bye Marcus
"Ali Nayeri" <a_nayeri@yahoo.com> schrieb im Newsbeitrag
news:MHEJLHFKJHFOLMANMIKGGEIGCBAA.a_nayeri@yahoo.com...
> Hi guys
>
> I had a question. How do you drop a table in a database in MySQL that has
> spaces in it's name. I created some tables in M$ Access and then exported
> them using MyODBC to MySQL. One of the tables had whitespaces in the name.
> Now MySQL is all screwed up. I want to drop the table but nothing works. I
> tried "", '', `', [] but nothing works. Any solutions?
>
> Thanks
>
> Ali
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>