在mysql中如何将3列从一个表复制到另一个表?

I have two tables and both include 2 columns, sureness and kindness and and they are related to each other by dataitemID and id. Just to show you the structure I will put 2 selects that I got from database:I have two tables and both include 2 columns, s