title: Getting java.sql.SQLException: Column count doesn't match value count at row 1
body: <p>I am creating a website using JDBC,I get the following error while running TOMCAT and what should I do to solve this,I have created 6 columns in MYSQL workbench as uname,pass,name,city,email,phone   but still getting this error. </p>
  
  <p>this is my register.java servlet file ,I run this and copy paste the class i get to the WEB-INF/classes folder</p>
  
  <pre><code>public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException{
          response.setContentType("text/html");
              PrintWriter out=response.getWriter();
          try{
              Class.forName("com.mysql.jdbc.Driver");
              Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/form","root","sudhakar");
  
              String uname = request.getParameter("uname");
              String psw = request.getParameter("psw");
              String nam = request.getParameter("nam");
              String cit = request.getParameter("cit");
              String ema = request.getParameter("ema");
              String num = request.getParameter("num");
                      PreparedStatement pst = con.prepareStatement("insert into login values(?,?,?,?,?,?)");
                      pst.setString(1,uname);
                      pst.setString(2,psw);
                      pst.setString(3,nam);
                      pst.setString(4,cit);
                      pst.setString(5,ema);
                      pst.setString(6,num);
                      pst.executeUpdate();
                      out.print("Successs");
  
          }catch(Exception e){
              out.print(e);
          }
      }
  }
  </code></pre>