Pike v8.1 release 6

Method Mysql.SqlTable()->insert_or_update()


Method insert_or_update

int insert_or_update(mapping(string:mixed) record, void|int(0..2) clear_other_fields)

Description

Insert a record into the table using an INSERT ... ON DUPLICATE KEY UPDATE command: In case record conflicts with an existing record then it is updated like the update function would do, otherwise it is inserted like insert would do.

If id_col is set and that column doesn't exist in record then the field is added to the mapping with the value that the inserted or updated record got.

Returns

The value of the id_col column for the new or updated record. Zero is returned if there is no id_col column.

Note

This function isn't atomic if clear_other_fields is unset and record contains fields which do not correspond to real columns, i.e. if the prop_col column may need to be updated.