In MySQL, bulk importing data from one table to another in the case of web development or application development, we often encounter situations where it is necessary to bulk import data from a MySQL table into another table, and sometimes even to specify an import field. This article will take the MySQL database as an example, how to import all the data of a table or the data of a specified field into the target table through the SQL command line. Category one, if the fields of the two tables (export table and target table) are consistent, and you want to insert all the data, you can use this method: (This method is only suitable for exporting two tables in the same database) insert INTO target table SELECT * from source table; For example, to articles Table is inserted into the Newarticles table, you can do this by using the following SQL statement: INSERT INTO Newarticles SELECT * from articles, category two, if you only want to import the specified fields, you can use this method: INSERT INTO Mesh Standard table (field 1, Field 2, ...) SELECT Field 1, Field 2, ... From source table; Note that the fields of both tables must be the same (field type), or a data conversion error will occur. Category three in addition to importing the specified fields, you also want to import some variables, invariants: For example: Content copy migration, the designated column table Caterel under a column copy to the B column one copy INSERT into Caterel (caterel field) Select b column field, fixed value (b column ID), now () from Caterel where column id=a column ID
Batch import data from one table into another table in MySQL (different cases)