Index for mysql Documentation
Documentation Version: 0.75
mysql Version: 3.20.11
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
mysql
mysqladmin
mysqld
mysqldump
mysqlshow
msql2mysql
isamchk
Table Details
replace
Chapter 3 (SQL)
Overview
ALTER TABLE
CREATE (Tables)
Data Types
Keys
BLOBs
Binary data in BLOBS
CREATE INDEX
DELETE
DESCRIBE
DROP
DROP INDEX
SELECT
Functions
Overview
Logic Functions
+,-,*,/
%
|, &
-
= <> <= < >= >
()
BETWEEN
FIELD
IF
IFNULL
ISNULL
NOT/!
OR/AND
SIGN
expr LIKE expr
expr NOT LIKE expr
expr REGEXP expr
expr REGEXP expr
expr NOT REGEXP expr
Math Functions
ABS
BIT_COUNT
CEILING
EXP
FLOOR
FORMAT
LOG
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
WEEKDAY
GROUP Functions
AVG
SUM
COUNT
MIN
MAX
Joins
Aliases
INSERT
LOAD DATA INFILE
UPDATE
SHOW
Strings
Numbers
Chapter 4 (C API, Incomplete)
Overview
Data Functions
mysql_num_rows
mysql_num_fields
mysql_affected_rows
mysql_insert_id
mysql_field_seek
mysql_error
mysql_eof
Functions
mysql_connect
mysql_close
mysql_select_db
mysql_query
mysql_create_db
mysql_drop_db
mysql_shutdown
mysql_reload
mysql_stat
mysql_get_server_info
mysql_get_host_info
mysql_get_proto_info
mysql_list_dbs
mysql_list_tables
mysql_list_fields
mysql_list_processes
mysql_store_result
mysql_use_result
mysql_free_result
mysql_data_seek
mysql_fetch_row
mysql_fetch_field
Chapter 5 (mysql PERL API)
mysql Perl Interface
Chapter 6 (Administration)
Granting access to a Database
Tuning for best performance
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)