MySQL insert into table not inserting all fields

Vote count:

0

I have 2 existing tables in a MySql DB. The tables have identical structures. I want to copy data from table to another.

insert into `Table1`
select * from Table2
where department = "engineering"

the above code seemed to work and it copied the data correctly except for 1 column. The "department" column did not copy over so it was blank. All the other fields seemed to copy over correctly for all of the records.

What can be causing this? As I mentioned both tables have identical structures, same number of columns and everything...

Any ideas?

asked 41 secs ago

JuanVelez

193