[RESOLVED] Is MySQL on crack? - HTML Forums

Sawtooth500 · 07-03-2009, 11:29 PM

So the above picture is directly from phpMyAdmin. The folllowing queries were done through phpMyAdmin:

insert into property_table (display) values ("trial value")
This works fine.

insert into property_table (condition) values ("trial value")
This gives an error.

Now if you look at picture, fields display and condition are freaking identical!!! Why does that work for display but not work for condition???

Sawtooth500 · 07-04-2009, 12:06 AM

Miraculously, I just rename field "condition" to "condition2" and the thing works... is condition a protected word in mysql or something?

Jeremy Ross · 07-04-2009, 07:17 AM

Try wraping the word condition in back quotes within the query like this:

insert into property_table (`condition`) values ("trial value")

Sawtooth500 · 07-04-2009, 07:20 AM

What's the point of wrapping certain words in mysql queries with the `something here` vs just something here?

¥åßßå · 07-04-2009, 08:12 AM

mysql : Reserved words

¥

Sawtooth500 · 07-04-2009, 02:39 PM

Thank you.

JerryDucharme · 07-09-2009, 01:46 AM

I know the bug is resolved, but be careful with the My SQL syntax. " " and ' ' are not exactly the same thing and if you have more than one word, it might not use the whole name, just the first word (then results you in an error msg...).