Results 1 to 3 of 3

Thread: mysql syntax

  1. #1
    Join Date
    Jan 2009
    Posts
    124

    Unanswered: mysql syntax

    approved_at is a text field yet this query fail, any ideas?

    Thanks

    Nick
    SELECT id_at, reviewer_id
    FROM xxx
    WHERE (reviewer_id = 2443353 AND approved_at <>'Approved')

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You have to start the MySQL server. You can't run any SQL statements if the server is turned off.

    Once you get success or an error message, please post an update to this thread.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Not sure I understand how Pat came to the conclusion that the server is down? Looking at your query it syntactically looks correct. However, I do agree with Pat that you should pass on the error and error message that you get back as this will help us determine the source of the problem.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •