python-mysql

23 阅读1分钟

python怎样使用mysql - 腾讯云开发者社区 - 腾讯云

INSERT INTO users (id, name, email) VALUES (1, 'John Doe', 'john@example.com') ON DUPLICATE KEY UPDATE email = VALUES(email);

INSERT INTO users (id, name, email) VALUES (1, 'Jane Doe', 'jane@example.com') ON DUPLICATE KEY UPDATE name = VALUES(name), email = VALUES(email);