my_sql update语句 急help 在线等
dim fen
fen = 20000
hlwzrs.open "update pchat_user set nBean = nBean+4000000 where uin= "&menberrs.fields( "id "),mysqlcon,1,3
这样是能够实现的
可是把4000000改成变量(fen)就不行..为什么?
达人给个正确答案....
------解决方案--------------------hlwzrs.open "update pchat_user set nBean = nBean+ " & fen & " where uin= "&menberrs.fields( "id "),mysqlcon,1,3