my SQL is wrong, but why?

[Manat]

Hello all,

I'm going crazy here trying to find out my sql error:

here is my table structure:

Never mind everyone....

Found the error

MySQL is stupid, that's the error....

It wouldn't allow a field with a dash in it's column name...

thx

[sfullman]

I'm not going to say who is :-) all in good nature of course.

You actually CAN have field names have dashes (I think 🙂, certainly tables and databases, and spaces etc for that matter. Just because you can jump off a cliff though doesn't mean you should.

When objects are not [a-z_0-9], they are referenced in backticks, like:

stupid-field-name

and it should work :-)

[Sxooter]

underscores, however, are usually both more readable and allowed without quoting:

my_big_table is usually a lot easier to read than my-big-table