SevenEcks Posted August 19, 2008 Share Posted August 19, 2008 I have just transferred from one host with MySQL 5.0.32 to one with 5.0.51a-community. I was able to upload my database without a hitch and can browse around it with PHPMyAdmin. However, the site itself does not work because MySQL is returning an error on all queries. (All tables are MyISAM/utf8_unicode_ci) I have found that it is the following: It requires table names to be surrounded by `'s. So.. select * from `tablename` instead of just: select * from tablename I have been unable to find any information on this. I want to disable whatever this feature is. Any help would be much appreciated, thanks. Link to comment https://forums.phpfreaks.com/topic/120439-solved-mysql-requiring-s-around-table-names/ Share on other sites More sharing options...
PFMaBiSmAd Posted August 19, 2008 Share Posted August 19, 2008 It sure would help if you provided an actaul example of one of your table names so that we can see what might be going on. From the mysql manual - An identifier may be quoted or unquoted. If an identifier contains special characters or is a reserved word, you must quote it whenever you refer to it. The set of alphanumeric characters from the current character set, “_”, and “$” are not special. Reserved words are listed at Section 8.3, “Reserved Words”. Link to comment https://forums.phpfreaks.com/topic/120439-solved-mysql-requiring-s-around-table-names/#findComment-620582 Share on other sites More sharing options...
fenway Posted August 20, 2008 Share Posted August 20, 2008 I have been unable to find any information on this. I want to disable whatever this feature is. It's not a "feature"... and it's mandatory because MySQL allows reserved characters and keywords everywhere. Just don't use it. Link to comment https://forums.phpfreaks.com/topic/120439-solved-mysql-requiring-s-around-table-names/#findComment-620697 Share on other sites More sharing options...
SevenEcks Posted August 20, 2008 Author Share Posted August 20, 2008 Some Table Names: mod, model, sale Link to comment https://forums.phpfreaks.com/topic/120439-solved-mysql-requiring-s-around-table-names/#findComment-621364 Share on other sites More sharing options...
Mchl Posted August 20, 2008 Share Posted August 20, 2008 Some reserved words http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html Ok. actually all of them for 5.0 Link to comment https://forums.phpfreaks.com/topic/120439-solved-mysql-requiring-s-around-table-names/#findComment-621368 Share on other sites More sharing options...
SevenEcks Posted August 20, 2008 Author Share Posted August 20, 2008 Thank you very much. Link to comment https://forums.phpfreaks.com/topic/120439-solved-mysql-requiring-s-around-table-names/#findComment-621371 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.