MySQL 更新语法

Question

使用mysql更新

Dim OfficerCreated, OfficerID As String
Dim OfficerTodaysDateandTime As Date
OfficerTodaysDateandTime = Now
OfficerID = lvOfficerGrid.SelectedItems.Item(0).SubItems(0).Text
OfficerCreated = lvOfficerGrid.SelectedItems.Item(0).SubItems(5).Text
UpdateOfficer = "UPDATE pcms.users SET user_fname = '" & Me.txtOfficerFname.Text.ToUpper & "', user_mname = '" & Me.txtOfficerMname.Text.ToUpper & "'," & _
"user_lname = '" & Me.txtOfficerLname.Text.ToString & "',user_status = '" & Me.AccountStatus.ToString & "',user_created = '" & OfficerCreated & "',user_updated = '" & OfficerTodaysDateandTime & "' WHERE user_id = " & _
"'" & OfficerID & "'"

OfficerID 是一个加载到 ListView 第 1 列中的整数值

OfficerCreated 是加载到 ListView 第 5 列中的 DATETIME

OfficerTodaysDateandTime 是 DATETIME

我在更新时遇到错误..我的代码有什么问题吗？

Answer 1

UPDATE table_name SET column1 = value1, column2 = value2 
WHERE [where you want to make changes]

要更新各个列字段，请使用逗号分隔，而不是与符号。

并且还建议放置一个where子句，否则每一行都会受到更新的影响。