mysql - 如何把数据库A表中的title数据 复制到同库数据表B的title里面

Question

如何把数据库A表中的title数据 复制到同库数据表B的title里面

Answer 1

You describe less, I don’t know if I understand it correctly

There is a function to export database tables in phpMyAdmin, and the exported file will have the table structure of the table

If you want to create a table with the same structure as this table, just copy and change the table name, and then run it

Answer 2

If table b is empty, you can execute SQL statements like insert select to complete this function. If table b has data, it is also feasible to execute update select