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")报错是什么原因
下面是源码
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