Changes between Version 3 and Version 4 of DatabaseBasedAnalysis/table2sql


Ignore:
Timestamp:
08/07/18 16:41:45 (6 years ago)
Author:
tbretz
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • DatabaseBasedAnalysis/table2sql

    v3 v4  
    133133
    134134Another option is to update duplicate entries. This can be done using the `ON DUPLICATE KEY UPDATE` directive. Giving `-duplicate`, you can specify what should be updated in case of a duplicate key. To keep the row untouched, you can just update the primary key with the identical primary key, e.g.
     135
    135136{{{
    136 --duplicate='MyPrimary=VALUES(MyPrimary)'
    137 }}}.
     137--duplicate="MyPrimary=VALUES(MyPrimary)"
     138}}}
    138139
    139140The `--duplicate` resource can be specified more than once to add more expressions to the assignment_list. For more details, see the MySQL manual.