SQL怎样用update更新多个数据?

发布网友发布时间：2022-04-21 05:37

共1个回答

热心网友时间：2022-06-18 06:42

sql
=
"update
stafaddressinf
set
"
sql
=
sql
&
"companytel="
&
SqlStr(request("companytel"))
&
",
"
sql
=
sql
&
"fax="
&
SqlStr(request("fax"))
&
",
"
sql
=
sql
&
"hometel="
&
SqlStr(request("hometel"))
&
",
"
sql
=
sql
&
"homeaddress="
&
SqlStr(request("homeaddress"))
&
",
"
sql
=
sql
&
"postcard="
&
SqlStr(request("postcard"))
&
",
"
sql
=
sql
&
"sex="
&
SqlStr(request("sex"))
&
",
"
sql
=
sql
&
"handset="
&
SqlStr(request("handset"))
&
",
"
sql
=
sql
&
"callset="
&
SqlStr(request("callset"))
&
",
"
sql
=
sql
&
"remark="
&
SqlStr(request("remark"))
&
",
"
sql
=
sql
&
"email="
&
SqlStr(request("email"))
&
"
where
username="
&
sqlstr(request("username"))
给一段代码你作为参考

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com