Member-only story
ALTER TABLE ADD COLUMN — MySQL Shell Python style
We all know as SQL professionals that a common use of the ALTER TABLE command is that we can change a tables’ structure in a myriad number of ways. And, that’s a good thing too because chances are, you won’t always nail down the initial structure. Due to changing business or application requirements, you may even have to add additional columns that were not considered during the schema design phase. Suppose you have many tables that are structured similarly and they all need a specific column added to their already-existing design. Under certain circumstances, using the MySQL Shell in Python mode (\py), can reduce the number of manual ALTER TABLE statements you have to type. Continue reading to see examples in the MySQL Shell…
OS, Software, and DB used:
- OpenSuse Leap 15.1
- MySQL 8.0.21
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!
If you have read the post, MySQL Shell Python mode for multiple ALTER TABLE statements — easily, then you might recall I used these 3 tables, all of which have similar columns and structure:
