Flylib.com
MYSQL in a Nutshell (In a Nutshell (OReilly))
MYSQL in a Nutshell (In a Nutshell (OReilly))
ISBN: 0596514336
EAN: 2147483647
Year: 2006
Pages: 134
Authors:
Russell Dyer
BUY ON AMAZON
MySQL in a Nutshell
Table of Contents
Dedication
Copyright
Preface
The Purpose of This Book
How This Book Is Organized
Conventions Used in This Book
Using Code Examples
Request for Comments
Safari Enabled
Acknowledgments
Chapter 1. Introduction to MySQL
1.1. The Value of MySQL
1.2. The MySQL Package
1.3. Licensing
1.4. Mailing Lists
1.5. Books and Other Publications
Chapter 2. Installing MySQL
2.1. Choosing a Distribution
2.2. Unix Source Distributions
2.3. Unix Binary Distributions
2.4. Linux RPM Distributions
2.5. Macintosh OS X Distributions
2.6. Novell NetWare Distributions
2.7. Windows Distributions
2.8. Postinstallation
Chapter 3. MySQL Basics
3.1. The mysql Client
3.2. Creating a Database and Tables
3.3. Show Me
3.4. Inserting Data
3.5. Selecting Data
3.6. Ordering, Limiting, and Grouping
3.7. Analyzing and Manipulating Data
3.8. Changing Data
3.9. Deleting Data
3.10. Searching Data
3.11. Importing Data in Bulk
3.12. Command-Line Interface
3.13. Conclusion
Chapter 4. SQL Statements
4.1. Statements Grouped by Type
4.2. Statements and Clauses in Alphabetical Order
Chapter 5. String Functions
5.1. String Functions Grouped by Type
5.2. String Functions in Alphabetical Order
Chapter 6. Date and Time Functions
6.1. Date and Time Functions Grouped by Type
6.2. Date and Time Functions in Alphabetical Order
Chapter 7. Mathematical and Aggregate Functions
7.1. Functions in Alphabetical Order
Chapter 8. Flow Control Functions
8.1. Functions in Alphabetical Order
Chapter 9. Miscellaneous Functions
9.1. Functions in Alphabetical Order
Chapter 10. MySQL Server and Client
mysql
mysqld
mysqld_multi
mysqld_safe
Chapter 11. Command-Line Utilities
comp_err
isamchk
make_binary_distribution
msql2mysql
my_print_defaults
myisamchk
myisamlog
myisampack
mysqlaccess
mysqladmin
mysqlbinlog
mysqlbug
mysqlcheck
mysqldump
mysqldumpslow
mysqlhotcopy
mysqlimport
mysqlshow
perror
Chapter 12. Perl API
12.1. Using Perl DBI with MySQL
12.2. Perl DBI Method and Function Reference
12.3. Attributes for Handles
Chapter 13. PHP API
13.1. Using PHP with MySQL
13.2. PHP MySQL Functions in Alphabetical Order
Chapter 14. C API
14.1. Using C with MySQL
14.2. Functions in Alphabetical Order
14.3. C API Datatypes
Appendix A. Datatypes
A.1. Numeric Datatypes
A.2. Accurate Numeric Types
A.3. Approximate Numeric Datatypes
A.4. Date and Time Datatypes
A.5. String Datatypes
Appendix B. Operators
B.1. Arithmetic Operators
B.2. Relational Operators
B.3. Logical Operators
B.4. Bitwise Operators
Appendix C. Environment Variables
Colophon
Index
index_SYMBOL
index_A
index_B
index_C
index_D
index_E
index_F
index_G
index_H
index_I
index_J
index_K
index_L
index_M
index_N
index_O
index_P
index_Q
index_R
index_S
index_T
index_U
index_V
index_W
index_X
index_Y
index_Z
MYSQL in a Nutshell (In a Nutshell (OReilly))
ISBN: 0596514336
EAN: 2147483647
Year: 2006
Pages: 134
Authors:
Russell Dyer
BUY ON AMAZON
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
Object Types, Predicates, and Basic Constraints
Mapping ORM Models to Logical Database Models
Generating a Physical Database Schema
Logical Database Model Reports
Other Features and Best Practices
Java I/O
Line Breaks
Thread Safety
Performance
Validation
Parsing Input
Project Management JumpStart
Assessing Risk
Budgeting 101
Closing the Books
Appendix A Answers to Review Questions
Appendix C Sample Project Management Checklists
SQL Tips & Techniques (Miscellaneous)
Understanding SQL Basics and Creating Database Files
Working with Queries, Expressions, and Aggregate Functions
Performing Multiple-table Queries and Creating SQL Data Views
Understanding Triggers
Working with Stored Procedures
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 24. Discover Networks with NetStumbler
Hack 46. Proxy Web Traffic over SSH
Hack 50. Interrogate the Network
Hacks 6382: Introduction
Hack 78. Advertise Bonjour Services in Linux
Programming .Net Windows Applications
Windows Forms and the .NET Framework
Apply Button
Text
ADO.NET
Bugs
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