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]

10/01/2011

4:21 am

  1  Data.zip15/01/20128:42 am25
  2  Examples.zip10/01/20114:21 am117

2  

[Data]

10/01/2011

4:21 am

  1  academics.csv10/01/20114:21 am13
  2  academics.xls10/01/20114:21 am35

1  

[SQL_files_with_foreign_key_references]

10/01/2011

4:21 am

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

2  

[SQL_files_with_no_foreign_key_references_as_in_the_book]

10/01/2011

4:21 am

  1  Flight.sql10/01/20114:21 am0
  2  University.sql10/01/20114:21 am1
  3  count_users.sql10/01/20114:21 am0
  4  music.sql10/01/20114:21 am11
  5  producer.sql10/01/20114:21 am2

3  

[Examples.source]

10/01/2011

4:21 am


1  

[04.design]

10/01/2011

4:21 am


1  
[MySQL_WorkBench.5.0]
10/01/2011
4:21 am
  1  University.mwb10/01/20114:21 am8
  2  flight.mwb10/01/20114:21 am6
  3  music.mwb10/01/20114:21 am7

2  
[MySQL_WorkBench.5.1]
10/01/2011
4:21 am
  1  University.mwb10/01/20114:21 am6
  2  flight.mwb10/01/20114:21 am5
  3  music.mwb10/01/20114:21 am5

2  

[13.wda]

10/01/2011

4:21 am

  1  hello.phps10/01/20114:21 am0

3  

[14.php]

10/01/2011

4:21 am

  1  add.phps10/01/20114:21 am0
  2  all.phps10/01/20114:21 am0
  3  conditionals.phps10/01/20114:21 am1
  4  date_difference.phps10/01/20114:21 am1
  5  error_log.phps10/01/20114:21 am0
  6  form.for_printuser.html10/01/20114:21 am0
  7  form.html10/01/20114:21 am0
  8  hello.cl.all_args.phps10/01/20114:21 am0
  9  hello.cl.args.phps10/01/20114:21 am0
  10  hello.cl.phps10/01/20114:21 am0
  11  passing_by_value_and_reference.phps10/01/20114:21 am1
  12  printuser.phps10/01/20114:21 am0
  13  query_artists.mysqli.phps10/01/20114:21 am1
  14  query_artists.phps10/01/20114:21 am1
  15  scope.phps10/01/20114:21 am0
  16  test.phps10/01/20114:21 am0

4  

[15.phpapp]

10/01/2011

4:21 am

  1  salt.phps10/01/20114:21 am0

1  
[Misc]
10/01/2011
4:21 am
  1  braces.phps10/01/20114:21 am0
  2  escapes.phps10/01/20114:21 am5
  3  process.phps10/01/20114:21 am0
  4  process.reload.phps10/01/20114:21 am0
  5  querydb.mysqli.cl.phps10/01/20114:21 am0
  6  receipt.phps10/01/20114:21 am0
  7  session_example.phps10/01/20114:21 am0

2  
[Wedding]
10/01/2011
4:21 am
  1  action.phps10/01/20114:21 am3
  2  db.phps10/01/20114:21 am1
  3  disclaimer10/01/20114:21 am0
  4  edit.phps10/01/20114:21 am7
  5  index.phps10/01/20114:21 am4
  6  license.txt10/01/20114:21 am0
  7  list.phps10/01/20114:21 am4
  8  logout.phps10/01/20114:21 am0

1  
[SQL]
10/01/2011
4:21 am
  1  create_wedding_database.sql10/01/20114:21 am0
  2  grant_privileges.sql10/01/20114:21 am0
  3  populate_wedding_database.sql10/01/20114:21 am1

5  

[16.perl]

10/01/2011

4:21 am

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

6  

[17.perl_MySQL]

10/01/2011

4:21 am

  1  Animals.bind.v2q.pl10/01/20114:21 am1
  2  Animals.command_line.MySQL_test_db.pl10/01/20114:21 am0
  3  Animals.command_line.file.bind.outputcsv.pl10/01/20114:21 am1
  4  Animals.command_line.file.bind.pl10/01/20114:21 am2
  5  Animals.fetchrow_arrayref.pl10/01/20114:21 am0
  6  Animals.fetchrow_hashref.bind.pl10/01/20114:21 am0
  7  Animals.fetchrow_hashref.pl10/01/20114:21 am0
  8  Animals.undef.pl10/01/20114:21 am0
  9  mysql.bind.pl10/01/20114:21 am0
  10  mysql.do.pl10/01/20114:21 am1
  11  mysql.pl10/01/20114:21 am1
  12  select.pl10/01/20114:21 am0

7  

[18.perl_web]

10/01/2011

4:21 am

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

4  

[UpdatedFigures]

10/01/2011

4:21 am

  1  Figure.4-13.png10/01/20114:21 am27
  2  Figure.4-15.png10/01/20114:21 am88
  3  Figure.4-4.png10/01/20114:21 am18
  4  Figure.4-5.png10/01/20114:21 am16