Managing and Using MySQL

ISBN-10: 0596002114
ISBN-13: 9780596002114
Edition: 2nd 2002
List price: $39.99 Buy it from $2.39
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable  More...

Used Starting from $19.63
New Starting from $30.04
eBooks Starting from $31.99
Rent
Buy
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
You could win $10,000

Get an entry for every item you buy, rent, or sell.

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Careers in Legal Assisting Online content $4.95 $1.99
Add to cart
Study Briefs
Medical Terminology Online content $4.95 $1.99
Add to cart
Study Briefs
Medical Math Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $39.99
Edition: 2nd
Copyright year: 2002
Publisher: O'Reilly Media, Incorporated
Publication date: 5/3/2002
Binding: Paperback
Pages: 430
Size: 6.75" wide x 9.50" long x 1.25" tall
Weight: 1.496
Language: English

MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout. This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions. If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls foreach language. Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.

Cara Baker, Specialist Registrar atnbsp;University College London#60;/p#62;#60;p#62;James Teo, Specialist Registrar atnbsp;University College London#60;/p#62;#60;p#62;George Reese, Specialist Registrar atnbsp;the Royal Free Hospital,nbsp;London#60;/p#62;

Tim King

Hugh E. Williams is a software design engineer at Microsoft's WindowsLive Search in Redmond, WA. Previously, he was the AssociateProfessor in Information Retrieval at RMIT University in Melbourne,Australia. He's published over 70 research papers and holds around 10patents, mostly in the search engine area. When not at work Hughlikes to hang out with his family, exercise, watch Richmond playfooty, and learn about baseball. Hugh has a PhD from RMIT University.His home page is http://hughwilliams.com .

Preface
Introduction
MySQL
Relational Databases
The History of MySQL
MySQL Design
MySQL Features
MySQL Applications
What You Get
Installation
Preparation
Unix Installation
Windows Installation
SQL According to MySQL
SQL Basics
Database Creation
Table Management
MySQL Data Types
Indexing
Managing Data
Queries
SQL Operators
Advanced Features
Database Administration
Configuration
Server Startup and Shutdown
Logging
Backup
Recovery
Table Maintenance and Crash Recovery
MySQL Administration
Performance Tuning
An Approach to Performance Tuning
Application Tuning
Database Server Tuning
Operating System/Hardware Tuning
Security
Database Security
System Security
Application Security
Database Design
Database Design Primer
Normalization
A Logical Data-Modeling Methodology
Physical Database Design
MySQL Programming
Database Applications
Architecture
Connections and Transactions
Object/Relational Modeling
Perl
Introduction to DBI
DBI and CGI
A General Model for Maintainable Perl Programs
Python
DB-API
Proprietary Operations
Applied DB-API
PHP
Introducing PHP
Installing PHP
Accessing the MySQL DBMS with PHP
Securing User Data
Managing Sessions
Writing Data with PHP
Using the HTML [left angle bracket]form[right angle bracket] Environment
Where to Find Out More
CAPI
API Overview
The C API in Practice
Advanced Issues
Java
The JDBC API
Simple Database Access
Dynamic Database Access
A Guest Book Servlet
Extending MySQL
User-Defined Functions
Alternative Character Sets
MySQL Reference
SQL Syntax for MySQL
Basic Syntax
SQL Commands
MySQL Data Types
Numeric Data Types
String Data Types
Date Data Types
Complex Data Types
Operators and Functions
Operators
Functions
MySQL PHP API Reference
Data Types
Functions
C Reference
Data types
Functions
The Python DB-API
Module: MySQLdb
Index

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×