MySQL and MSQL

Randy J. Yarger is a senior solution developer at US Web/CKS in Southfield, Michigan. He combines expertise in database construction and interaction with extensive knowledge of the Internet to create world-class web applications. Randy has an uncanny knack of growing attached to computer systems that quickly become defunct. His first computer was a VIC-20, after which he moved on to the Commodore 64, then to several Amigas, and finally to a NeXTStation. He plans for his next box to be an Intel-based Linux system, but he's considering going Microsoft to save everyone some trouble. Randy lives in Ann Arbor, Michigan with his fianc?e Stacie and cat Baci. George Reese has taken an unusual path into business software development. After earning a B.A. in Philosophy from Bates College in Lewiston, Maine, George went off to Hollywood where he worked on television shows such as The People's Court and ESPN's Up Close. The L.A. riots convinced him to return to Maine where he finally became involved with software development and the Internet. George has since specialized in the development of Internet-oriented Java enterprise systems. He is the author of O'Reilly's Database Programming with JDBC and Java and the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently works as a enterprise systems architect in Minneapolis, Minnesota. Tim King has been working with computers since the early 1980s, when he programmed games on his Commodore 64 computer and founded a computer club in his high school. He earned a bachelor's degree in computer science from the University of Minnesota Institute of Technology in 1991. While there, he taught Unix and vi classes and was the leader of a rag-tag group of vi devotees called the "VI Zombies." Presently, Tim is a software consultant in San Francisco, CA, specializing in database and web technologies. His favorite activity is snowboarding, but he also enjoys photography and reading. You can reach him at kingt@verio.com

Preface. I. Getting Started with MySQL and mSQL 1. Introduction to Relational Databases What Is a Database? What Is a Relational Database? Applications and Databases MySQL and mSQL. 2. Database Design Database Design Normalization A Logical Data Modeling Methodology Physical Database Design. 3. Installation MySQL mSQL. 4. MySQL Design Installing MySQL Running MySQL Database Administration MySQL Utilities Performance Tuning. 5. mSQL Design mSQL Versions Installing mSQL Running mSQL Database Administration mSQL Utilities. 6. SQL According to MySQL and mSQL SQL Basics Creating and Dropping Tables SQL Datatypes Indices Sequences and Auto-Incrementing Managing Data Queries Extended Functionality. 7. Other Mid-Range Database Engines What Is "Free"? What MySQL and mSQL Lack PostgreSQL GNU SQL Beagle Making Comparisons II. Database Programming. 8. Database Application Architectures The Client/Server Architecture Data Processing Object/Relational Modeling The Three-tier Architecture. 9. CGI Programming What Is CGI? HTML Forms The CGI Specification Important Considerations for CGI Scripts CGI and Databases. 10. Perl DBI An Example DBI Application Msql.pm MysqlPerl. 11. Python Basic Connectivity Dynamic Connectivity 12. PHP and Other Support for Database-driven HTML Alternatives for Dynamic Content on the Web W3-mSQL PHP Embedded Perl. 13. C and C++ The Two APIs Object-oriented Database Access in C++. 14. Java and JDBC What Is JDBC? Simple Database Access Dynamic Database Access A Guest Book Servlet. III. Reference. 15. SQL Reference MySQL SQL mSQL SQL. 16. MySQL and mSQL System Variables MySQL System Variables mSQL System Variables. 17. MySQL and mSQL Programs and Utilities MySQL Utilities mSQL Utilities. 18. PHP and Lite Reference PHP Lite. 19. C Reference MySQL C API mSQL C API. 20. Python Reference Module: MySQL Module: mSQL. 21. Perl Reference Installation DBI.pm API Msql.pm API Mysql.pm API. 22. JDBC Reference Index.