Why do I get pymysql.err.OperationalError:?

Question

Python

Help me get error - pymysql.err.OperationalError: (1364, "Field 'id' doesn't have a default value")
code below.

from connection import connect

def register(user_id):
  connection = connect()
  try:
    with connection.cursor() as cursor:
      result = cursor.execute(f"SELECT * FROM accounts WHERE uid={user_id}")
      xiy = cursor.fetchone()
      if result == 0:
        cursor.execute(f'INSERT INTO accounts(uid) VALUES({user_id})')
        connection.commit()
      else:
        return xiy
  finally:
    connection.close()

Answer 1

In your table id is not filled in automatically. Are you able to read?
Put in phpmyadmin or through what you administer the database there the id field the auto-increment parameter and everything will be chiki bunches.