From the course: MySQL Database Administration

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Adding and removing columns using the MySQL Workbench UI

Adding and removing columns using the MySQL Workbench UI - MySQL Tutorial

From the course: MySQL Database Administration

Start my 1-month free trial Buy for my team

Adding and removing columns using the MySQL Workbench UI

“

- [Instructor] All right, now we're going to talk about adding and dropping columns using the Workbench UI. In addition to creating new tables which are already fully defined and have every column that they might ever need, we can also add or drop columns from existing tables. I wish that in the real world we could architect our databases so that they would have every column which the business will need eventually. In real life, that's not always how it works. It comes up a lot that there's something else that we need to be storing that we weren't initially, and we go in and we need to add another column. There's also reasons where we may need to remove a column. A major current example of that is storing personally identifiable information. That's become a major hot button for companies now. So a lot of companies that were storing certain information before have decided to remove that from their databases. And that's one example of when you might want to be dropping columns. So just…

Contents