Flylib.com
MySQL, Second Edition
MySQL, Second Edition
ISBN: 0321375734
EAN: 2147483647
Year: 2006
Pages: 162
Authors:
Larry Ullman
BUY ON AMAZON
Visual Quickstart Guide MySQL, Second Edition
Table of Contents
Copyright
A lifetime supply of thanks to:
Chapter I. Introduction
What Is MySQL?
MySQL Versions
Primary MySQL Resources
Technical Requirements
About This Book
Is This Book for You?
Companion Web Site
Questions, Comments, or Suggestions?
Chapter 1. Installing MySQL
General Installation Steps
Installing MySQL on Windows
Configuring MySQL on Windows
Installing MySQL on Macintosh
Installing MySQL on Linux
Basic Configuration Options
Upgrading MySQL
Chapter 2. Running MySQL
Running MySQL on Windows and Windows NT
Running MySQL on Mac OS X
Running MySQL on Linux and Unix
Using Mysqladmin
Setting the Root User Password
Using the Mysql Client
Users and Privileges
Chapter 3. Database Design
Normalization
Understanding Keys
Understanding Relationships
First Normal Form
Second Normal Form
Third Normal Form
Chapter 4. Creating a MySQL Database
MySQL Data Types
Extra Column Characteristics
Introduction to Indexes
Finalizing a Table s Design
Choosing a Storage Engine
Character Sets and Collations
Creating Databases
Creating Tables
Modifying Tables
Chapter 5. Basic SQL
Using Values in Queries
Inserting Data
Selecting Data
Using Conditionals
Using LIKE and NOT LIKE
Performing Joins
Sorting Query Results
Limiting Query Results
Updating Data
Deleting Data
Chapter 6. MySQL Functions
Text Functions
Concatenation and Aliases
Numeric Functions
Chapter 7. MySQL and PHP
Connecting to MySQL and Selecting a Database
Executing Simple Queries
Retrieving Query Results
Using mysqli_insert_id()
Error Handling
Security Considerations
Chapter 8. MySQL and Perl
Installing Perl with MySQL Support on Windows
Installing Perl Support for MySQL on Unix and Mac OS X
Testing Perl and MySQL
Connecting to MySQL
Retrieving Query Results
Executing Simple Queries
Retrieving the Insert ID
Error Handling
Security Considerations
Using Prepared Statements
Chapter 9. MySQL and Java
Installing Java Support for MySQL
Connecting to the Database
Executing Simple Queries
Retrieving Query Results
Retrieving the Insert ID
Using Prepared Statements
Chapter 10. Advanced SQL and MySQL
Performing Transactions
Full-Text Searching
Regular Expressions
User-Defined Variables
Introducing Unions
Chapter 11. MySQL 5 Features
Stored Routines
Using OUT Parameters
Triggers
Views
Chapter 12. Techniques for Programming
Storing and Retrieving Binary Data
Making Query Result Pages
Using Transactions with Perl
Chapter 13. MySQL Administration
The MySQL Administrator
Backing Up Databases
Importing Data
MySQL Logging
Database Maintenance
Improving Performance
Using Batch Files
Appendix A. Troubleshooting
Installation
Starting MySQL
Accessing MySQL
mysql.sock Problems
Queries That Return Strange Results
Authentication Protocol Problems
Resetting the Root Password
Appendix B. SQL and MySQL References
Basic SQL
ALTER Commands
SQL Clauses
MySQL Privileges
MySQL Data Types
MySQL Functions
Other References
Appendix C. Resources
MySQL-Specific
Third-Party MySQL Applications
SQL
PHP
Perl
Java
Other
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
MySQL, Second Edition
ISBN: 0321375734
EAN: 2147483647
Year: 2006
Pages: 162
Authors:
Larry Ullman
BUY ON AMAZON
Inside Network Security Assessment: Guarding Your IT Infrastructure
The Goals and Objectives of a Risk Assessment
Best Practices for Quantitative and Qualitative Risk Assessment
Reducing the Risk of an Attack
Tools Used for Assessments and Evaluations
Document Tracking Form
Visual C# 2005 How to Program (2nd Edition)
Char Methods
Serialization
Introduction
Web Controls
.NET Remoting
Cisco Voice Gateways and Gatekeepers
Case Study: Implementing a Cisco Voice Gateway at the Shanghai Office
POTS-to-POTS Call Routing Considerations
Sample Applications
Multiple Gatekeeper Configurations
Review Questions
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter One Solutions
Chapter Two Principles
Chapter Six Defining Pain or Critical Business Issue
Chapter Seven Diagnose Before You Prescribe
Chapter Sixteen Creating and Sustaining High-Performance Sales Cultures
The Java Tutorial: A Short Course on the Basics, 4th Edition
Creating Classes
Example Three: CelsiusConverter
Overview of Applets
Taking Advantage of the Applet API
Algorithms
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
How this book is organized
Notification and eventing
Service-orientation and the enterprise
Service-Oriented Analysis (Part I: Introduction)
Benefits of a business-centric SOA
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies