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
Adobe After Effects 7.0 Studio Techniques
Making the Most of the UI
Navigating Multiple Compositions
Tracking for Rotoscoping
Sci-Fi Weaponry
Why Doesnt This Shot Look Real?
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
IOS Images and Configuration Files
Mapping Hostnames to IP Addresses
Interface show Commands
IGRP
Specialized Networking Topics
Java How to Program (6th Edition) (How to Program (Deitel))
The Internet and the World Wide Web
for Repetition Statement
Case Study: Class GradeBook Using a Two-Dimensional Array
Terminology
G.1. Introduction
Postfix: The Definitive Guide
Additional Information and How to Obtain Postfix
Queue Tools
Email and DNS
Mailing Lists
Content-Checking
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
The Working Directory
A Lightning SQL Tutorial
Saving Your Work
Summary Reports
Scripting Issues with iSQL*Plus
Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath
Part Two. Office Programming in .NET
Working with the Windows Collections
Working with the Application Object
Form Events, Properties, and Methods
Conclusion
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