rename table name in mysql

Mysql "insert table name ......" Can table names make variables? Mysql " nbsp; insert nbsp; table name ......" Can table names make variabl

PHP gets the MySQL data table field name and details method, MySQL field First we need to understand the SQL statements that query MySQL database/table related information: Copy the Code code as follows:SHOW DATABASES//Lists the

About mysql stored procedure creation dynamic table name and parameter processing, mysql Stored ProcedureReprinted please indicate the source: curtain roll west wind column (http://blog.csdn.net/ljxfblog) Recently, the game started its second internal test, started to process operation logs, and first put the logs in

column Alter table t2 drop column c; // Rename a column Alter table t1 change a B integer; // Change the column type Alter table t1 change B bigint not null;Alter table infos change list tinyint not null default '0 ′; // Rename t

* from test;+------+--------+----------------------------------+------------+-------+------------+------------+| t_id | t_name | t_password | t_birth | birth | birth1 | birth2 |+------+--------+----------------------------------+------------+-------+------------+------------+| 1 | name1 | 12345678901234567890123456789012 | NULL | NULL | 0000-00-00 | 2013-01-01 || 2 | name2 | 12345678901234567890123456789012 | 2013-01-01 | NULL | 0000-00-00 | 2013-01-01 |+------+

Mysql adds a column, deletes a column, modifies a column name, and mysql columns at a certain position in the table. To add a column to a created table, run the following code: alter table na