Results 1 to 3 of 3

Thread: mysql syntax

  1. #1
    Join Date
    Jan 2009

    Unanswered: mysql syntax

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


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

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    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.

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

  3. #3
    Join Date
    Sep 2009
    San Sebastian, Spain
    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)
    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