Home Page Icon
Home Page
Table of Contents for
8.1. Functions in Alphabetical Order
Close
8.1. Functions in Alphabetical Order
by Russell J.T. Dyer
MySQL in a Nutshell
Dedication
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
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
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
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
4. SQL Statements
4.1. Statements Grouped by Type
4.1.1. Data Manipulation
4.1.2. Database and Table Schema
4.1.3. Database and Table Properties
4.1.4. Table Administration
4.1.5. User Administration
4.1.6. Server Administration
4.1.7. Replication
4.2. Statements and Clauses in Alphabetical Order
5. String Functions
5.1. String Functions Grouped by Type
5.1.1. Converting
5.1.2. Formatting
5.1.3. Expressions
5.1.4. Extracting
5.1.5. Manipulating
5.1.6. Security
5.2. String Functions in Alphabetical Order
6. Date and Time Functions
6.1. Date and Time Functions Grouped by Type
6.2. Date and Time Functions in Alphabetical Order
7. Mathematical and Aggregate Functions
7.1. Functions in Alphabetical Order
8. Flow Control Functions
8.1. Functions in Alphabetical Order
9. Miscellaneous Functions
9.1. Functions in Alphabetical Order
10. MySQL Server and Client
mysql
mysqld
mysqld_multi
mysqld_safe
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
12. Perl API
12.1. Using Perl DBI with MySQL
12.1.1. Connecting to MySQL
12.1.2. Executing an SQL Statement
12.1.3. Capturing Data
12.1.4. Disconnecting from MySQL
12.1.5. Temporarily Storing Results
12.2. Perl DBI Method and Function Reference
12.3. Attributes for Handles
12.3.1. Attributes for All Handles
12.3.2. Attributes Only for Database Handles
12.3.3. Attributes Only for Statement Handles
12.3.4. DBI Dynamic Attributes
13. PHP API
13.1. Using PHP with MySQL
13.1.1. Connecting to MySQL
13.1.2. Querying MySQL
13.2. PHP MySQL Functions in Alphabetical Order
14. C API
14.1. Using C with MySQL
14.1.1. Connecting to MySQL
14.1.2. Querying MySQL
14.2. Functions in Alphabetical Order
14.3. C API Datatypes
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
B. Operators
B.1. Arithmetic Operators
B.2. Relational Operators
B.3. Logical Operators
B.4. Bitwise Operators
C. Environment Variables
Index
About the Author
Colophon
Copyright
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
8. Flow Control Functions
Next
Next Chapter
CASE( )
Functions in Alphabetical Order
The following are the MySQL flow control functions.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset