Adding new column via MySQL Workbench into existing table

Question

I have existing table which is called person, I want to add via MySQL Workbench new column into it, for example column age. How can I manage this operation using this program, where and what I need to write?

I found query like this, should it works?

ALTER TABLE person ADD age INT(3);

Generally it's a bad idea to hold age in a table because it will be wrong as soon as it's added. — P.Salmon
– P.Salmon, Commented Oct 13, 2017 at 7:18
I just add this for example, of course I don't want to add something like this to table. How I said, it just for example. Could you help me with this? — chebad
– chebad, Commented Oct 13, 2017 at 7:19
Why don't you just try it and see mysql will complain if it doesn't like it also dev.mysql.com/doc/refman/5.7/en/alter-table.html — P.Salmon
– P.Salmon, Commented Oct 13, 2017 at 7:25
I want to learn how to use MySQL Workbench, because my company required it, so if you could tell me how to do it in this program (where I should wrote this) you would save my day. — chebad
– chebad, Commented Oct 13, 2017 at 7:28

Anad · Accepted Answer · 2017-10-13 08:26:22Z

77

I don't know if Stackoverflow is proper place to such question, but...

Click on the table you want to change (using right mouse button) and choose "Alter table" (schemas and tables lists are on the left).

In the opened tab you can add or change columns (GUI is very simple and intuitive).

Don't forget to save changes by clicking "Apply".

answered Oct 13, 2017 at 8:26

Anad

9487 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chud37 Over a year ago

I wouldnt say intuitive as I had to search to find the answer to this, it's a hidden column that you double click to create. Spent ages looking for a 'new column' button.

gdfgdfg Over a year ago

Where is the "Apply" button ?

Theresa Parker · Accepted Answer · 2022-12-30 20:37:59Z

0

I don't know if you have your answer, I know this thread is very old but in case someone else is looking, I just learned how to do this myself:

The syntax is:

ALTER TABLE person ADD COLUMN age INT;

Always list the datatype after the new column name. I hope this helps.

answered Dec 30, 2022 at 20:37

Theresa Parker

132 bronze badges

Collectives™ on Stack Overflow

Adding new column via MySQL Workbench into existing table

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related