Lesson 11 - MySQL Step By Step: Structure Change, Transactions and Views
In the previous lesson, MySQL Step By Step: Subqueries, we learned to use subqueries. Today, we're going to show how to change the structure of an existing database, we'll use transactions and views.
Changing the database structure
MySQL allows us to change the structure of an existing database while keeping
the existing data in it. We do it by the
Changing the table structure
We can do several changes to a table. To add, change, and remove columns, is
now the most important for us. Let's add a new
thumbs_up column to
comment table, so our visitors can rate the comments:
...End of the preview...
ict.social is a large database made up of manuals and tutorials, whose main goal is to provide high-quality IT education to everyone. We started out in the Czech republic, where we display roughly a million articles per month and receive plenty of gratitude from our users. Thanks to our successful establishment, we are now bringing these articles to the rest of the world.
Although we are trying to keep our content free of charge, maintaining the site is a huge effort for everyone involved. Therefore, some content (exercises and more advanced material) costs network points. Don't worry, they're really cheap :)
Requested article covers this content:
In this tutorial, we'll learn how to modify the MySQL database structure (mainly tables) using the ALTER statement, explain transactions, and create views.
Buying this article gives you unlimited access to it forever. You will learn some more and help us keep giving our site maintenance which helps you and others get better futures. It's a win-win.
You gain points by supporting our network. This is done by sending a helpful amount of money to support the site, or by creating content for the network.
You can get points immediately using:
|Credit card||SMS||Wire transfer|