java.sql.SQLSyntaxErrorException:

Question

first i created a 2 sql table one is functioning and the other is not the code in my java class is

    try {                           
            PreparedStatement ps1 = con.prepareStatement("INSERT INTO pattable(surname,first,middle,add,contact,email,bdate,genderr) values(?,?,?,?,?,?,?,?);");
            ps1.setString(1, surname);
            ps1.setString(2, first);
            ps1.setString(3, middle);
            ps1.setString(4, add);
            ps1.setString(5, contact);
            ps1.setString(6, email);
            ps1.setString(7, bdate);
            ps1.setString(8, genderr);
            ps1.execute(); 
            ps1.close();
            con.close();
    }
            catch(SQLException e){
                e.printStackTrace();
            }
}

According to console the error might be triggering at line ps1.execute in java with the line "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'add,contact,email,bdate,genderr)" please help Thanks for the Reply really need it for case study :)

instead if u want the add column name u can use [add] this will be acceptable in sql server. — Chandrashekhar Komati
– Chandrashekhar Komati, Commented Mar 2, 2021 at 5:36

Swati · Accepted Answer · 2020-02-04 06:53:51Z

12

You have one column name add ,this is reserved keyword in mysql .check here you cannot use that as your column name that the reason of error you are getting .

answered Feb 4, 2020 at 6:53

Swati

28.5k4 gold badges26 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

seenukarthi Over a year ago

@JustaNewProgrammer check stackoverflow.com/questions/2889871/…

ScarySpider · Accepted Answer · 2020-02-04 06:55:17Z

0

Your syntax is wrong, I'd review https://www.w3schools.com/sql/sql_insert.asp to find your problem.

answered Feb 4, 2020 at 6:55

ScarySpider

1375 bronze badges

Collectives™ on Stack Overflow

java.sql.SQLSyntaxErrorException:

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related