如何在Python中使用pyodbc更新或插入SQL server表
我目前有两个列表,我的代码是这样的:
column_name = ["ID","NAME","CLASS","SUBJECT"]
values = [123,"JOSEPH","ACCOUNT","BASICS"] # Values from one iteration
header_string = ', '.join('[{0}]'.format(w) for w in column_name)
var_string = ', '.join('?' * len(values))
query_string = 'INSERT INTO MY_TABLE(%s) values (%s);' % (header_string,var_string)
cursor.execute(query_string, values)
我要做的是通过游标运行以下SQL:
update test MY_TABLE NAME='JOHN' where ID=123
IF @@ROWCOUNT=0
insert into MY_TABLE ("ID","NAME","CLASS","SUBJECT") values(123,"JOSEPH","ACCOUNT","BASICS")
有人能建议我怎么做吗
目前没有回答
相关问题 更多 >
编程相关推荐