I want to run the most elementary code

import sqlite3 conn = sqlite3.connect('base.db-journal') cursor = conn.cursor() cursor.execute('CREATE TABLE IF NOT EXISTS users (id INT, name TEXT, group TEXT, TgID TEXT)')

I have the following error: sqlite3.OperationalError: near "group": syntax error

Replacing names, using formatting, nothing helps. Help me please.

    1 answer 1

    The group word is reserved in SQLite . Set another name for the field and the error disappears.

    • Thank. Previously it did not help, but after your comment it helped. Now everything is done, but after opening DB Browser for SQLite I do not see the table created. - Mikhail Poleshchuk
    • @MikhailPaleshchuk, try to add something there first. If anything, it is better to ask a new question with a new problem. - Kirill Malyshev
    • Thanks for the help - Mikhail Poleshchuk