Insert multiple pieces of data at a time

I have table an and table b, and some of the fields in the two tables are the same (if there is a field xmemery yjournal z). I want to assign the value of the same field in table a to b, but I have a table c, which is the information of all users. The only identification field p is the same as the p in table b.
so how does a piece of data in table a be assigned to table b and all users have this data, that is, there is data with the same number of users but different fields

Jun.06,2022

this kind of question is too brain-consuming. It is recommended that you directly tell your actual scenario
maybe there is a better implementation
if the connection is particularly complex, maybe your database design can be optimized

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1c2f627-568bd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1c2f627-568bd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?