mysql.connector.errors.ProgrammingError: 1064(42000):你的SQL语法

Question

import mysql.connector as a
class DBHelper:
def __init__(self):
self.con = a.connect(host='localhost',port = '3306',user='root',password="", database='pythontest')
query = 'create table if not exits user(userId int primarykey, userName varchar(200), phon varchar(12))'
cur = self.con.cursor()
cur.execute(query)
print('conected')

# min
helper = DBHelper()

Answer 1

试着这样写:

import mysql.connector as a
class DBHelper:
def __init__(self):
self.con = a.connect(host='localhost',port = '3306',user='root',password="", database='pythontest')
query = 'create table if not exists user(userId int AUTO_INCREMENT,userName varchar(200),phon varchar(12),CONSTRAINT userid_pk PRIMARY KEY (userId))'
cur = self.con.cursor()
cur.execute(query)
print('conected')

# min
helper = DBHelper()