This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
don't try DO, ALWAYS list the column names, the error message is saying you haven't provided enough values in your insert statement.
There is another thread on here from a guy who found the columns were in diffenent order depending on how he ran his select statement.
Column order IS NOT RELIABLE.