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
WebLogic: The Definitive Guide
Getting Started with WebLogic Server
Security Configuration
Using JNDI and RMI
XML
Traps
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
Review Questions
Summary
Configuring Alarms and Traces
Alarm Overview
Snort Cookbook
Building a Distributed IDS (Encrypted)
Prioritizing Alerts
Carrying Out Statistical Analysis
Installing and Configuring ACID
Tools for Testing Signatures
MySQL Clustering
Retrieving the Latest Snapshot from BitKeeper
Upgrading MySQL Cluster
Backup and Recovery
Network Redundancy
An Overview of Binary Options
The Oracle Hackers Handbook: Hacking and Defending Oracle
The Oracle Network Architecture
Triggers
Indirect Privilege Escalation
Accessing the File System
Appendix A Default Usernames and Passwords
User Interfaces in C#: Windows Forms and Custom Controls
Classic Controls
Modern Controls
Custom Controls
GDI+ Basics
Help and Application-Embedded Support
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