Setting up sample databases


There are some sample databases for MySQL which might be a) a good excercise trying to load them into your system and b) good to get some real examples

So http://dev.mysql.com/doc/

Scroll down a bit and you get to Example databases

Now - I used Sakila for Postgresql - so I will use the same for MySQL. Lets download and have a look:

 

We can now load the schema file into SQLYog.

Please note tha you need to SELECT the whole file inside the query window otherwise you will just get a single

(0 row(s) affected)

(0 ms taken)

And do the same with the data file. And we are done.