Learning MySQL - Downloads

This page contains files you can download to save you from typing in all the examples. The two compressed (zipped) files Data.zip and Examples.zip contain all the database files and the source code example files respectively.
You can also view the individual files; note that PHP files appear with the PHP source (.phps) extension so that you can view the source from this page.

You can download MySQL, XAMPP, and Mac OS X developer tools from the links below:

Also see the list of links on the Useful Links page.

NameLast modifiedSize (KB)

1  

[AllInOneFile]

09/01/2011

11:21 pm

  1  Data.zip15/01/20123:42 am25
  2  Examples.zip09/01/201111:21 pm117

2  

[Data]

09/01/2011

11:21 pm

  1  academics.csv09/01/201111:21 pm13
  2  academics.xls09/01/201111:21 pm35

1  

[SQL_files_with_foreign_key_references]

09/01/2011

11:21 pm

  1  Flight.sql15/01/20123:43 am1
  2  University.sql15/01/20123:43 am1
  3  music.sql15/01/20123:43 am12

2  

[SQL_files_with_no_foreign_key_references_as_in_the_book]

09/01/2011

11:21 pm

  1  Flight.sql09/01/201111:21 pm0
  2  University.sql09/01/201111:21 pm1
  3  count_users.sql09/01/201111:21 pm0
  4  music.sql09/01/201111:21 pm11
  5  producer.sql09/01/201111:21 pm2

3  

[Examples.source]

09/01/2011

11:21 pm


1  

[04.design]

09/01/2011

11:21 pm


1  
[MySQL_WorkBench.5.0]
09/01/2011
11:21 pm
  1  University.mwb09/01/201111:21 pm8
  2  flight.mwb09/01/201111:21 pm6
  3  music.mwb09/01/201111:21 pm7

2  
[MySQL_WorkBench.5.1]
09/01/2011
11:21 pm
  1  University.mwb09/01/201111:21 pm6
  2  flight.mwb09/01/201111:21 pm5
  3  music.mwb09/01/201111:21 pm5

2  

[13.wda]

09/01/2011

11:21 pm

  1  hello.phps09/01/201111:21 pm0

3  

[14.php]

09/01/2011

11:21 pm

  1  add.phps09/01/201111:21 pm0
  2  all.phps09/01/201111:21 pm0
  3  conditionals.phps09/01/201111:21 pm1
  4  date_difference.phps09/01/201111:21 pm1
  5  error_log.phps09/01/201111:21 pm0
  6  form.for_printuser.html09/01/201111:21 pm0
  7  form.html09/01/201111:21 pm0
  8  hello.cl.all_args.phps09/01/201111:21 pm0
  9  hello.cl.args.phps09/01/201111:21 pm0
  10  hello.cl.phps09/01/201111:21 pm0
  11  passing_by_value_and_reference.phps09/01/201111:21 pm1
  12  printuser.phps09/01/201111:21 pm0
  13  query_artists.mysqli.phps09/01/201111:21 pm1
  14  query_artists.phps09/01/201111:21 pm1
  15  scope.phps09/01/201111:21 pm0
  16  test.phps09/01/201111:21 pm0

4  

[15.phpapp]

09/01/2011

11:21 pm

  1  salt.phps09/01/201111:21 pm0

1  
[Misc]
09/01/2011
11:21 pm
  1  braces.phps09/01/201111:21 pm0
  2  escapes.phps09/01/201111:21 pm5
  3  process.phps09/01/201111:21 pm0
  4  process.reload.phps09/01/201111:21 pm0
  5  querydb.mysqli.cl.phps09/01/201111:21 pm0
  6  receipt.phps09/01/201111:21 pm0
  7  session_example.phps09/01/201111:21 pm0

2  
[Wedding]
09/01/2011
11:21 pm
  1  action.phps09/01/201111:21 pm3
  2  db.phps09/01/201111:21 pm1
  3  disclaimer09/01/201111:21 pm0
  4  edit.phps09/01/201111:21 pm7
  5  index.phps09/01/201111:21 pm4
  6  license.txt09/01/201111:21 pm0
  7  list.phps09/01/201111:21 pm4
  8  logout.phps09/01/201111:21 pm0

1  
[SQL]
09/01/2011
11:21 pm
  1  create_wedding_database.sql09/01/201111:21 pm0
  2  grant_privileges.sql09/01/201111:21 pm0
  3  populate_wedding_database.sql09/01/201111:21 pm1

5  

[16.perl]

09/01/2011

11:21 pm

  1  0e0.pl09/01/201111:21 pm0
  2  Animals.add.pl09/01/201111:21 pm0
  3  Animals.array.pl09/01/201111:21 pm0
  4  Animals.command_line.file.pl09/01/201111:21 pm1
  5  Animals.command_line.stdin.pl09/01/201111:21 pm1
  6  Animals.command_line.tofile.pl09/01/201111:21 pm1
  7  Animals.hash.pl09/01/201111:21 pm0
  8  Animals.hash.while.pl09/01/201111:21 pm0
  9  Animals.pl09/01/201111:21 pm2
  10  HelloWorld.pl09/01/201111:21 pm0
  11  Loops.pl09/01/201111:21 pm0
  12  animals.command_line.pl09/01/201111:21 pm0
  13  animals.command_line.types.pl09/01/201111:21 pm1
  14  animals.csv09/01/201111:21 pm0
  15  boolean.pl09/01/201111:21 pm0
  16  comparisons.pl09/01/201111:21 pm0
  17  conditionals.pl09/01/201111:21 pm1
  18  format_specifiers.pl09/01/201111:21 pm0
  19  out.csv09/01/201111:21 pm0
  20  out.txt09/01/201111:21 pm0
  21  readfile.pl09/01/201111:21 pm0
  22  scope.pl09/01/201111:21 pm0
  23  sum.pl09/01/201111:21 pm0
  24  sum_average.functions.command_line_args.pl09/01/201111:21 pm0
  25  sum_average.functions.pl09/01/201111:21 pm0
  26  temperature.pl09/01/201111:21 pm0
  27  testcommas.pl09/01/201111:21 pm0
  28  tr_test.pl09/01/201111:21 pm0

6  

[17.perl_MySQL]

09/01/2011

11:21 pm

  1  Animals.bind.v2q.pl09/01/201111:21 pm1
  2  Animals.command_line.MySQL_test_db.pl09/01/201111:21 pm0
  3  Animals.command_line.file.bind.outputcsv.pl09/01/201111:21 pm1
  4  Animals.command_line.file.bind.pl09/01/201111:21 pm2
  5  Animals.fetchrow_arrayref.pl09/01/201111:21 pm0
  6  Animals.fetchrow_hashref.bind.pl09/01/201111:21 pm0
  7  Animals.fetchrow_hashref.pl09/01/201111:21 pm0
  8  Animals.undef.pl09/01/201111:21 pm0
  9  mysql.bind.pl09/01/201111:21 pm0
  10  mysql.do.pl09/01/201111:21 pm1
  11  mysql.pl09/01/201111:21 pm1
  12  select.pl09/01/201111:21 pm0

7  

[18.perl_web]

09/01/2011

11:21 pm

  1  2_cgi_script.pl09/01/201111:21 pm0
  2  HelloWorld.cgi.pl09/01/201111:21 pm0
  3  HelloWorld.pl09/01/201111:21 pm0
  4  age.untaint.pl09/01/201111:21 pm0
  5  form.cgi.pl09/01/201111:21 pm0
  6  form.pl09/01/201111:21 pm0
  7  mysql.cgi.animals.cgipm.pl09/01/201111:21 pm0
  8  mysql.cgi.animals.nocgi.pl09/01/201111:21 pm0
  9  mysql.cgi.animals.nocgipm.pl09/01/201111:21 pm0
  10  mysql.cgi.animals.popup.pl09/01/201111:21 pm1
  11  mysql.cgi.mailing_list.pl09/01/201111:21 pm1
  12  mysql.cgi.user.pl09/01/201111:21 pm1
  13  name.untaint.pl09/01/201111:21 pm1
  14  name.untaint.two.pl09/01/201111:21 pm1
  15  popup_menu.pl09/01/201111:21 pm1

4  

[UpdatedFigures]

09/01/2011

11:21 pm

  1  Figure.4-13.png09/01/201111:21 pm27
  2  Figure.4-15.png09/01/201111:21 pm88
  3  Figure.4-4.png09/01/201111:21 pm18
  4  Figure.4-5.png09/01/201111:21 pm16