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
The .NET Developers Guide to Directory Services Programming
Introduction to LDAP and Active Directory
Directory CRUD Operations
Working with the DirectoryContext Class
Summary
Creating Users
Image Processing with LabVIEW and IMAQ Vision
Introduction
Frame Grabbing
Spatial Image Filtering
Pixel Value Analysis
Character Recognition
Systematic Software Testing (Artech House Computer Library)
An Overview of the Testing Process
Test Execution
The Test Organization
The Software Tester
Appendix F Process Diagrams
SQL Hacks
Hack 47. Exploit an SQL Injection Vulnerability
Hack 49. Keep Track of Infrequently Changing Values
Hack 53. Clean Inconsistent Records
Hack 72. Extract a Subset of the Results
Hack 73. Mix File and Database Storage
.NET-A Complete Development Cycle
Conclusion
Initial Requirements Analysis and Design
Advanced GDI+ Operations
Design of the Optimizations
Product Release
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Strings and Regular Expressions
Arrays and Collections
XML
Multithreading
Printing and Drawing with GDI+
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