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

标签： pythonsqlpython-3.x

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