{"id":586,"date":"2009-12-27T14:15:14","date_gmt":"2009-12-27T14:15:14","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=586"},"modified":"2023-12-29T02:03:56","modified_gmt":"2023-12-29T09:03:56","slug":"mysql-sample-database","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/getting-started-with-mysql\/mysql-sample-database\/","title":{"rendered":"MySQL Sample Database"},"content":{"rendered":"\n

We use the classicmodels<\/code> database as a MySQL sample database<\/strong> to help you work with MySQL quickly and effectively. <\/p>\n\n\n\n

The classicmodels<\/code> database is a retailer of scale models of classic cars. It contains typical business data, including information about customers, products, sales orders, sales order line items, and more.<\/p>\n\n\n\n

We’ll use this sample database in our MySQL tutorials<\/a> to demonstrate a wide range of MySQL features, from simple queries<\/a> to complex stored procedures<\/a>.<\/p>\n\n\n\n

Download MySQL Sample Database<\/h2>\n\n\n\n

You can download the sample database from the following link:<\/p>\n\n\n\n

Download MySQL Sample Database<\/a><\/p>\n\n\n\n

The download file is in ZIP format, so you’ll need a zip program to unzip it. You can download a free zip program at www.7-zip.org<\/a>.<\/p>\n\n\n\n

After uncompressing the sampledatabase.zip<\/code> file, you can load the sample database into the MySQL database<\/a> server by following the tutorial on how to do so.<\/p>\n\n\n\n

MySQL Sample Database Schema<\/h2>\n\n\n\n

The MySQL sample database schema consists of the following tables:<\/p>\n\n\n\n