Help with simple query
Posted on 2006-04-18
I have a strange problem. I have a table with the following fields
Field | Type | Null | Key | Default | Extra
exh_id_pk | int(7) | NO | PRI | NULL | auto_increment
exh_email | varchar(40) | YES | | NULL
exh_submitted | char(1) | NO |
exh_submitted = 0 or 1
On my home machine which has MySQL version 5.0.18-nt, I do this simple query
select exh_email, exh_company_name from exhibitors where exh_submitted='0';
and it works.
On the machine (Linux I think) where my site is hosted, running MySQL version 4.0.26-standard, the same query gives the following error:
SHOW KEYS FROM
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Help is urgently needed. Any ideas?