February 2012
1 post
Codeigniter on_duplicate_update db function
So your using MYSQL for your new codeigniter app and you get to a point in the app where you need to do this.
So as show above, you check if a record exists, if it does you update, if not you insert. This is fast and easy correct? But what if you doing thousand of records and you need some help in performance. Well in Mysqli you have the ability to insert on duplicate all in one query.
Ok thats...