diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2017-10-24 10:40:05 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2017-10-24 10:40:05 -0400 |
| commit | 73f2527486719b936a9a54bc2fe323792d952f26 (patch) | |
| tree | d71eb54c39631299f408723fc642d21f4cfe4664 | |
| parent | 9e5395c3da77525f8ad2dab5bca60dca189c91e8 (diff) | |
| parent | 2f46856f95ab961dac22b8480d1f444a4d7553ef (diff) | |
| download | sqlalchemy-73f2527486719b936a9a54bc2fe323792d952f26.tar.gz | |
Merge remote-tracking branch 'origin/pr/396'
| -rw-r--r-- | doc/build/changelog/migration_12.rst | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/doc/build/changelog/migration_12.rst b/doc/build/changelog/migration_12.rst index 5eba2def5..35d2e1c76 100644 --- a/doc/build/changelog/migration_12.rst +++ b/doc/build/changelog/migration_12.rst @@ -1459,17 +1459,17 @@ is now supported using a MySQL-specific version of the This :class:`~.expression.Insert` subclass adds a new method :meth:`~.mysql.dml.Insert.on_duplicate_key_update` that implements MySQL's syntax:: - from sqlalchemy.dialect.mysql import insert + from sqlalchemy.dialects.mysql import insert - insert_stmt = insert(my_table). \\ + insert_stmt = insert(my_table). \ values(id='some_id', data='some data to insert') on_conflict_stmt = insert_stmt.on_duplicate_key_update( - data=stmt.inserted.data, + data=insert_stmt.inserted.data, status='U' ) - conn.execute(do_update_stmt) + conn.execute(on_conflict_stmt) The above will render:: |
