Index for MySQL Documentation
Documentation Version: 0.95
MySQL Version: 3.20.29
Chapter 1 (Introduction)
About this manual
Acknowledgments
What is MySQL?
What does MySQL offer?
What is SQL?
How do I talk to MySQL?
Chapter 2 (Commands)
Overview
Core
mysql
mysqlaccess
mysqladmin
mysqld
mysqldump
mysqlshow
isamchk
isamlog
safe_mysqld
Non Core
comp_err
msql2mysql
mysqlbug
perror
replace
which1
zap
Chapter 3 (SQL)
Overview
ALTER TABLE
CREATE TABLE
Data Types
Keys
BLOBs
Binary Data In BLOBS
CREATE INDEX
DELETE
DESCRIBE
DROP
DROP INDEX
GRANT
SELECT
Functions
Overview
Logic Functions
+,-,*,/
%
|, &
-
()
BETWEEN
BIT_COUNT()
ELT
FIELD
IF
IFNULL
ISNULL
NOT/!
OR,AND
SIGN
SUM()
= <> <= < >= >
expr LIKE expr
expr NOT LIKE expr
expr REGEXP expr
expr NOT REGEXP expr
Math Functions
ABS
CEILING
EXP
FLOOR
FORMAT
LOG
LOG10
MAX
MIN
MOD
POW
ROUND
RAND
SQRT
String Functions
CONCAT
INTERVAL
(Was INTERVALL in earlier versions.)
INSERT
LCASE
LEFT
LENGTH
LOCATE
LTRIM
REPLACE
RIGHT
RTRIM
STRCMP
SUBSTRING
STRCMP
UCASE
Misc Functions
CURDATE
DATABASE
FROM_DAYS
NOW
PASSWORD
PERIOD_ADD
PERIOD_DIFF
TO_DAYS
UNIX_TIMESTAMP
USER
WEEKDAY
GROUP Functions
AVG
SUM
COUNT
MIN
MAX
Joins
Aliases
INSERT INTO
LOAD DATA INFILE
SET OPTION
UPDATE
SHOW
About Strings
About Numbers
Chapter 4 (C API)
Overview
Preparation
Client Functions
mysql_affected_rows
mysql_close
mysql_connect
mysql_create_db
mysql_data_seek
mysql_drop_db
mysql_eof
mysql_error
mysql_fetch_field
mysql_fetch_lengths
mysql_fetch_row
mysql_field_seek
mysql_free_result
mysql_get_client_info
mysql_get_host_info
mysql_get_proto_info
mysql_get_server_info
mysql_insert_id
mysql_list_dbs
mysql_list_fields
mysql_list_processes
mysql_list_tables
mysql_num_fields
mysql_num_rows
mysql_query
mysql_real_query
mysql_reload
mysql_select_db
mysql_shutdown
mysql_stat
mysql_store_result
mysql_use_result
Chapter 5 (Administration)
Granting access to a Database
How Passwords Work
Compile Time Options
Disabling Alternate User Login
Disabling Automatic Defaults
Adding Functions To MySQL
Fast Data Load
Tuning mysqld
Other Performance Hints
Query Optimization
What MySQL Version Numbers Mean
The Client/Server Protocol
Table Details
About Keys
MySQL Future Plans
Chapter 6 (MySQL PERL API)
Summary
Connect
Changing The Connect Port
SelectDB
ListFields
Query
ListDBs
ListTables
FetchCol
FetchHash
FetchRow
DataSeek
Escaping Binary Strings
No Close
Metadata
Database Handle
Statement Handle
Prerequisites
Author
Chapter 7 (MySQL DBD PERL API) (Incomplete)
MySQL DBD/DBI Perl Interface
Appendix A (MySQL license)
Appendix B (Sample Database and Tutorial, Incomplete.)
Table Definitions
Sample Data
Appendix C (The debugging library)
Appendix D (Porting mSQL code to MySQL)
Appendix E (Cool MySQL related tools/utilities)