Hi using phpMyAdmin enter the following into a sql box
ALTER TABLE `16-05` RENAME `newname` ; HTH Peter > -----Original Message----- > From: Viorel Dragomir [mailto:[EMAIL PROTECTED] > Sent: 17 May 2004 09:54 > To: Martin E. Koss; [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > 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 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
