Hi,
I'm new to mysql and I'm trying to convert this routine that is written for sql server to mysql. This routine updates a record if it exists and adds a record if it does not exists. If anybody can help, please do so. Thanks in advance for your time.

-- update if already exist
IF (@pk_ID <> 0 AND ( EXISTS (SELECT * FROM table1 WHERE pk_ID=@pk_ID)) )
BEGIN
UPDATE table1 SET
value1=@value1,
value2=@value2
WHERE pk_ID=@pk_ID
END
ELSE
BEGIN
INSERT INTO table1
(value1, value2)
VALUES
(@value1, @value2)
END

Thanks,

xayavon

Just use REPLACE, like this:

It will handle an existing entry by updating it or insert a new entry.

aus,
Thanks a lot. That was so much easier then sql server.

xayavon