{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Lab1.2 - We use the classicmodels database as a MySQL...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
We use the classicmodels database as a MySQL sample database to help you work with MySQL quickly and effectively. The classicmodels database is a retailer of scale models of classic cars database. It contains typical business data such as customers, products, sales orders, sales order line items, etc. We use this sample database in our MySQL tutorials to demonstrate many MySQL features from simple queries to complex stored procedures . After uncompressing the sampledatabase.zip file, you can load the sample database into MySQL database server by following how to load sample database into MySQL database server tutorial (refer to Lab3)and test it by using the following SQL statements: 1 2 USE classicmodels; SELECT * FROM customers; Basically, those statements switch the current database to classicmodels
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}