SQL statement for adding, modifying, and deleting columns in MySQL

Alter table: add, modify, and delete table columns, constraints, and other table definitions.

• View column: DESC table name;
• Alter table t_book Rename to BBB;
• Add column: alter table table name Add column name varchar (30 );
• Delete column: alter table Table Name drop column name;
• Alter column name MYSQL: alter table bbb change nnnnn HH int;
• Modify the column name sqlserver: exec sp_rename 't_ student. name', 'nn ', 'column ';
• Modify the column name ORACLE: LTER table BBB rename column nnnnn to HH int;
• 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.

• View column: DESC table name;
• Alter table t_book Rename to BBB;
• Add column: alter table table name Add column name varchar (30 );
• Delete column: alter table Table Name drop column name;
• Alter column name MYSQL: alter table bbb change nnnnn HH int;
• Modify the column name sqlserver: exec sp_rename 't_ student. name', 'nn ', 'column ';
• Modify the column name ORACLE: LTER table BBB rename column nnnnn to HH int;
• 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.