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
Java I/O
Versioning
Selectable Channels
The Unicode Character Set
UTF-8
Identifying Ports
Inside Network Security Assessment: Guarding Your IT Infrastructure
Risk Assessment Best Practices
Making Sure You Are Ready to Begin
Level II Assessment Forms
Appendix C. Security Assessment Sample Report
Appendix E. SIRT Team Report Format Template
A Practitioners Guide to Software Test Design
Decision Table Testing
State-Transition Testing
Domain Analysis Testing
Appendix A Brown & Donaldson Case Study
Appendix B Stateless University Registration System Case Study
Sap Bw: a Step By Step Guide for Bw 2.0
Summary
Managing User Authorization
InfoCube Design Alternative II-Dimension Characteristics
Loading Data into the InfoCube
BW Statistics
.NET-A Complete Development Cycle
References for Further Reading
Initial Requirements Analysis and Design
The Photo Editor Application
Analysis of the GDI+ Extensions Requirements
Putting It All Together
Java All-In-One Desk Reference For Dummies
Making Choices
Using the Object and Class Classes
Book IV - Strings, Arrays, and Collections
Programming Threads
Using File Streams
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