acess to mysql

[ttuser4]

hi, i just imported ms access to mysql (tables) and now trying to rewrite queries.
can you help me with mysql syntax with these two:

SELECT ZIPLIST.ZIP, ZIPLIST.CITY, ZIPLIST.STATE, ZIPLIST.COUNTY AS ZIPLIST_COUNTY, SNOWLOAD.S, SNOWLOAD.W, SNOWLOAD.Ss, SNOWLOAD.S1, SNOWLOAD.I1, SNOWLOAD.I2
FROM SNOWLOAD, ZIPLIST
WHERE (((ZIPLIST.STATE)=[snowload].[st]) AND ((ZIPLIST.COUNTY)=[snowload].[county]));

it gives me error 1064.

SELECT ZIPLIST.ZIP, ZIPLIST.CITY, ZIPLIST.STATE, ZIPLIST.COUNTY AS ZIPLIST_COUNTY, SNOWLOAD.S, SNOWLOAD.W, SNOWLOAD.Ss, SNOWLOAD.S1, SNOWLOAD.I1, SNOWLOAD.I2
FROM SNOWLOAD, ZIPLIST
WHERE (((ZIPLIST.ZIP)=[enter zip code]) AND ((ZIPLIST.STATE)=[snowload].[st]) AND ((ZIPLIST.COUNTY)=[snowload].[county]));

thanks.

 

[r937]

get rid of the square brackets, mysql doesn't understand them

if they were required to escape a problematic identifier, such as a table with a space in the name like [My Table], then you will have to escape them with mysql backticks, like `My Table` (of course, it's best not to have names like that in the first place)

mysql does not prompt like access does for things like [enter zip code]

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[ttuser4]

thanks, it works now

SELECT ZIPLIST.ZIP, ZIPLIST.CITY, ZIPLIST.STATE, ZIPLIST.COUNTY AS ZIPLIST_COUNTY, SNOWLOAD.S, SNOWLOAD.W, SNOWLOAD.Ss, SNOWLOAD.S1, SNOWLOAD.I1, SNOWLOAD.I2
FROM SNOWLOAD, ZIPLIST
WHERE ((ZIPLIST.STATE=snowload.st) AND (ZIPLIST.COUNTY=snowload.county));