Re: Wrong table name - can it be fixed?
| From: | Ignatius Reilly | Date: | Mon, 17 May 2004 08:56:34 +0000 |
| Subject: | Re: Wrong table name - can it be fixed? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34451@lists.php.net to get a copy of this message | ||
Hav you tried enclosing the table name with backticks:
SELECT ...
FROM
16-05
...
Ignatius
_________________________
----- Original Message -----
From: "Martin E. Koss" <martin@spirewindows.com>
To: <php-db@lists.php.net>
Sent: Monday, May 17, 2004 10:48 AM
Subject: [PHP-DB] Wrong table name - can it be fixed?
> I've made a big boo boo when exporting from MS Access to MySql database.
> The table name was '16-05' which obviously is not a good name to have in
> MySql.
> I'm using PhpMyAdmin as I'm not very experienced with sorting out the
> databases any other way. Problem is that I can't access the properties
> of the table in order to rename it, whatever I try to do I get an error
> (which is obviously due to the type of name the table has).
>
> Is there any way I can fix this without getting too complicated?
>
> Cheers.
>
> Martin
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>