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" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to