MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: sqlcode in mysql?
Posted by: Devart Team
Date: November 18, 2009 05:36AM

>i want to make a query to check whether current record exist, if exists update, else insert.

What about using REPLACE statement?

http://dev.mysql.com/doc/refman/5.1/en/replace.html

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
sqlcode in mysql?
4209
sy l
November 18, 2009 04:34AM
Re: sqlcode in mysql?
2649
Devart Team
November 18, 2009 05:36AM
Re: sqlcode in mysql?
2139
sy l
November 26, 2009 08:21PM
Re: sqlcode in mysql?
1929
Peter Brawley
November 26, 2009 08:29PM
Re: sqlcode in mysql?
1987
sy l
November 27, 2009 04:48AM
Re: sqlcode in mysql?
2264
Peter Brawley
November 27, 2009 09:36AM
Re: sqlcode in mysql?
2154
sy l
November 27, 2009 07:10PM
Re: sqlcode in mysql?
1871
Peter Brawley
November 27, 2009 10:14PM
Re: sqlcode in mysql?
2422
sy l
November 28, 2009 12:39PM
Re: sqlcode in mysql?
1790
Peter Brawley
November 28, 2009 03:03PM
Re: sqlcode in mysql?
1798
sy l
November 30, 2009 03:08AM
Re: sqlcode in mysql?
2614
Peter Brawley
November 30, 2009 11:10AM
Re: sqlcode in mysql?
3750
sy l
December 03, 2009 01:26AM
Re: sqlcode in mysql?
2079
Peter Brawley
December 03, 2009 03:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.