MySQL mysql 데이터베이스의 데이터를 업데이트하는 쿼리는 무엇입니까?

데이터베이스의 값을 업데이트하는 쿼리가 있지만 뭔가 빠진 것 같습니다.

String sqlStr = "INSERT INTO userdb where userID=? (username,address,email,contact,credit,userpassword)" + "VALUES (?,?,?,?,?,?)";
                PreparedStatement pstmt = conn.prepareStatement(sqlStr);
                pstmt.setInt(1, userid);
                pstmt.setString(2,name);
                pstmt.setString(3,address);
                pstmt.setString(4,email);
                pstmt.setInt(5,contact);
                pstmt.setString(6,credit);
                pstmt.setString(7,password);
                int rec = pstmt.executeUpdate();

오류:

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 'where userID=1 (username,address,email,contact,credit,userpassword)VALUES ('abc'' at line 1

 

해결 방법

 

UPDATE userdb 
SET username = ?,
    address = ?, 
    email = ?,
    contact = ?,
    credit = ?,
    userpassword = ?
WHERE userID = ? 

 

참조 페이지 https://stackoverflow.com/questions/17929501