Menu

#65 Instead of 'update+insert into', generat a script with 'replace into' statements. (MySQ)

pending
None
5
2019-08-19
2019-08-13
Ralf Wisser
No

Discussion

  • Ralf Wisser

    Ralf Wisser - 2019-08-19

    The 'replace into' statement is not suitable for this purpose because its effect depends on which key the table has in the target database. If this key differs from a manually defined one (especially if it does not exist), the result is incorrect.

    Instead, I changed the way how the 'upsert' statements are generated to include multiple rows per statement. This makes the script more compact.

     

    Last edit: Ralf Wisser 2019-08-19
  • Ralf Wisser

    Ralf Wisser - 2019-08-19
    • status: accepted --> pending
     

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB