Perl Guru Forums: Perl Programming Help: DBI: Re: [PapaGeek] SQL if then else situation: Edit Log

CGI/Perl Guide | Learning Center | Forums | Advertise | Login

Site Search: in


	MAIN INDEX	SEARCH POSTS	WHO'S ONLINE	LOG IN

Home: Perl Programming Help: DBI: Re: [PapaGeek] SQL if then else situation: Edit Log

FishMonger
Veteran / Moderator

Mar 30, 2014, 7:13 AM

Views: 42724

Re: [PapaGeek] SQL if then else situation

Use a replace statement.
https://dev.mysql.com/doc/refman/5.0/en/replace.html

Or, use an insert statement with an "ON DUPLICATE KEY UPDATE" clause.
https://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html

(This post was edited by FishMonger on Mar 30, 2014, 7:16 AM)

Edit Log:
Post edited by FishMonger (Veteran) on Mar 30, 2014, 7:16 AM

Search for (options)