MySQL Conference
O’Reilly Media will be hosting the MySQL Conference in Santa Clara, California: April 12 - 15, 2010.
MySQueaL Resources
resources for mysql admins and developers who are squealing for help
site last updated:
03 mar. 2010 - 01:49:18 pm
879 hits past day
03 mar. 2010 - 01:49:18 pm
879 hits past day
Miscellany
MySQL Documentation - Alphabetical List
This is an somewhat alphabetical listing of my MySQL documentation, grouped first by type of command (i.e., statements, clauses, functions). This is provided as a quick way to get to the documentation page when you know which SQL statement or function you need information on.
MySQL SQL Statements
- Single Field Subqueries
- Multiple Fields Subqueries
- Results Set Subqueries
- BEGIN
- COMMIT
- HELP
- RELEASE SAVEPOINT
- ROLLBACK
- ROLLBACK TO SAVEPOINT
- SAVEPOINT
- SET TRANSACTION
- START TRANSACTION
- USE
- XA
- LOAD INDEX INTO CACHE
- CHANGE MASTER TO
- LOAD DATA FROM MASTER
- LOAD TABLE...FROM MASTER
- MASTER_POS_WAIT( )
- PURGE MASTER LOGS
- RESET MASTER
- RESET SLAVE
- SET GLOBAL SQL_SLAVE_SKIP_COUNTER
- SET SQL_LOG_BIN
- SHOW BINARY LOGS
- SHOW BINLOG EVENTS
- SHOW MASTER LOGS
- SHOW MASTER STATUS
- SHOW SLAVE HOSTS
- SHOW SLAVE STATUS
- START SLAVE
- STOP SLAVE
- INSERT
- INSERT - Single-row insertion with SET clause
- INSERT - Multiple-row insertions
- INSERT - Inserting rows based on a SELECT
- SELECT
- SELECT Statement Keywords
- SELECT - Exporting results
- SELECT - Grouping results
- SELECT - Having results
- SELECT - Ordering results
- SELECT - Limiting results
- SELECT - Other Clauses & Options
- REPLACE
- UPDATE
- DELETE
- SET
- BACKUP TABLE
- CACHE INDEX
- CHECKSUM TABLE
- KILL
- RESET
- RESTORE TABLE
- SET
- FLUSH
- LOCK TABLES
- UNLOCK TABLES
- DO
- HANDLER
- LOAD DATA INFILE
- SHOW ERRORS
- SHOW WARNINGS
- TRUNCATE
- EXPLAIN
- ANALYZE TABLE
- CHECK TABLE
- OPTIMIZE TABLE
- REPAIR TABLE
- SHOW SCHEMAS
- SHOW TABLE STATUS
- SHOW ENGINE
- SHOW ENGINES
- SHOW OPEN TABLES
- SHOW PLUGINS
- SHOW STATUS
- SHOW TABLE STATUS
- SHOW VARIABLES
- SHOW PROCESSLIST
- BEGIN...END
- CALL
- CLOSE
- DECLARE
- DELIMITER
- DROP PREPARE
- EXECUTE
- FETCH
- OPEN
- PREPARE
- CREATE DATABASE
- ALTER DATABASE
- RENAME DATABASE
- DROP DATABASE
- SHOW DATABASES
- SHOW CREATE DATABASE
- ALTER EVENT
- CREATE EVENT
- DROP EVENT
- SHOW CREATE EVENT
- SHOW EVENTS
- ALTER FUNCTION
- CREATE FUNCTION
- DROP FUNCTION
- SHOW CREATE FUNCTION
- SHOW FUNCTION CODE
- SHOW FUNCTION STATUS
- CREATE INDEX
- DROP INDEX
- SHOW INDEXES
- SHOW PRIVILEGES
- RESET
- SHOW CHARACTER SET
- SHOW COLLATION
- GRANT
- GRANT - Connection Restrictions Types
- GRANT - Time and Number of Connection Limits
- GRANT - Privileges in GRANT and REVOKE
- REVOKE
- ALTER PROCEDURE
- CREATE PROCEDURE
- DROP PROCEDURE
- SHOW CREATE PROCEDURE
- SHOW PROCEDURE CODE
- SHOW PROCEDURE STATUS
- CREATE SCHEMA
- ALTER SCHEMA
- CREATE SERVER
- CREATE SERVER
- ALTER SERVER
- DROP SERVER
- CREATE TABLE
- CREATE TABLE - Column flags
- CREATE TABLE - Index and key definitions
- CREATE TABLE - References
- CREATE TABLE - Sub-Partition definitions
- CREATE TABLE - Based on an existing table
- CREATE TABLE - Partition definitions
- CREATE TABLE - Partitioning
- CREATE TABLE - Table options
- ALTER TABLE
- ALTER TABLE - ADD clauses for columns
- ALTER TABLE - ADD clause for standard indexes
- ALTER TABLE - ADD clause for FULLTEXT indexes
- ALTER TABLE - ADD clause for SPATIAL indexes
- ALTER TABLE - ADD clauses for foreign keys
- ALTER TABLE - CHANGE clauses
- ALTER TABLE - DROP column clause
- ALTER TABLE - DROP index clauses
- ALTER TABLE - Miscellaneous clauses
- ALTER TABLE - Partition altering clauses
- ALTER TABLE - Partition administration clauses
- ALTER TABLE - Table options
- RENAME TABLE
- DROP TABLE
- SHOW TABLES
- SHOW CREATE TABLE
- DESCRIBE
- SHOW COLUMNS
- ALTER TRIGGER
- CREATE TRIGGER
- DROP TRIGGER
- SHOW TRIGGERS
- CREATE USER
- RENAME USER
- DROP USER
- SET PASSWORD
- SHOW GRANTS
- CREATE VIEW
- ALTER VIEW
- DROP VIEW
- SHOW VIEWS
- SHOW CREATE VIEW
MySQL Clauses
MySQL Functions
- ANALYSE( )
- BENCHMARK( )
- DATABASE( )
- FOUND_ROWS( )
- LAST_INSERT_ID( )
- ROW_COUNT( )
- UUID ( )
- VERSION( )
- AVG( )
- BIT_AND( )
- BIT_OR( )
- BIT_XOR( )
- COUNT( )
- GROUP_CONCAT( )
- MAX( )
- MIN( )
- STD( )
- STDDEV( )
- STDDEV_POP( )
- STDDEV_SAMP( )
- SUM( )
- VAR_POP( )
- VAR_SAMP( )
- VARIANCE( )
- ASCII( )
- BIN( )
- BINARY
- BIT_LENGTH( )
- CAST( )
- CHAR( )
- CHAR_LENGTH( )
- CHARACTER_LENGTH( )
- CHARSET( )
- COALESCE( )
- COERCIBILITY( )
- COLLATION( )
- COMPRESS( )
- CONCAT( )
- CONVERT( )
- CRC32( )
- ELT( )
- EXPORT_SET( )
- FIELD( )
- FIND_IN_SET( )
- HEX( )
- INSERT( )
- INSTR( )
- INTERVAL( )
- LCASE( )
- LEFT( )
- LENGTH( )
- LOAD_FILE( )
- LOCATE( )
- LOWER( )
- LPAD( )
- LTRIM( )
- MAKE_SET()
- MATCH ( ) AGAINST( )
- MID()
- OCTET_LENGTH( )
- ORD( )
- POSITION( )
- QUOTE( )
- REPEAT( )
- REPLACE( )
- REVERSE( )
- RIGHT( )
- RPAD( )
- RTRIM( )
- SOUNDEX( )
- SPACE( )
- STRCMP( )
- SUBSTR( )
- SUBSTRING( )
- SUBSTRING_INDEX( )
- TRIM( )
- UCASE( )
- UNCOMPRESS( )
- UNCOMPRESSED_LENGTH( )
- UNHEX( )
- UPPER( )
- ADDDATE( )
- ADDTIME( )
- CONVERT_TZ( )
- CURDATE()
- CURRENT_DATE( )
- CURRENT_TIME( )
- CURRENT_TIMESTAMP()
- CURTIME()
- DATE( )
- DATE_ADD( )
- DATE_FORMAT( )
- DATE_SUB( )
- DATEDIFF( )
- DAY( )
- DAYNAME( )
- DAYOFMONTH( )
- DAYOFWEEK( )
- DAYOFYEAR( )
- EXTRACT( )
- FROM_DAYS( )
- FROM_UNIXTIME( )
- GET_FORMAT( )
- HOUR( )
- LAST_DAY( )
- LOCALTIME( )
- LOCALTIMESTAMP( )
- MAKEDATE( )
- MAKETIME( )
- MICROSECOND( )
- MINUTE( )
- MONTH( )
- MONTHNAME( )
- NOW( )
- PERIOD_ADD( )
- PERIOD_DIFF( )
- QUARTER( )
- SEC_TO_TIME( )
- SECOND( )
- SLEEP( )
- STR_TO_DATE( )
- SUBDATE( )
- SUBTIME( )
- SYSDATE( )
- TIME( )
- TIME_FORMAT( )
- TIME_TO_SEC( )
- TIMEDIFF( )
- TIMESTAMP( )
- TIMESTAMPADD( )
- TIMESTAMPDIFF( )
- TO_DAYS( )
- UNIX_TIMESTAMP( )
- UTC_DATE( )
- UTC_TIME( )
- UTC_TIMESTAMP( )
- WEEK( )
- WEEKDAY( )
- WEEKOFYEAR( )
- YEAR( )
- YEARWEEK( )
- ABS( )
- ACOS( )
- ASIN( )
- COT( )
- CONV( )
- COS( )
- CEILING( )
- CEIL( )
- BIT_COUNT( )
- ACOS( )
- ASIN( )
- ATAN( )
- ATAN2( )
- DEGREES( )
- EXP( )
- FLOOR( )
- FORMAT( )
- GREATEST( )
- INET_ATON( )
- INET_NTOA( )
- LEAST( )
- LN( )
- LOG( )
- LOG2( )
- LOG10( )
- MOD( )
- OCT( )
- PI( )
- POW( )
- POWER( )
- RADIANS( )
- RAND( )
- ROUND( )
- SIGN( )
- SIN( )
- SQRT( )
- TAN( )
- TRUNCATE( )
- IF( )
- CASE
- IFNULL( )
- ISNULL( )
- NULLIF( )
- PASSWORD( )
- OLD_PASSWORD( )
- AES_DECRYPT( )
- AES_ENCRYPT( )
- CURRENT_USER( )
- DECODE( )
- DES_DECRYPT( )
- DES_ENCRYPT( )
- ENCODE( )
- ENCRYPT( )
- MD5( )
- SHA( )
- SHA( )
- SESSION_USER( )
- SYSTEM_USER( )
- USER( )
- SCHEMA( )
- CONNECTION_ID( )
- GET_LOCK( )
- IS_FREE_LOCK( )
- IS_USED_LOCK( )
- RELEASE_LOCK( )
C API
- Connection Functions
- Fetch Functions
- mysql_fetch_field( )
- mysql_fetch_field_direct( )
- mysql_fetch_fields( )
- mysql_fetch_row( )
- mysql_fetch_lengths( )
- mysql_query( )
- Information Functions
- mysql_get_client_version( )
- mysql_get_host_info( )
- mysql_get_server_info( )
- mysql_info( )
- mysql_insert_id( )
- Miscellaneous Functions
- mysql_autocommit( )
- mysql_change_user( )
- mysql_character_set_name( )
- mysql_commit( )
- mysql_create_db( )
- mysql_data_seek( )
- mysql_debug( )
- mysql_drop_db( )
- mysql_dump_debug_info( )
- mysql_eof( )
- mysql_errno( )
- mysql_error( )
- mysql_escape_string( )
- mysql_field_count( )
- mysql_field_seek( )
- mysql_field_tell( )
- mysql_free_result( )
- mysql_get_client_info( )
- mysql_get_character_set_info( )
- mysql_get_proto_info( )
- mysql_get_server_version( )
- mysql_get_ssl_cipher( )
- mysql_hex_string( )
- mysql_init( )
- mysql_kill( )
- mysql_library_end( )
- mysql_library_init( )
- mysql_list_dbs( )
- mysql_list_fields( )
- mysql_list_processes( )
- mysql_list_tables( )
- mysql_more_results( )
- mysql_next_result( )
- mysql_num_fields( )
- mysql_num_rows( )
- mysql_ping( )
- mysql_real_escape_string( )
- mysql_real_query( )
- mysql_reload( )
- mysql_refresh( )
- mysql_rollback( )
- mysql_row_seek( )
- mysql_row_tell( )
- mysql_select_db( )
- mysql_set_character_set( )
- mysql_set_local_infile_default( )
- mysql_set_local_infile_handler( )
- mysql_set_server_option( )
- mysql_shutdown( )
- mysql_sqlstate( )
- mysql_ssl_set( )
- mysql_stat( )
- mysql_store_result( )
- mysql_thread_end( )
- mysql_thread_id( )
- mysql_thread_init( )
- mysql_thread_safe( )
- mysql_use_result( )
- mysql_warning_count( )
Perl DBI
- Connection Functions
- Information Functions
- column_info( )
- foreign_key_info( )
- get_info( )
- primary_key_info( )
- private_attribute_info( )
- statistics_info( )
- table_info( )
- type_info( )
- type_info_all( )
- Fetch Functions
- execute( )
- fetch( )
- fetchall_arrayref( )
- fetchall_hashref( )
- fetchrow_array( )
- fetchrow_arrayref( )
- fetchrow_hashref( )
- selectall_arrayref( )
- selectall_hashref( )
- selectcol_arrayref( )
- selectrow_array( )
- selectrow_arrayref( )
- selectrow_hashref( )
- Bind Functions
- Miscellaneous DBI Functions
- can( )
- available_drivers( )
- begin_work( )
- clone( )
- commit( )
- data_diff( )
- data_sources( )
- data_string_desc( )
- data_string_diff( )
- do( )
- dump_results( )
- err( )
- errstr( )
- execute_array( )
- execute_for_fetch( )
- finish( )
- func( )
- installed_drivers( )
- installed_versions( )
- last_insert_id( )
- looks_like_number( )
- neat( )
- neat_list( )
- parse_dsn( )
- parse_trace_flag( )
- parse_trace_flags( )
- ping( )
- prepare( )
- primary_key( )
- quote( )
- quote_identifier( )
- rollback( )
- rows( )
- set_err( )
- state( )
- swap_inner_handle( )
- tables( )
- take_imp_data( )
- trace( )
- trace_msg( )
PHP API
- Connection Functions
- Data Retrieval Functions
- mysql_fetch_array( )
- mysql_fetch_assoc( )
- mysql_fetch_field( )
- mysql_fetch_lengths( )
- mysql_fetch_object( )
- mysql_fetch_row( )
- mysql_query( )
- mysql_result( )
- mysql_unbuffered_query( )
- Information Functions
- mysql_get_host_info( )
- mysql_get_proto_info( )
- mysql_get_server_info( )
- mysql_info( )
- mysql_tablename( )
- Miscellaneous Functions
- mysql_affected_rows( )
- mysql_client_encoding( )
- mysql_create_db( )
- mysql_data_seek( )
- mysql_db_name( )
- mysql_db_query( )
- mysql_drop_db( )
- mysql_errno( )
- mysql_error( )
- mysql_escape_string( )
- mysql_field_flags( )
- mysql_field_len( )
- mysql_field_name( )
- mysql_field_seek( )
- mysql_field_table( )
- mysql_field_type( )
- mysql_free_result( )
- mysql_get_client_info( )
- mysql_insert_id( )
- mysql_list_dbs( )
- mysql_list_fields( )
- mysql_list_processes( )
- mysql_list_tables( )
- mysql_num_fields( )
- mysql_num_rows( )
- mysql_ping( )
- mysql_real_escape_string( )
- mysql_select_db( )
- mysql_set_charset( )
- mysql_stat( )
book recommendation
MySQL in a Nutshell
If you work with MySQL regularly and need a book on the topic with an easy to follow writing style and helpful examples, please consider buying MySQL in a Nutshell. If you already have the first edition, the second edition recently came out: it’s much better than the first edition and has had some great reviews. Click on the cover art work here and you’ll be taken to Amazon’s site where you can purchase a copy and have it mailed to you.
Copyright 2009 MySQueaL Resources. All Rights Reserved.
