MySQL

ISBN-10: 0072224770

ISBN-13: 9780072224771

Edition: 2004

Authors: Claude Seidman, Pamela Smith, Vikram Vaswani

List price: $46.00 Buy it from $1.89
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 variable alternative to commercial databases for use in banks, e-commerce, insurance and any other enterprises that need to maintain real transactional integrity. This guide aims to give developers an effective, low-cost alternative to expensive products.
New Starting from $34.01
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
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
Periodic Table Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $46.00
Copyright year: 2004
Publisher: McGraw-Hill Education
Publication date: 1/8/2004
Binding: Paperback
Pages: 544
Size: 7.25" wide x 9.00" long x 1.50" tall
Weight: 2.332
Language: English

Frederick Marryat was born on July 10, 1792 in London, England. He entered the Royal Navy at the age of 14 and served with distinction in many parts of the world before retiring in 1830 with the rank of captain. From 1832 to 1835, he edited the Metropolitan Magazine. His first novel, The Naval Officer, was published in 1829. His other adult novels include Mr. Midshipman Easy, The Kings Own, Newton Forster, Peter Simple, Jacob Faithful, and The Phantom Ship. He also wrote a number of children's books including Masterman Ready, Settlers in Canada, The Mission, The Children of the New Forest, and The Little Savages. He travelled in Canada and the United States from 1837 to 1839. Afterward, he recorded his impressions in A Diary in America. He died on August 9, 1848.Pamela Smith has worked at the Metropolitan Museum of Art's Costume Institute and is currently the curator of "Elegant Threads" exhibition at the African Art Museum of the S.M.A. Fathers.

Foreword
Acknowledgments
Introduction
Installation
Introduction to Databases
The Big Picture
...And the Little Database that Could
History and Evolution
Features
Applications
Summary
A Technical Tour of MySQL
An Overview of MySQL Architecture
Primary Subsystems
Support Components
Subsystem/Component Interaction and Control Flow
The MySQL Engine
Connectivity
SQL
Data Integrity
Transactions
Extensibility
Symmetric Multiprocessing with MySQL
Security
Replication
Application Programming Interfaces
Add-On Tools
Summary
MySQL Installation and Configuration
Obtaining MySQL
Choosing Which Version to Install
Choosing Between Binary and Source Distributions
Installing and Configuring MySQL
Installing and Configuring MySQL on UNIX
Installing and Configuring MySQL on Windows
Testing MySQL
Post-Installation Steps
Summary
Usage
SQL Basics
A Brief History of SQL
An Overview of SQL
A (My)SQL Tutorial
Understanding an RDBMS
Creating a Database
Adding Tables
Adding Records
Removing and Modifying Records
Executing Queries
Summary
MySQL Data Types
The Need and Rationale for Data Types
MySQL Data Types
Numeric Types
String Types
Date and Time Types
Complex Types
Data Type Selection
Summary
MySQL Operators
Arithmetic Operators
Comparison Operators
Logical Operators
Bit Operators
Summary
MySQL Functions
Math Functions
Aggregate Functions
String Functions
Date and Time Functions
Encryption Functions
Control Flow Functions
Formatting Functions
Type Conversion Functions
System Information Functions
Summary
Working with Databases and Tables
Creating Databases
Selecting Databases for Use
Deleting Databases
Creating Tables
Field Types
Field Constraints
Indexes
Primary Keys
Foreign Keys
Table Types
Other Table Modifiers
Copying Tables
Modifying Tables
Deleting Tables
Obtaining Information About Databases, Tables, Fields, and Indexes
Summary
Working with Data
Inserting, Updating, and Deleting Records
Inserting Records
Updating Records
Deleting Records
Retrieving Records
Retrieving Specific Rows and Columns
Using Built-In Functions
Aliasing Table and Column Names
Limiting Query Results
Sorting Query Results
Grouping Query Results
Using Variables
Using Subqueries
Controlling SELECT Behavior
Copying, Importing, and Exporting Records
Copying Records
Importing Records
Exporting Records
Summary
Joins
What Is a Join?
Types of Joins
Cross Joins
Inner Joins
Outer Joins
Self Joins
Unions
Summary
Subqueries
What Is a Subquery?
Types of Subqueries
Subqueries and the Where/Having Clause
Subqueries and the From Clause
Subqueries and Joins
Subqueries and Other DML Statements
Summary
Transactions
What Is a Transaction?
Transactions and the ACID Properties
Life Cycle of a Transaction
Controlling Transactional Behavior
Automatic Commits
Transaction Isolation Levels
Transactions and Performance
Pseudotransactions with Nontransactional Tables
Table Locks as a Substitute for Transactions
Implementing a Pseudotransaction with Table Locks
Summary
Administration
Administration and Configuration
Database Administration and MySQL
Uptime
Data Backup
Security and Access Control
Performance Optimization
Basic Server Administration and Configuration Tasks
Starting and Stopping the Server
Checking MySQL Server Status
Managing MySQL Client Processes
Altering the Server Configuration
Troubleshooting with the Error Log
Summary
Security, Access Control, and Privileges
The MySQL Grant Tables
The user Table
The db and host Tables
The tables_priv and columns_priv Tables
Granting, Revoking, and Viewing User Privileges
Using the Grant and Revoke Commands
Using the Insert, Update, and Delete Commands
Viewing Privileges
Reloading the Grant Tables
Resetting the Grant Tables
Changing User Passwords
Setting the root Password
Resetting the root Password
Summary
Maintenance, Backup, and Recovery
Maintenance
Logging
Checking and Repairing Tables
Backup and Restore
Backing Up Databases and Tables
Restoring Databases and Tables from Backup
Summary
Performance Optimization
Indexing
Query Caching
Query Analysis
Optimizing Multi-Table Queries
Using Temporary Tables
Optimizing Table Design
Adjusting Server Settings
Benchmarking
Summary
MySQL Replication
Replication Basics
The Master-Slave Relationship
Replication Threads
Configuring MySQL for Replication
Managing the Replication Process
Summary
Development
The MySQL APIs
The MySQL APIs In Context
Components of the MySQL API
Language Support
Selecting an API
Summary
MySQL and C
C
History and Evolution
Installation
MySQL and C
Connection Management
Query Execution
Result Set Processing
Error Handling
Ancillary Functions
Real-World Usage
The Interactive SQL Client
The Expense Tracker
Summary
MySQL and Perl
Perl
History and Evolution
Installation
MySQL and the Perl DBI
Connection Management
Query Execution
Result Set Processing
Error Handling
Ancillary Functions
A Real-World Example
Designing the Database
Building an Article Index
Retrieving Article Contents
Adding Comments
Building a Threaded Comment Index
Viewing Comments
Summary
MySQL and PHP
PHP: History and Evolution
Installation
MySQL and PHP
Connection Management
Query Execution
Result Set Processing
Error Handling
Ancillary Functions
A Real-World Example
Designing the Database
Retrieving Data
Adding Data
Removing Data
Summary
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.

×