Python连接SqlServer

Python连接SqlServer时出现pymssql.OperationalError: (156, b"Incorrect syntax near the keyword 'user'.DB-Lib error message 20018, severity 15:\nGeneral SQL Server error: Check messages from the SQL Server\n")报错是什么原因

img

下面是源码


import pymssql

connect = pymssql.connect(host='LAPTOP-RU1RUOIR',database='library')

if connect:
    print('数据库已连接成功')

cursor = connect.cursor() #创建游标对象

#执行SQL语句
cursor.execute('CREATE TABLE user(username VARCHAR(100),password VARCHAR(100))')

print('操作已执行成功')
connect.commit()  #提交
cursor.close()  #关闭游标
connect.close()  #关闭连接

https://www.csdn.net/tags/MtzaAg4sMDIyOTctYmxvZwO0O0OO0O0O.html