How to insret data in A table from Another two Table

Answer 1

maybe this link will help:

https://dev.mysql.com/doc/refman/5.7/en/insert-select.html

Answer 2

You need to select the needed columns and rows Front your two Tables with a join and then insert them into your new one.

Answer 3

That ist a good idea!
He should explain the use case, so he can get better help...

Answer 4

might be better to use foreign key constrain to create a table with references to the other two.

Answer 5

something like that.... you need key between B and C

Insert into A
select B.*, C.* from B
left join C on B.FK = C.FK

or a foreign key in A with references to B and C

Answer 6

INSERT INTO TABLE1 AS SELECT * FROM TABLE2

Answer 7

hello
how are you.whats your name

Answer 8

INSERT INTO SELECT