city: The city table contains a list of cities.category: The category table lists the categories that can be assigned to films.address: The address table contains address information for customers, staff, and stores.actor: The actor table lists information for all the actors, includes first name and last name of actors.There are 16 tables, 7 views, 3 stored procedures, 3 stored functions and 6 triggers in The Sakila database. If not, please install the Sakila sample database first. If you choose the Full type of MySQL Installation, the Sakila sample database will be installed by default. The Sakila database models the DVD rental store business, which contains content such as films, actors, inventory, stores, customers and staffs. The Sakila sample database is one of the most widely used sample databases. In the whole MySQL tutorial, we use the Sakila sample database as a demo database to learn MySQL more quickly and effectively.
0 kommentar(er)
