Buying Options
MySQL and mSQL
This product is no longer available.

Please consider the latest edition.

MySQL and mSQL

By
Tim King, George Reese, Randy Yarger
Publisher:
O'Reilly Media
Released:
July 1999
Pages:
502

Product Editions

  1. Managing & Using MySQL, Second Edition - April 2002
  2. MySQL and mSQL - July 1999 (out of print)
Description

Learn how to use MySQL and mSQL, two popular database products that support key subsets of SQL on Linux and Unix systems. Using basic C, Java, Perl, or Python, you can write a program to interact with a database, either as a stand-alone application or through a web page. This book covers the whole process, from installation to programming interfaces and basic administration. Includes ample tutorial material.

Full Description
Table of Contents

  1. Getting Started with MySQL and mSQL

    1. Chapter 1 Introduction to Relational Databases

      1. What Is a Database?
      2. What Is a Relational Database?
      3. Applications and Databases
      4. MySQL and mSQL

    2. Chapter 2 Database Design

      1. Database Design
      2. Normalization
      3. A Logical Data Modeling Methodology
      4. Physical Database Design

    3. Chapter 3 Installation

      1. MySQL
      2. mSQL

    4. Chapter 4 MySQL

      1. Design
      2. Installing MySQL
      3. Running MySQL
      4. Database Administration
      5. MySQL Utilities
      6. Performance Tuning

    5. Chapter 5 mSQL

      1. Design
      2. mSQL Versions
      3. Installing mSQL
      4. Running mSQL
      5. Database Administration
      6. mSQL Utilities

    6. Chapter 6 SQL According to MySQL and mSQL

      1. SQL Basics
      2. Creating and Dropping Tables
      3. SQL Datatypes
      4. Indices
      5. Sequences and Auto-Incrementing
      6. Managing Data
      7. Queries
      8. Extended Functionality

    7. Chapter 7 Other Mid-Range Database Engines

      1. What Is “Free”?
      2. What MySQL and mSQL Lack
      3. PostgreSQL
      4. GNU SQL
      5. Beagle
      6. Making Comparisons

  2. Database Programming

    1. Chapter 8 Database Application Architectures

      1. The Client/Server Architecture
      2. Data Processing
      3. Object/Relational Modeling
      4. The Three-tier Architecture

    2. Chapter 9 CGI Programming

      1. What Is CGI?
      2. HTML Forms
      3. The CGI Specification
      4. Important Considerations for CGI Scripts
      5. CGI and Databases

    3. Chapter 10 Perl

      1. DBI
      2. An Example DBI Application
      3. Msql.pm
      4. MysqlPerl

    4. Chapter 11 Python

      1. Basic Connectivity
      2. Dynamic Connectivity

    5. Chapter 12 PHP and Other Support for Database-driven HTML

      1. Alternatives for Dynamic Content on the Web
      2. W3-mSQL
      3. PHP
      4. Embedded Perl

    6. Chapter 13 C and C++

      1. The Two APIs
      2. Object-oriented Database Access in C++

    7. Chapter 14 Java and JDBC

      1. What Is JDBC?
      2. Simple Database Access
      3. Dynamic Database Access
      4. A Guest Book Servlet

  3. Reference

    1. Chapter 15 SQL Reference

      1. MySQL SQL
      2. mSQL SQL

    2. Chapter 16 MySQL and mSQL System Variables

      1. MySQL System Variables
      2. mSQL System Variables

    3. Chapter 17 MySQL and mSQL Programs and Utilities

      1. MySQL Utilities
      2. mSQL Utilities

    4. Chapter 18 PHP and Lite Reference

      1. PHP
      2. Lite

    5. Chapter 19 C Reference

      1. MySQL C API
      2. mysql_affected_rows
      3. mysql_close
      4. mysql_connect
      5. mysql_create_db
      6. mysql_data_seek
      7. mysql_debug
      8. mysql_drop_db
      9. mysql_dump_debug_info
      10. mysql_eof
      11. mysql_errno
      12. mysql_error
      13. mysql_escape_string
      14. mysql_fetch_field
      15. mysql_fetch_field_direct
      16. mysql_fetch_fields
      17. mysql_fetch_lengths
      18. mysql_fetch_row
      19. mysql_field_seek
      20. mysql_field_tell
      21. mysql_free_result
      22. mysql_get_client_info
      23. mysql_get_host_info
      24. mysql_get_proto_info
      25. mysql_get_server_info
      26. mysql_info
      27. mysql_init
      28. mysql_insert_id
      29. mysql_kill
      30. mysql_list_dbs
      31. mysql_list_fields
      32. mysql_list_processes
      33. mysql_list_tables
      34. mysql_num_fields
      35. mysql_num_rows
      36. mysql_ping
      37. mysql_query
      38. mysql_real_connect
      39. mysql_real_query
      40. mysql_reload
      41. mysql_row_tell
      42. mysql_select_db
      43. mysql_shutdown
      44. mysql_stat
      45. mysql_store_result
      46. mysql_thread_id
      47. mysql_use_result
      48. mSQL C API
      49. msqlConnect
      50. msqlSelectDB
      51. msqlQuery
      52. msqlStoreResult
      53. msqlFreeResult
      54. msqlFetchRow
      55. msqlDataSeek
      56. msqlNumRows
      57. msqlFetchField
      58. msqlFieldSeek
      59. msqlNumFields
      60. msqlClose
      61. msqlListDBs
      62. msqlListTables
      63. msqlListFields
      64. msqlListIndex

    6. Chapter 20 Python Reference

      1. Module: MySQL
      2. Module: mSQL

    7. Chapter 21 Perl Reference

      1. Installation
      2. DBI.pm API
      3. Msql.pm API
      4. Mysql.pm API

    8. Chapter 22 JDBC Reference

  1. Colophon

View Full Table of Contents
Product Details
Title:
MySQL and mSQL
By:
Tim King, George Reese, Randy Yarger
Publisher:
O'Reilly Media
Formats:
  • Print
Print Release:
July 1999
Pages:
502
Print ISBN:
978-1-56592-434-5
| ISBN 10:
1-56592-434-7
Customer Reviews
About the Authors

  1. Tim King

    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

    View Tim King's full profile page.

  2. George Reese

    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 and the strategic role of technology in business processes. He is the author of Database Programming with JDBC and Java, 2nd Edition and the world's first JDBC driver, the mSQL-JDBC driver for mSQL. He currently lives in Minneapolis, Minnesota with his wife Monique and three cats, Misty, Gypsy, and Tia. He makes a living as the National Practice Director of Technology Strategy for digital@jwt in Minneapolis.

    View George Reese's full profile page.

Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animals featured on the cover of MySQL and mSQL are kingfishers. This type of bird can be found all over the world, including North America, Europe, Africa, and New Zealand, with the greatest numbers being found in southeast Asia. There are over 80 species of kingfishers, which range in size from five to eighteen inches and which cover a broad spectrum of color. These typically long-billed birds pair for life and are considered to be very territorial. Their nests are long and tunnel-shaped, and are often found in exposed tree roots or water banks.

Most kingfishers live along the banks of rivers or lakes, as the primary staple of their diet is fish. To catch its prey, a kingfisher will perch on a branch above water, watch for a fish, hover for a moment, and then dive headfirst into the water, grabbing the fish in its beak, and heading back up to the surface. The process takes about a third of a second. The kingfisher's diet also consists of spiders, insects, and small amphibians. Jeffrey Liggett was the production editor for MySQL and mSQL. Robert Romano and Rhon Porter created the illustrations using Adobe Photoshop 5.0 and Macromedia Freehand 8.0. Mike Sierra provided FrameMaker technical support. Claire Cloutier LeBlanc provided quality control. Editorial and production services were provided by Rashelle Perez and David Leiser at Electro-Publishing. Becky Peveler was the copyeditor. The index was written by Electro-Publishing, with assistance from Seth Maislin.

Edie Freedman designed the cover of this book, using a 19th-century engraving from the Dover Pictorial Archive. The cover layout was produced by Kathleen Wilson with QuarkXPress 3.32 using the ITC Garamond font. Whenever possible, our books use RepKover, a durable and flexible lay-flat binding. If the page count exceeds RepKover's limit, perfect binding is used. The inside layout was designed by Alicia Cech based on a series design by Nancy Priest. The layout was implemented in FrameMaker 5.5.6 by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book. This colophon was written by Nicole Arigo.

  • Book cover of MySQL and mSQL
Got a Question?
icons
Favicon Service and support by Satisfaction