How to change (Update) a column name in a table using MySQL Workbench?

Question

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

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

Answer 1

You can change it by following these steps:

• Right-click the table shown on the left on the Schema tab on the desktop, and then select Alter Table . You will get such a window →

• Here you can see the available column names, edit here and click "Apply."

You are done.