Flylib.com
MySQL Phrasebook
MySQL Phrasebook
ISBN: 0672328399
EAN: 2147483647
Year: 2003
Pages: 130
Authors:
Zak Greant
,
Chris Newman
BUY ON AMAZON
MySQL Phrasebook: Essential Code and Commands
Table of Contents
Copyright
About the Authors
Acknowledgments
We Want to Hear from You
Introduction
Omissions: What This Book Doesn t Cover
Conventions Used in This Book
The MySQL Phrasebook Website
Chapter 1. Maps of MySQL
The MySQL RDBMS
The LAMP Platform
MySQL Table Terminology
Sample Tables
Chapter 2. Creating and Managing Databases, Tables, and Indexes
Quick Guide: Databases, Tables, Columns, and Indexes
Creating and Managing Databases
Creating and Managing Tables
Creating and Managing Columns
Creating and Managing Indexes
See Also
Chapter 3. Storing Data
Adding Data to a Table
Adding Many Rows in One Query Using INSERT
Assigning Unique Row Numbers with auto_increment
Inserting the Current Date and Time (Using a MySQL Function)
Loading SQL Commands from a File
Inserting Data from Another Table
Importing Data from Text Files
Inserting Data Rapidly
See Also
Chapter 4. Retrieving Data: Simple Queries
Limiting the Number of Rows Returned
Sorting Result Sets
Ignoring Duplicate Rows
Finding Text That Matches a Pattern
Finding the Smallest, Largest, or Average Value in a Column
Date and Time Manipulation
Storing Exact Floating Point Numbers
Dealing with NULL
Sending Query Results to a File
Writing a BLOB to a File
Chapter 5. Manipulating Data
Safety Tips
Testing Queries Inside of a Transaction
An Overview of Updating Column Values
Updating Columns with Formulas
Deleting Rows
Deleting Rows from Multiple Tables
Addred See Also
Chapter 6. User Management and Security
Creating Users
Deleting Users
Renaming a User
Using Wildcards
Finding Users of a Given Database or Table
Setting Passwords
Tailoring User Permissions
Allowing Other Users to Grant Privileges
Viewing a User s Privileges
Removing User Access
Disabling Network Access
Disabling User Authentication
Using SSL-Secured Connection
Addred See Also
Chapter 7. The mysql Command-line Client
Connecting to a MySQL Server
Using the Client in Batch Mode
Basic mysql Command-line Client Navigation
Erasing the Current Line or Query
Setting Connection Defaults with an Option File
Getting Help Within mysql
Editing Complex Commands with a Text Editor
Database, Table, and Column Name Completion
Using the Command-line History
Other Useful Tools
Chapter 8. MySQL APIs
The C Language API
The Perl API
The PHP API
See Also
Chapter 9. Advanced Queries
Joins
Subqueries
Combining Queries with UNION
Addred See Also
Chapter 10. Troubleshooting and Emergencies
Backing Up
Restoring from a Backup
Corrupted Table Data
Server Crash
Common Errors
Getting Help
Appendix A. A Brief MySQL Tutorial
Getting Started
Creating a Database
Creating Tables
Populating Tables with Data
Exploring Table Creation
Adding Indexes to Existing Tables
Finding Information About Tables
Creating Users
Summary
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
MySQL Phrasebook
ISBN: 0672328399
EAN: 2147483647
Year: 2003
Pages: 130
Authors:
Zak Greant
,
Chris Newman
BUY ON AMAZON
Cisco Voice Gateways and Gatekeepers
Case Study: Introduction
Implementing H.323 Gateways
Case Study: Add an E1 R2 Connection to the Leeds Gateway
Review Questions
Cisco Multiservice IP-to-IP Gateway
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The AJAX Revolution
The AJAX Control Toolkit
Built-in Application Services
Remote Method Calls with ASP.NET AJAX
Building AJAX Applications with ASP.NET
Ruby Cookbook (Cookbooks (OReilly))
Taking Logarithms
Freezing an Object to Prevent Changes
Converting HTML Documents from the Web into Text
Redirecting to a Different Location
Extending Ruby with Other Languages
Microsoft WSH and VBScript Programming for the Absolute Beginner
Getting Started with the WSH and VBScript
Overview of the Windows Script Host
Constants, Variables, and Arrays
Processing Collections of Data
Using Procedures to Organize Scripts
Web Systems Design and Online Consumer Behavior
Chapter III Two Models of Online Patronage: Why Do Consumers Shop on the Internet?
Chapter IV How Consumers Think About Interactive Aspects of Web Advertising
Chapter VIII Personalization Systems and Their Deployment as Web Site Interface Design Decisions
Chapter XII Web Design and E-Commerce
Chapter XVIII Web Systems Design, Litigation, and Online Consumer Behavior
Java Concurrency in Practice
A (Very) Brief History of Concurrency
Sharing Objects
Extending ThreadPoolExecutor
Anatomy of a Synchronizer
Appendix A. Annotations for Concurrency
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