mysql - 列计数与第 1 行的值计数不匹配

Question

我花了太多时间来解决这个错误，并且无法在此处找到错误

Adapter = New MySqlDataAdapter("Insert into tbluser(UserID,Name,UserType,Password) values('" & txtUserId.Text & "' ,'" & txtName.Text & "','" & cmbUserType.Text & "','" & "',AES_ENCRYPT('" & txtpass.Text & "','x'))", connection)

Answer 1

Adapter = New MySqlDataAdapter("Insert into tbluser (UserID
                                                ,Name
                                                ,UserType
                                                ,Password) 
                             values( '" & txtUserId.Text & "'
                                   , '" & txtName.Text & "'
                                   , '" & cmbUserType.Text & "'
                                   , '" & "'
                                   , AES_ENCRYPT('" & txtpass.Text & "','x'))", connection)

您的值多于定义的要插入的列。看起来问题是用户类型和密码之间的空字段。像这样修改它应该可以解决列计数错误:

Adapter = New MySqlDataAdapter("Insert into tbluser ( UserID
                                                    , Name
                                                    , UserType
                                                    , Password) 
                                      values( '" & txtUserId.Text & "' 
                                            , '" & txtName.Text & "' 
                                            , '" & cmbUserType.Text & "'
                                            , AES_ENCRYPT('" & txtpass.Text & "','x'))"
                               , connection)