MarcoMozilla

icon location Toronto icon location B.S. Computer Science Specialist (2020 Graduate)

Results 2 issues of MarcoMozilla

Does not work at all

refactor does not work

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