MySQL correction Column

MySQL ALTER column ALTERTABLE: add, modify, and delete table columns, constraints, and other table definitions. View column: desc table name; Modify Table Name: altertablet_bookrenametobbb; add column: altertable table name addcolumn column name varchar (30); delete column: altertable table name dropcolumn name; Modify column name MySQL: alte

Alter table: add, modify, and delete TABLE columns, constraints, and other TABLE definitions. View column: desc table name; Modify table Name: alter table t_book rename to bbb; add column: alter table name add column name varchar (30); delete column: alter table Name drop column name; Modify column name MySQL: alte

Modify MySQL Columns

Alter table: add, modify, and delete TABLE columns, constraints, and other TABLE definitions. View column: desc table name; Modify table Name: alter table t_book rename to bbb; add column: alter table name add column name varchar (30); delete column: alter table Name drop column name; Modify column name MySQL: alter table bbb change nnnnn hh int; Modify column name SQLServer: exec sp_rename't _ student. name ', 'nn', 'column '; modify the column name Oracle: alter table bbb rename column nnnnn to hh int; modify the column attribute: alter table t_book modify name varchar (22 ); sp_rename: the built-in Stored Procedure of SQL Server, which is used to modify the table definition.