Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Jan 2007
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MySQL If Statement

    I am trying to update an existing record or Insert a new line into a MySQL database. I can not seem to get this statement to run. I keep receiving the following message.What am I missing?
    'Error in your SQL syntax near 'IF first_name LIKE '.%' AND year_of_grad = '1900' THEN UPDATE Members SET fir' at line 1'
    Independently the UPDATE and INSERT statements work just fine.

    IF first_name LIKE '.%'AND
    year_of_grad='1900'
    THEN
    UPDATE Members
    SET first_name='TOM',
    last_name='LastName',
    year_of_grad='1900',
    date_of_membership=CURDATE()
    WHERE
    first_name LIKE '.%'AND
    year_of_grad='1900'
    END
    ELSE
    INSERT INTO Members SET
    first_name='Dick',
    last_name='LastName',
    year_of_grad='1900',
    date_of_membership=CURDATE()
    END;

  • #2
    Senior Coder nikkiH's Avatar
    Join Date
    Jun 2005
    Location
    Near Chicago, IL, USA
    Posts
    1,973
    Thanks
    1
    Thanked 32 Times in 31 Posts
    SQL Server needs begin and end. Not sure if MySQL does.

    Code:
    IF yada yada THEN
       BEGIN
          INSERT ...
       END
    ELSE
       BEGIN
          UPDATE ...
       END
    END
    Also assuming this is in a stored procedure, because AFAIK, it won't work as a query.

    If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
    Bored? Visit
    http://www.kaelisspace.com/


  •  

    Posting Permissions

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