CREATE TABLE IF NOT EXISTS games(
id INTEGER AUTO_INCREMENT PRIMARY KEY,
game_id INT UNIQUE,
name VARCHAR(255),
date DATE
);
cursor.execute("INSERT games(game_id, name, date) VALUES (2, 'Ships in the ocean', 20180212)")
pymysql.err.IntegrityError: (1062, "Duplicate entry '2' for key 'games.game_id'")