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)