Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: MySQL If Statement
01-31-2007, 08:38 PM #1
- Join Date
- Jan 2007
- 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
first_name LIKE '.%'AND
INSERT INTO Members SET
01-31-2007, 10:21 PM #2
- Join Date
- Jun 2005
- Near Chicago, IL, USA
- Thanked 32 Times in 31 Posts
SQL Server needs begin and end. Not sure if MySQL does.
Also assuming this is in a stored procedure, because AFAIK, it won't work as a query.Code:IF yada yada THEN BEGIN INSERT ... END ELSE BEGIN UPDATE ... END END
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/