did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9781565924345

Mysql and Msql

by ; ;
  • ISBN13:

    9781565924345

  • ISBN10:

    1565924347

  • Format: Paperback
  • Copyright: 1999-07-01
  • Publisher: Oreilly & Associates Inc
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $34.95

Summary

MySQL and mSQL are popular and robust database products that support key subsets of SQL on both Linux and Unix systems. Both products are free for nonprofit use and cost a small amount for commercial use.Even a small organization or web site has uses for a database. Perhaps you keep track of all your customers and find that your information is outgrowing the crude, flat-file format you started with. Or you want to ask your web site's visitors for their interests and preferences and put up a fresh web page that tallies the results.Unlike commercial databases, MySQL and mSQL are affordable and easy to use. If you know basic C, Java, Perl, or Python, you can quickly write a program to interact with your database. In addition, you can embed queries and updates right in an HTML file so that a web page becomes its own interface to the database.This book is all you need to make use of MySQL or mSQL. It takes you through the whole process from installation and configuration to programming interfaces and basic administration. Includes reference chapters and ample tutorial material.Topics include:Introductions to simple database design and SQLBuilding, installation, and configurationBasic programming APIs for C, C++, Java (JDBC), Perl, and PythonCGI programming with databases in C and PerlWeb interfaces: PHP, W3-mSQL, Lite, and mSQLPerl

Author Biography

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

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.

Table of Contents

Preface ix
I Getting Started with MySQL and mSQL 1(120)
Introduction to Relational Databases
3(10)
What Is a Database?
4(1)
What Is a Relational Database?
5(1)
Applications and Databases
6(1)
MySQL and mSQL
7(6)
Database Design
13(17)
Database Design
13(3)
Normalization
16(9)
A Logical Data Modeling Methodology
25(1)
Physical Database Design
26(4)
Installation
30(9)
MySQL
30(7)
mSQL
37(2)
MySQL
39(29)
Design
39(2)
Installing MySQL
41(1)
Running MySQL
41(1)
Database Administration
42(16)
MySQL Utilities
58(4)
Performance Tuning
62(6)
mSQL
68(22)
Design
68(2)
mSQL Versions
70(2)
Installing mSQL
72(1)
Running mSQL
73(4)
Database Administration
77(7)
mSQL Utilities
84(6)
SQL According to MySQL and mSQL
90(23)
SQL Basics
90(3)
Creating and Dropping Tables
93(1)
SQL Datatypes
94(6)
Indices
100(1)
Sequences and Auto-Incrementing
101(2)
Managing Data
103(2)
Queries
105(4)
Extended Functionality
109(4)
Other Mid-Range Database Engines
113(8)
What Is ``Free''?
113(1)
What MySQL and mSQL Lack
114(3)
PostgreSQL
117(1)
GNU SQL
118(1)
Beagle
119(1)
Making Comparisons
119(2)
II Database Programming 121(108)
Database Application Architectures
123(7)
The Client/Server Architecture
123(1)
Data Processing
124(1)
Object/Relational Modeling
125(2)
The Three-tier Architecture
127(3)
CGI Programming
130(24)
What Is CGI?
130(1)
HTML Forms
131(5)
The CGI Specification
136(7)
Important Considerations for CGI Scripts
143(9)
CGI and Databases
152(2)
Perl
154(27)
DBI
154(7)
An Example DBI Application
161(4)
Msql.pm
165(9)
MysqlPerl
174(7)
Python
181(6)
Basic Connectivity
181(3)
Dynamic Connectivity
184(3)
PHP and Other Support for Database-driven HTML
187(10)
Alternatives for Dynamic Content on the Web
187(2)
W3-mSQL
189(4)
PHP
193(2)
Embedded Perl
195(2)
C and C++
197(19)
The Two APIs
197(6)
Object-oriented Database Access in C++
203(13)
Java and JDBC
216(13)
What Is JDBC?
216(5)
Simple Database Access
221(3)
Dynamic Database Access
224(3)
A Guest Book Servlet
227(2)
III Reference 229(240)
SQL Reference
231(44)
MySQL SQL
231(38)
mSQL SQL
269(6)
MySQL and mSQL System Variables
275(9)
MySQL System Variables
275(5)
mSQL System Variables
280(4)
MySQL and mSQL Programs and Utilities
284(19)
MySQL Utilities
284(15)
mSQL Utilities
299(4)
PHP and Lite Reference
303(42)
PHP
303(31)
Lite
334(11)
C Reference
345(23)
MySQL C API
345(16)
mSQL C API
361(7)
Python Reference
368(7)
Module: MySQL
368(4)
Module: mSQL
372(3)
Perl Reference
375(41)
Installation
375(2)
DBI.pm API
377(19)
Msql.pm API
396(16)
Mysql.pm API
412(4)
JDBC Reference
416(53)
Index 469

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program