Jump to content

Trying to figure this out: ON DUPLICATE KEY


JREAM

Recommended Posts

Im trying to make this so that it will either INSERT or UPDATE

 

Based upon IF assign_bot and assign_user exist in one row,

Then UPDATE, If it's false, then INSERT.

 

INSERT INTO tmp_battles
            SET
            `assign_bot` = '$bot[id]',
            `assign_user` = '{$sess->get('userID')}',
            `battle_hp` = '$bot[hp]'
           
            ON DUPLICATE KEY
                UPDATE `battle_hp` = '$bot[hp]'

 

I don't have a real foreign key because I use MyISAM not InnoDB, therefor I don't know If the duplicate key is doing anything here.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.