MySQL: Visual QuickStart Guide (1st Edition)-->SQL Statements
The CREATE and some of the INSERT SQL commands from the book are available here to be downloaded. Although these scripts are written and organized as they are in the book, they do include any updates and changes as warranted by errors which were found after publication. Thus, if you are having problems with a particular SQL command, download the most current version here or check the errata section. If you find a problem with one of the files here, please contact me with the details.
To create the SQL files, I started by retyping all of the CREATE statements (and some ALTERs) as they appear in the book. These are organized by chapter. Then I also included phpMyAdmin dumps of the databases used in the book (accounting, movies_db, test). These include some sample INSERTs. Note that you will probably have to modify these files before using them in your databases.
You should not attempt to run the entire SQL file in batch mode.
These files have been formatted with line breaks that will work on most systems running most text editors. If you have difficulty opening a script, try:
- adjusting the way your text editor treats text files
- using a different text editor, if possible
- posting a message to the online forum, asking for help
- contacting me and I will try to assist
| SQL Commands | |
| Formats and Size | Date Modified |
| sql.zip (8 k) sql.sit (7 k) sql.tgz (4 k) |
Wednesday November 07, 2007 |
Newsletter #25 Sent!
The latest newsletter went out today. If you're not subscribed to receive it, you can read it online.(February 2, 2010)
Newsletter #24 Released
The latest newsletter went out today. If you're not subscribed to receive it, you can read it online.(December 17, 2009)
New Blog Series on the Yii Framework
I've been writing a series of articles on the Yii framework for PHP Web development. There are currently seven posts, taking you from start to finish of the development process, with more to come.(November 12, 2009)
