Introduction to MySQL
Organizers: Aaron Gabow (BIC, MSKCC), Manda Wilson (BIC, MSKCC)
Day 1:
- Notes: MySQLDay1.ppt
- SQL statements: Class1.sql
- Example database: trii.sql
- Exercises: MySQLDay1Assign.doc
Day 2:
- Notes: MySQLDay2.ppt
- SQL statements: Class2.sql
- Example library database: library.sql
- Example MS Excel spreadsheet: gene.xls
- Exercises: MySQLDay2Assign.doc
Day 3:
- Notes: An Intro to PHP and dynamic web content
- Today's examples
- Exercise 1: Springfield's favorite comic book store owner, the Comic Book Guy, needs your help. Create a website displaying his latest comic shipment. Here is some skeleton code to help you get started.
- Exercise 2: Yikes! The Comic Book Store Guy has taken up a newer, creepier interest -- the clan Simpson. Put aside your morals and help him make a table of some vital Simpson data. Here is some skeleton code to help you get started.
- Exercise 3: Take what you did in exercise 2 and build on it. Make a form that allows the user to upload a list of comma and semi-colon separated data and make a php script that displays it as a table. Maybe now would be a good time to make a function. No skeleton code for you this time.
Day 4:
- Notes: PHP and MySQL
- All code: in tarball form
Useful links
- MySQL documentation: http://dev.mysql.com/doc/
- PHP documentation: http://www.php.net/docs.php
MySQL & Perl
MySQL & Java
PHPMyAdmin
- PHPMyAdmin quick guide: PHPMyAdmin.ppt