pypika
pypika copied to clipboard
AS Alias on duplicate update
pypika can't create the following Query
INSERT INTO test
(INT_NN
,PKEY
,STR_NN
) VALUES (100,'KEY_1','V30'),(500,'KEY_2','V1110') AS TEMP
ON DUPLICATE KEY UPDATE test
.INT_NN
=TEMP
.INT_NN
,test
.STR_NN
=TEMP
.STR_NN
;
VALUES(key) usage is depreciated on MYSQL
_as() function not work properly