Hav you tried enclosing the table name with backticks: SELECT ... FROM `16-05` ... Ignatius _________________________ ----- Original Message ----- From: "Martin E. Koss" <martin@xxxxxxxxxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Monday, May 17, 2004 10:48 AM Subject: 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
