如何使用PyODBC插入和更新?

2024-03-29 00:41:15 发布

您现在位置:Python中文网/ 问答频道 /正文

如何在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")

有人能建议我怎么做吗


Tags: nameidsqlstringmytablecolumnaccount