Is it possible to take a description of the required fields from an existing table and add them to another table using mysql/phpmyadmin , in order not to do it manually? Tables are already created and filled with data. Thank.

  • Do you want to migrate data columns? - cheops
  • No, I added several new columns in one table and want to create the same columns in a pair of other tables, but not manually in each, but indicate which columns I want to take from this table and add to others. - user3416803
  • Install Navicat Premium, there you can export only the database structure - Ivan Turcan
  • I have structures, the situation is this: I added several fields to one table (5 pieces). But it turned out that exactly the same fields will have to be added to 4 other tables. Actually the question is how to add these 5 fields to other tables in a simple automated way and not with your hands to each? - user3416803

1 answer 1

Regular funds for the implementation of such an operation in phpMyAdmin is not provided. When changing the structure, you can copy the ALTER requests to which phpMyAdmin resorts. The query that was used to change the structure is displayed immediately after the successful execution of the operation. After that, you can replace the table name in queries and execute queries in the SQL section.

  • Yes, thanks, I did it - it turned out to be quite convenient. - user3416803