Change the column name from StudentName to FirstName in MySQL?

Use CHANGE with ALTER statement. Let us first create a table −

mysql> create table DemoTable -> ( -> StudentName varchar(100), -> Age int -> ); Query OK, 0 rows affected (0.84 sec)

Now check the description of table −

mysql> desc DemoTable;

Output

This will produce the following output −

+----------------+--------------+------+-----+---------+-------+ | Field          | Type         | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | StudentName    | varchar(100) | YES | | NULL | | | Age            | int(11)     | YES | | NULL | | +----------------+--------------+------+-----+---------+-------+ 2 rows in set (0.25 sec)

Here is the query with ALTER −

mysql> alter table DemoTable -> add column Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> add column CountryName varchar(100) after Age, -> change column StudentName FirstName varchar(200); Query OK, 0 rows affected (1.51 sec) Records: 0 Duplicates: 0 Warnings: 0

Now check the description of table once again −

mysql> desc DemoTable;

Output

This will produce the following output −

+-------------+--------------+------+-----+---------+----------------+ | Field       | Type         | Null | Key | Default | Extra          | +-------------+--------------+------+-----+---------+----------------+ | FirstName   | varchar(200) | YES  |     | NULL    |                | | Age         | int(11)      | YES  |     | NULL    |                | | CountryName | varchar(100) | YES  |     | NULL    |               | | Id          | int(11)      | NO   | PRI | NULL    | auto_increment | +-------------+--------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec)