我想用一个命令运行多个语句。是否可能:
这是SQL命令:
UPDATE toggle SET state='0' WHERE feature_name=âfeature_1;
UPDATE toggle SET state=â1â WHERE feature_name=âfeature_2â;
UPDATE toggle SET state=â1â WHERE feature_name=âfeature_3â;
对于一个命令,我运行如下命令:
import MySQLdb
myDB = MySQLdb.connect(host=host, port=db_port, user=user, passwd=db_password, db=db)
cHandler = myDB.cursor()
cHandler.execute(query)
但这显然只适用于一个语句