MySQL Basic operation

MySQL Modify table field name:

ALTER TABLE tablename Change oldname newname TINYINT;

To import data from one table into another table:

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.

MySQL Basic operation