Creating a database
A MySQL server requires a database to store and organize data. Your MySQL server can hold many databases and will efficiently work with all of the databases and multiple client connections simultaneously. In fact, each client will seemingly have exclusive access to the server and database; however, often, they will be sharing it with many or perhaps even hundreds of other people.
Databases are logical containers that group tables together to achieve a goal by providing special access rights, user management, and many other useful features.
A database schema is the collection of data tables, views, stored procedures, and functions that make up the database. To make the MySQL server useful, you need to have created at least one database.
In the following exercise, you will create the autoclub database.
Exercise 2.02 – creating the autoclub database
In this scenario, you are the database administrator of an automobile club. Every database system...
