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
ERP and Data Warehousing in Organizations: Issues and Challenges
ERP Systems Impact on Organizations
ERP System Acquisition: A Process Model and Results From an Austrian Survey
Distributed Data Warehouse for Geo-spatial Services
A Hybrid Clustering Technique to Improve Patient Data Quality
Relevance and Micro-Relevance for the Professional as Determinants of IT-Diffusion and IT-Use in Healthcare
An Introduction to Design Patterns in C++ with Qt 4
Part I: Introduction to C++ and Qt 4
The Keyword const
Introduction to MySQL
Scope and Storage Class
Section C.1. The Preprocessor: For #including Files
Twisted Network Programming Essentials
Working with Asynchronous Results
Enabling Web Services Using XML-RPC
Calling XML-RPC Functions
Accepting Mail with SMTP
Using SMTP as a User Interface
Sap Bw: a Step By Step Guide for Bw 2.0
Creating an InfoCube
InfoCube Design Alternative III Time-Dependent Entire Hierarchies
Aggregates
Creating Views in R/3
Section B.1. SAP Basis 3-Tier Architecture
VBScript in a Nutshell, 2nd Edition
What VBScript Is Used For: Gluing Together Objects
Common Problem Areas and How to Avoid Them
Section A.6. Date and Time
Section A.8. Error Handling
Section A.17. Variable Declaration
Python Standard Library (Nutshell Handbooks) with
The mailbox Module
The BaseHTTPServer Module
The imp Module
The symbol Module
Other Modules
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