summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2017-10-24 10:40:05 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2017-10-24 10:40:05 -0400
commit73f2527486719b936a9a54bc2fe323792d952f26 (patch)
treed71eb54c39631299f408723fc642d21f4cfe4664
parent9e5395c3da77525f8ad2dab5bca60dca189c91e8 (diff)
parent2f46856f95ab961dac22b8480d1f444a4d7553ef (diff)
downloadsqlalchemy-73f2527486719b936a9a54bc2fe323792d952f26.tar.gz
Merge remote-tracking branch 'origin/pr/396'
-rw-r--r--doc/build/changelog/migration_12.rst8
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::