Column count doesn ' t match value count at row 1 problem resolution

INSERT into TableA select * TableB Where Condition
### Cause:java.sql.SQLException:Column Count doesn ' t match value count at row 1

; Bad SQL Grammar []; Nested exception is Java.sql.SQLException:Column count doesn ' t match value count at row 1

Reason: TableA and tableb Two tables have inconsistent number of fields.

Workaround: Modify one of the tables in the two tables to ensure that the fields in the two tables are consistent.

Note: When using SQL statements such as the INSERT into TableA select * from TableB, make sure that the two-table creation statements are consistent, that is, the table structure of the two tables remains consistent.