CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in 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: 39748
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) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives