Name error SQL table python

Question

I'm encountering a NameError indicating that guild_id is not defined during the insertion process.

I have the following code for creating the schedules table:

cursor.execute('''
    CREATE TABLE IF NOT EXISTS schedules (
        guild_id BIGINT PRIMARY KEY,
        channel_id BIGINT NOT NULL,
        hour INT NOT NULL,
        minute INT NOT NULL,
        timezone VARCHAR(50) NOT NULL,
        frequency ENUM('daily', '2-daily', 'weekly') NOT NULL
    )
''')

A
**and this for the callback:*(
async def schedule_callback(interaction, frequency, hour, minute, timezone):
    await interaction.response.defer()
    
    ctx = interaction.channel
    guild_id = interaction.guild.id

**insert**
connection = create_connection()
cursor = connection.cursor()
cursor.execute('''
    INSERT INTO schedules (guild_id, channel_id, hour, minute, timezone, frequency)
    VALUES (%s, %s, %s, %s, %s, %s)
    ON DUPLICATE KEY UPDATE
    guild_id = VALUES(guild_id),  # Adding guild_id here
    channel_id = VALUES(channel_id),
    hour = VALUES(hour),
    minute = VALUES(minute),
    timezone = VALUES(timezone),
    frequency = VALUES(frequency)
''', (guild_id, channel_id, hour, minute, timezone, frequency))
connection.commit()
cursor.close()
connection.close()