dsl dsl - 1 year ago 116
MySQL Question

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

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
. Is it possible? If yes please explain how I can change my column name.

Answer Source

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 -> enter image description here

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

You are done.