problem with inser into query

[sahar sa]

Dear friends,
I have a table with column titles as: (id, price,quality,deadline,UtilityValue,sellerNumber) which Id is an AUTO_INCREMENT!
now I want to copey this table to another table with the exact same column titles. till here every thing is ok! but I DONT want to copy the id field. what I want is that I copy the data of each row except id which should be filled AUTO_INCREMENTAly.
so I write below code:

 pstmt = con.prepareStatement("INSERT INTO sellerGApool SELECT price,quality,deadline,UtilityValue,sellerNumber FROM newSellerGApool"+" where sellerNumber=?");   

and I get this error:

java.sql.SQLException: Column count doesn't match value count at row 1
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
SQLException: Column count doesn't match value count at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
        at GA.NewGApoolDB.CopyFromNewGApoolDBToGApoolDB(NewGApoolDB.java:594)
        at GA.GAalgorithm.TransferGAdbToNewGAdb(GAalgorithm.java:150)
        at GA.GAalgorithm.GAalgorithm(GAalgorithm.java:76)
        at GA.NewMain.main(NewMain.java:37)

I guess it error is related to the id column which I didn't mentioned in insert into query. Am I right? If yes Do you know how can I correct it?
Thank you sooo much!
SAhar.

[Vijitha Kumara]

Which DB are you using? For MySQL check this
You might need to specify the required field of both tables in the query. Haven't tried this recently so can't remember exactly