INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Newbie question, trying to query a table with column names like Transaction Date

Newbie question, trying to query a table with column names like Transaction Date

Newbie question, trying to query a table with column names like Transaction Date

(OP)
I'm attempting to query a table with column names that have spaces.
I've only used MySQL a little bit, so I'm at a loss.

I've tried ' (single quotes) which comments out the field.
I've tried " (double quotes) which just makes it text.
I've tried placing the following wildcards in place of the spaces % or _ or *.

But nothing has worked, what am I doing wrong?
Any help would be appreciated.

Aghhhhhh!hairpull

RE: Newbie question, trying to query a table with column names like Transaction Date

Do not have MYSQL open but on SQL server you wrap field name in square brackets []

eg

Select [Transaction date] from your table

As a general rule try not to create field names with spaces either use

TransactionDate or Transaction_date

Ian

RE: Newbie question, trying to query a table with column names like Transaction Date

I Totally agree with Ian, don't use spaces in table names, you will find a world of pain in the future with coding/using tables with spaces in the names.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

RE: Newbie question, trying to query a table with column names like Transaction Date

(OP)
Thanks all, and believe me, I totally agree with not using spaces but I didn't create the db, I just have to report from it.
Ian, I also tried using brackets (I'm much more comfortable with SQL server) but it didn't work.
And Feherke - a star for you, the backtick did the trick. thumbsup

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close