Very simple Mysql select query, why is it failing?

[Red Squirrel]

I'm trying this query:

SELECT kid, kdata FROM keys WHERE kuser='1'

And it keeps failing with this error:

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 'keys WHERE kuser=1' at line 1

I don't get it, what is wrong with the query? I tried with and without the single quotes.

The table structure is rather basic too. kid is an int, kdada is text and kuser is int. Am I going crazy here or does this query has a typo that I'm just missing?

 

[Red Squirrel]

Ok renamed table and now it's ok. I always forget that there's certain words that mysql does not like if you use for names of rows or tables. Wish it would actually tell you that instead of just saying there's a syntax error.

 

[Chaotic42]

No SQL I've used has good error messages. I'm surprised it let you name the table keys.

 

[mxnerd]

Should have known that KEYS is a reserved word. 🙂

Like you would not name a field name / column name / table name as ORDER.

https://dev.mysql.com/doc/refman/5.7/en/keywords.html

 

[Red Squirrel]

No SQL I've used has good error messages. I'm surprised it let you name the table keys.

That's the thing, if it's a reserved keyword you'd think it would have just not let me name it that in first place! Seems like a design fail. Funny enough I always add some kind of prefix to column names to prevent this but never really thought of doing it for table names. There's odd ball names that just seem to cause all sorts of weird issues. I'm sure there's a list of them somewhere but not really something I would remember to check every time.

 

[deakphreak]

it is always a good habit to use quotes and ticks in your SQL statements.
SELECT `kid`, `kdata` FROM `keys` WHERE `kuser`='1'

 

[Homerboy]

it is always a good habit to use quotes and ticks in your SQL statements.
SELECT `kid`, `kdata` FROM `keys` WHERE `kuser`='1'

Ugh - hell no.

 

[mooncancook]

If the field name or table name happens to be a keyword, I usually add brackets around the name to make it work.
SELECT kid, kdata FROM [keys] WHERE kuser='1'
Not sure if mysql is any different.