Flylib.com
Sams Teach Yourself MySQL in 10 Minutes
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
Year: 2006
Pages: 165
Authors:
Chris Newman
BUY ON AMAZON
Sams Teach Yourself MySQL in 10 Minutes
Table of Contents
Copyright
About the Author
Introduction
Part 1: MySQL Foundations
Lesson 1. Introducing MySQL
Database Basics
MySQL Components
Summary
Lesson 2. Using MySQL
The mysql Client
Executing SQL Statements
Creating the Sample Tables
Summary
Part 2: Getting Started with SQL
Lesson 3. Retrieving Data
The SELECT Statement
Summary
Lesson 4. Filtering and Sorting Data
The WHERE Clause
The ORDER BY Clause
Summary
Lesson 5. Advanced Data Filtering
Combining WHERE Clauses
Limiting the Number of Rows Returned
Summary
Lesson 6. Numeric Operators and Functions
Numeric Operators
Numeric Functions
Conditional Functions
Summary
Lesson 7. String Operators and Functions
Using Operators with Strings
String Functions
Summary
Lesson 8. Date Operators and Functions
Date Operators
Date Functions
Summary
Lesson 9. Summarizing Data
Aggregate Functions
Grouping Data
Filtering Summary Data
Summary
Part 3: Advance SQL
Lesson 10. Using Subqueries
Understanding Subqueries
Summary
Lesson 11. Joining Tables
Understanding Joins
Summary
Lesson 12. Creating Advanced Joins
The JOIN Keyword
Inner Joins
Joining Multiple Tables
Cross Joins
Self-Joins
Natural Joins
Outer Joins
Summary
Lesson 13. Combining Queries
Understanding Combined Queries
Other Compound Operations
Using Temporary Tables
Summary
Part 4: Creating a New Database
Lesson 14. Creating and Modifying Tables
Creating a New Database
Character Sets and Collations
Altering a Database
Dropping a Database
Managing Tables
Temporary Tables
Using a Query to Create a Table
Storage Engines
Altering Tables
Dropping Tables
Summary
Lesson 15. Working with Data
The INSERT Statement
The DELETE Statement
The UPDATE Statement
The REPLACE Statement
Loading Data from a File
Why Use Transactions?
Transactions in MySQL
Autocommit Mode
Rolling Back a Transaction
Summary
Lesson 16. Designing Your Database
Relationships
Normalization
Naming Tables and Columns
Data Types
CHAR and VARCHAR
Summary
Lesson 17. Keys and Indexes
Understanding Keys and Indexes
Using Indexes in MySQL
Summary
Lesson 18. Managing User Access
Understanding MySQL Authentication
User Management
Using Wildcards
Summary
Part 5: New Features in MySQL 5.0
Lesson 19. Views
Understanding Views
Summary
Lesson 20. Stored Routines
Understanding Stored Routines
Summary
Lesson 21. Triggers
Understanding Triggers
Using Triggers
Summary
Part 6: Interfacing with MySQL
Lesson 22. Using ODBC
Understanding ODBC
Connecting to MyODBC
Summary
Lesson 23. Using MySQL with C
The C Language API
Summary
Lesson 24. Using MySQL with PHP
Using the mysql API
Using the mysqli API
Summary
Lesson 25. Using MySQL with Perl
The Perl DBI
Using the MySQL DBD
Summary
Part 7: Appendix
Appendix A. Installing MySQL
Obtaining MySQL
LinuxUNIX Installation
Windows Installation
Appendix B. Sample Table Scripts
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
Sams Teach Yourself MySQL in 10 Minutes
ISBN: 0672328631
EAN: 2147483647
Year: 2006
Pages: 165
Authors:
Chris Newman
BUY ON AMAZON
High-Speed Signal Propagation[c] Advanced Black Magic
Differential Impedance
UTP Signal Propagation
Category-3 UTP at Elevated Temperature
Daisy-Chain Clock Distribution
Ringing in a New Era
MySQL Clustering
Installing MySQL-Max
Restarting a Cluster
Query Execution
Data Retrieval in MySQL Cluster
B Management Commands
C & Data Structures (Charles River Media Computer Engineering)
The scanf Function
Function
Strings
Files
Miscellaneous Problems
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Understanding Intrusion Detection
Crash Course in the Internet Protocol Suite
IDS and IPS Architecture
Internet Security Systems RealSecure
The Future of Intrusion Detection and Prevention
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
Working with PL/SQL
Triggers
Error Handling
Returning Values to Unix
Section B.3. Formatting Dates
GDI+ Programming with C#
Exploring GDI+ Functionality
Transforming Text
Using a Picture Box to View Images
Encoder Parameters and Image Formats
Transformation Types
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