RE: [PHP-DB] Wrong table name - can it be fixed?
| From: | Peter Lovatt | Date: | Mon, 17 May 2004 09:00:46 +0000 |
| Subject: | RE: [PHP-DB] Wrong table name - can it be fixed? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34452@lists.php.net to get a copy of this message | ||
Hi
using phpMyAdmin enter the following into a sql box
ALTER TABLE
16-05 RENAME newname ;
HTH
Peter
> -----Original Message-----
> From: Viorel Dragomir [mailto:bc@vio.ro]
> Sent: 17 May 2004 09:54
> To: Martin E. Koss; php-db@lists.php.net
> Subject: Re: [PHP-DB] Wrong table name - can it be fixed?
>
>
> Use "tablename" from mysql command prompt.
> Try to use it from phpmyadmin, but I don't know if it works..
> And don't post emails with high priority anymore.
>
> ----- Original Message -----
> From: Martin E. Koss
> To: php-db@lists.php.net
> Sent: Monday, May 17, 2004 11:48
> 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
>