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
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
Cisco IP Phones
Call Admission Control
Preventing Toll Fraud
Monitoring Performance
Building Web Applications with UML (2nd Edition)
Discussion
Discussion
Number Store Main Control Mechanism
UML to HTML
Design Model
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
Using Cell Names (Like Programming Variables)
Defining Variables
Exploring Chart Styles
Performing Statistical Tests
Introduction
C++ How to Program (5th Edition)
Introduction
Standard Library Class string
Summary
Files and Streams
J.13. More Complex XHTML Forms
Twisted Network Programming Essentials
Starting the Twisted Event Loop
Sending and Receiving Data
Providing POP3 Access to Mailboxes
Services, Processes, and Logging
Logging Events and Errors
802.11 Wireless Networks: The Definitive Guide, Second Edition
Frame Transmission and Association and Authentication States
The Original Direct Sequence PHY
Ethereal
11 Network Analysis Checklist
Improving Performance
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