Untitled

Syntax error in Prepared statement while inserting into db

public boolean SignUp(String last_name, String first_name,String email, String password,String confirm_password,String phone){

 

 

 

        Connect connect = new Connect();

        Connection conn = connect.Connection();

 

        java.sql.PreparedStatement preparedStatement = null;

        //NULL is the column for auto increment

        String insertQuery = "INSERT INTO users VALUES (NULL, ?, ?, ?, ?, ?, ?)";

        preparedStatement = conn.prepareStatement(insertQuery);

        preparedStatement.setString(1, last_name);

        preparedStatement.setString(2, first_name);

        preparedStatement.setString(3, email);

        preparedStatement.setString(4, password);

        preparedStatement.setString(5, confirm_password);

        preparedStatement.setString(6, phone);

 

        int rs = preparedStatement.executeUpdate(insertQuery);

 

        conn.close();

       

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 '?, ?, ?, ?, ?, ?)' at line 1

       

String insertQuery = "INSERT INTO users"

+  " (last_name, first_name, email, password, confirm_password, phone)"

+  " VALUES(?,?,?,?,?,?)";