CODEWITHSUNDEEP
mysqldatabasenetbeans
c0dehunter
c0dehunter

Reputation: 6160

Change existing MySQL table inside NetBeans

I created a table inside NetBeans but one column is wrong type, it should be char instead of int. Is it possible to change it or do I have to delete the whole table and start again?

I searched all context menus but can't find "modify"/"edit" option.

Upvotes: 1

Views: 5162

Answers (2)

gumuruh
gumuruh

Reputation: 2570

my suggestion also you have two options :

1) By using Netbeans, you could edit (change) the current mysql table via Command Execution.

2) By using mysql ADministrator tool, such as MySQL Query Browser from mysql GUI Tool itself

Happy coding!

Upvotes: 1

Packet Tracer
Packet Tracer

Reputation: 3924

you can right click on the column name and select "delete option", then right click on the table name and select "add column" option.

Upvotes: 0

Related Questions