MySQL inserts the data queried in Table a into Table B.

MySQL inserts the data queried in Table a into Table B if Table B has 1codeclasssqlcodeclasssqlcodeclasssqlinsertintobselect * froma; codecodecode if Table B does not have 1 partition

MySQL inserts the data queried in Table a into Table B. If table B has 1 code class = sqlcode class = sqlinsert into B select * from; /code if Table B does not exist 1 code class = sqlcode class = sqlc

MySQL inserts the data queried in Table a into Table B.

If table B exists

1

insert into b select * from a;

If table B does not exist

1

create table b as select * from a;

Extension:

Insert a write segment value in Table B to Table.

1

insert into a (userID,userName) select b.userID,b.userName from tr_ajax_chat_messages;

Save the userID values of table a and table B to Table.

1update a set a.userName=(select b.userName from b where a.userID = b.userID);