how to change (Update) column name in table using

问题:

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.

回答1:

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.