Почему у меня ошибка pymysql.err.OperationalError:?

Question

[samperirrrrr]

Помогите мне вылезает ошибка - pymysql.err.OperationalError: (1364, "Field 'id' doesn't have a default value")
ниже код.

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()