How would I use ON DUPLICATE KEY UPDATE in my CodeIgniter model?

by

You can add the “ON DUPLICATE” statement without modifying any core files.

$sql = $this->db->insert_string('table', $data) . ' ON DUPLICATE KEY UPDATE duplicate=LAST_INSERT_ID(duplicate)';
$this->db->query($sql);
$id = $this->db->insert_id();

I hope it’s gonna help someone.

More Related Contents:

  1. UNION query with codeigniter’s active record pattern
  2. Codeigniter – multiple database connections
  3. Rails 3 ActiveRecord: Order by count on association
  4. Grouping WHERE clauses in Codeigniter
  5. how to get last insert id after insert query in codeigniter active record
  6. how to use DISTINCT ON with mysql using ActiveRecord
  7. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  8. Escaping SQL queries in Codeigniter
  9. Comma separated numeric values – PHP CodeIgniter
  10. MySQL “WITH” clause
  11. Is there a way to get a collection of all the Models in your Rails app?
  12. MySQL root access from all hosts
  13. Basics of Foreign Keys in MySQL?
  14. How to import data from text file to mysql database
  15. Select last N rows from MySQL
  16. Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?
  17. What is the benefit of zerofill in MySQL?
  18. MySQL user DB does not have password columns – Installing MySQL on OSX
  19. How to select date from datetime column?
  20. MySQL – can I limit the maximum time allowed for a query to run?
  21. What does it mean when MySQL is in the state “Sending data”?
  22. How to insert data to MySQL with auto-incremented column(field)?
  23. SQL Server equivalent of substring_index function in MySQL
  24. Remote connect to clearDB heroku database
  25. How to insert Hindi language in Mysql
  26. Converting epoch number to human readable date in mysql
  27. MySQL delete duplicate records but keep latest
  28. MySQL 5.6 – DENSE_RANK like functionality without Order By
  29. What’s mysql’s “BETWEEN” performance over..?
  30. MySQL giving “read ECONNRESET” error after idle time on node.js server

Leave a Comment