阅读背景:

如何在mysql中执行批处理查询以更新列值

来源:互联网 

For example i have a table ACCOUNT WITH TWO COLUMNS, ID AND A_NUMBER. AND I WANT TO UPDATE THE A_NUMBER VALUES IN A SINGLE QUERY WITH DIFFRENT VALUES. "UPDATE ACCOUNT SET A_NUMBER="0135" WHERE ID=131; UPDATE ACCOUNT SET A_NUMBER="0145" WHERE ID=132; UPDATE ACCOUNT SET A_NUMBER="0155" WHERE ID=133; UPDATE ACCOUNT SET A_NUMBER="0160" WHERE ID=134; UPDATE ACCOUNT SET A_NUMBER="0175" WHERE ID=135; UPDATE ACCOUNT SET A_NUMBER="0180" WHERE ID=136; UPDATE ACCOUNT SET A_NUMBER="0195" WHERE ID=137; UPDATE ACCOUNT SET A_NUMBER="0200" WHERE ID=138;"For example i have a table ACCOUNT WITH TWO COL




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: