[SOLVED] how to change (Update) column name in table using MySQL workbench?

Issue

I am new to MySQL. I created a table with column name First Name but it is wrong.

Now I want to change my column name First Name to First_Name. Is it possible? If yes please explain how I can change my column name.

Solution

You can change it by following these step :

1. Right click the table shown at the left in Schema tab of workbench and then select Alter Table. You will get a window like this ->
   

2. Here you can see the column names available, edit here and click on apply.

You are done.

Answered By – Kshitij Kulshrestha

Answer Checked By – David Marino (BugsFixing Volunteer)