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 ALTER statement.
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
the comment table, so our visitors can rate the comments:
...End of the preview...
Continue further
You've come here and that's great! We believe that the first lessons showed you something new and useful
Do you want to continue the course? Go to the premium section.
Buy this course
Before buying this article, you have to buy the previous one
This article is licensed: Premium, by buying this article, you agree with the terms of use.
- Unlimited and permanent access to individual lessons.
- High quality IT knowledge.
- Skills to help you get your dream and well-paid job.
Article description
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.
You gain credits 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.
David learned IT at the Unicorn University - a prestigious college providing education on IT and economics.