SQL语句的编写

CODE:

import pymssql
dbstring="delete from users where emailaddress=%s" % str(emailaddress)
#连接数据库并打开
con = pymssql.connect(host='192.168.1.71',user='sa',password='emailsms',database='shortmsg')
cur = con.cursor()
#执行SQL语句
cur.execute(str(dbstring))
con.commit()
con.close()

CODE:

DatabaseError: internal error: SQL Server message 107, severity
e 1:
列前缀 'sun_able@kinca' 与查询中所用的表名或别名不匹配。
DB-Lib error message 10007, severity 5:
General SQL Server error: Check messages from the SQL Server.
(SQL Server message 107, severity 16, state 2, line 1:
列前缀 'sun_able@kinca' 与查询中所用的表名或别名不匹配。
DB-Lib error message 10007, severity 5:
General SQL Server error: Check messages from the SQL Server.
)

CODE:

dbstring="delete from users where emailaddress='%s'" % (str(emailaddress))