pypika icon indicating copy to clipboard operation
pypika copied to clipboard

AS Alias on duplicate update

Open MarcoMozilla opened this issue 1 year ago • 0 comments

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

MarcoMozilla avatar Sep 30 '22 17:09 MarcoMozilla