Syntax error in sql command [closed]

Question

Syntax error in sql command [closed]

Navigation

#1 by (2 votes)
#2 by (0 votes)

-1

I'm having a possible syntax problem with sql in my code

 if (tbCPF.Text != "" && tbNome.Text != "" && tbEndereco.Text != "" && tbNumero.Text != "" && tbBairro.Text != "" && tbCEP.Text != "" && tbCidade.Text != "" && tbRG.Text != "" && tbAumento.Text != "" && cbCargo.Text != "")
            {
                cmd = new MySqlCommand("update FUNCIONARIO set CPF_FUNCIONARIO=@CPF, NOME_FUNCIONARIO=@NOME, RG_FUNCIONARIO=@RG ENDEREÇO_FUNCIONARIO=@ENDERECO, NUMERO_FUNCIONARIO=@NUMERO, BAIRRO_FUNCIONARIO=@BAIRRO, CEP_FUNCIONARIO=@CEP, CIDADE_FUNCIONARIO=@CIDADE, ID_CARGO=@CARGO, AUMENTO_FUNCIONARIO=@AUMENTO where CPF_FUNCIONARIO=@ID", con);
                con.Open();
                cmd.Parameters.AddWithValue("@ID", ID);
                cmd.Parameters.AddWithValue("@CPF", tbCPF.Text);
                cmd.Parameters.AddWithValue("@NOME", tbNome.Text);
                cmd.Parameters.AddWithValue("@RG", tbRG.Text);
                cmd.Parameters.AddWithValue("@ENDERECO", tbEndereco.Text);
                cmd.Parameters.AddWithValue("@NUMERO", tbNumero.Text);
                cmd.Parameters.AddWithValue("@BAIRRO", tbBairro.Text);
                cmd.Parameters.AddWithValue("@CEP", tbCEP.Text);
                cmd.Parameters.AddWithValue("@CIDADE", tbCidade.Text);
                cmd.Parameters.AddWithValue("@CARGO", cbCargo.SelectedValue);
                cmd.Parameters.AddWithValue("@AUMENTO", tbAumento.Text);
                cmd.ExecuteNonQuery();
                MessageBox.Show("Atualizado com sucesso");
                con.Close();
                DisplayData();
                ClearData();
                btnSalvar.Text = "Salvar";
            }
            else
            {
                MessageBox.Show("Por favor preencha todos os campos");
            }

When running it it gives me the following error ...

I have already checked the sql command, and this is correct, may be something else that is causing the error but I do not know, where it is wrong, please help me! (I'm using locaweb's phpMyAdmin)

c# phpmyadmin

asked by anonymous 24.10.2018 / 06:06

2 answers

2

A comma is missing between

RG_FUNCIONARIO=@RG ENDEREÇO_FUNCIONARIO=@ENDERECO
                  ^

24.10.2018 / 13:55

When should I use the span tags, hn and p [closed] Endpoint to send document by email

score 0 · Accepted Answer

Your SQL command has a syntax error between the RG and Address fields (a comma is missing between fields). Here is the changed command:

UPDATE FUNCIONARIO 
   SET CPF_FUNCIONARIO=@CPF,
       NOME_FUNCIONARIO=@NOME,
       RG_FUNCIONARIO=@RG,
       ENDEREÇO_FUNCIONARIO=@ENDERECO,
       NUMERO_FUNCIONARIO=@NUMERO,
       BAIRRO_FUNCIONARIO=@BAIRRO,
       CEP_FUNCIONARIO=@CEP,
       CIDADE_FUNCIONARIO=@CIDADE,
       ID_CARGO=@CARGO,
       AUMENTO_FUNCIONARIO=@AUMENTO 
 WHERE CPF_FUNCIONARIO=@ID