Hello, I have an SQL error, but I don’t find where...
# exposed
r
Hello, I have an SQL error, but I don’t find where
Copy code
INSERT INTO gateways (gateway_id, gateway_sub_type, gateway_type, migration_status) VALUES ('VIRT048', 14, 15, 0) ON DUPLICATE KEY UPDATE gateway_id=VALUES(gateway_id), gateway_type=VALUES(gateway_type), gateway_sub_type=VALUES(gateway_sub_type), migration_status=VALUES(migration_status)
I get ERROR: syntax error at or near “DUPLICATE” But with an online checker, it says it’s correct