pymysql; insert on duplicate key update fails

Thread Rating:

Thread Modes

pymysql; insert on duplicate key update fails

wardancer84
Wafer-Thin Wafer

Posts: 84

Threads: 23

Joined: Sep 2018

Reputation: 0

Jun-28-2022, 11:47 AM

seems mariadb simply does not support this "AS" construct....mysql 8+ only feature

rob101 likes this post

Messages In This Thread

RE: pymysql; insert on duplicate key update fails - by wardancer84 - Jun-28-2022, 11:47 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Mysql Syntax error in pymysql	ilknurg	4	2,499	May-18-2022, 06:50 AM Last Post: ibreeden
	pymysql: insert query throws error	wardancer84	12	4,822	Jan-28-2022, 06:48 AM Last Post: wardancer84
	pymysql can't do SELECT *	Pedroski55	3	3,069	Sep-11-2021, 10:18 PM Last Post: Pedroski55
	Python + Google Sheet \| Best way to update specific cells in a single Update()?	Vokofe	1	2,767	Dec-16-2020, 05:26 AM Last Post: Vokofe
	pymysql won't handle some diacritic characters	awarren2001AD	0	1,308	Apr-16-2020, 08:58 AM Last Post: awarren2001AD
	pyMySQL - ROW_NUMBER in SQL statement	JayCee	1	2,453	Apr-12-2020, 08:40 PM Last Post: JayCee
	pyMySQL How do I get the row id	JayCee	3	2,805	Apr-12-2020, 08:38 PM Last Post: JayCee
	PyMySQL return a single dictionary	Valon1981	2	1,867	Feb-20-2020, 04:07 PM Last Post: Valon1981
	pymysql: formating ouput of query	wardancer84	18	8,596	Oct-04-2018, 01:54 PM Last Post: wardancer84
	pymysql ifnull	aland	4	4,100	Sep-06-2018, 05:58 AM Last Post: buran

Users browsing this thread: