0

I'm using the codeigniter PHP framework to create a user login system with profile and what not.

I've currently got a register and login system, and a form to "edit profile data".

However, because of Foreign Key constraints between the account table and profile table, if they were to attempt to edit their profile again, it would be inserting data into the table, which can't be done because there can only be one profile table row per account.

I was wondering if the update function in MySQL will insert data if a row doesn't already exist? and then just update that row every single profile edit call.

Thanks for the help.

Chris
  • 785
  • 10
  • 24
  • In INSERT you can able to do that. Check [insert update on duplicate key mysql](http://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html). If value does not exist INSERT will be done if exist then Update will done. – Viki888 Nov 24 '16 at 14:04
  • and http://stackoverflow.com/q/3361490 – Drew Nov 24 '16 at 14:07

0 Answers0