rename table name in mysql

problem by reducing the scenario of table reconstruction and table lock, but this method cannot cover all possible operations, for example, when modifying the Data Type of a column, full table reconstruction is required. Przemysaw and malkoski discussed how to modify the definition in Mysql5.6 last year in as much detail as possible. With the new features of

connection query (mainly left table record)2. Right connection query (based on right table record) Left Join answer QueryFormat: Select field List from Table A LEFT JOIN table B on conditional expression; Right connection queryFormat: Select field Name list from

The Parameter Name of the mysql stored procedure should not be the same as the field name. The result will be that the parameter value will not be the value you passed in, it is the value of the field in each record. Such consequences are often serious. For example, you can delete all the records of the entire table. T

Title, the result will be that the value of the parameter will not be the value you passed in, but the value of the field for each record.The consequences of this are often severe. For example, to perform a delete operation, it can completely delete the entire table record.This is my bloody price.The dead pit is as follows, do not jump:[SQL]View Plaincopy DELIMITER $$ Use ' b10k ' $$ DROP PROCEDURE IF EXISTS ' sp_delete_species '

table exists.Copy the old table data to the new table (assuming the two tables have the same structure) insert into new_tableselect * from old_table; Copy the old table data to the new table (assuming the two tables have different structures) insert into new_table(field1

table can have more unique keys to create indexes index index_nameALTER TABLE Xixi add index index_name (name)--defines the index when creating a table with the Name field under the Xixi table: Create tables Xixi (ID int (4),

NameDROP PRIMARY KEY;Note: If you have a auto_incrment attribute, you must first delete theAuto_incrment to delete a primary key 9. Add UniquenessA.alter Table NameADD UNIQUE key| INDEX (field name);B.a.alter Table NameADD [CONSTRAINT constraint name] UNIQUE key| INDEX (field name