31 Index des commandes, types et fonctions SQL

• A
• &
• • <<
• -
• • -password option
• <
• • my_init()
  • mysql_affected_rows()
  • mysql_autocommit() .
  • mysql_change_user()
  • mysql_character_set_name()
  • mysql_close()
  • mysql_commit() .
  • mysql_connect()
  • 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_fetch_field()
  • mysql_fetch_field_direct()
  • mysql_fetch_fields()
  • mysql_fetch_lengths()
  • mysql_fetch_row()
  • mysql_field_count()
  • mysql_field_count()
  • mysql_field_seek()
  • mysql_field_tell()
  • mysql_free_result()
  • mysql_get_client_info()
  • mysql_get_client_version()
  • mysql_get_host_info()
  • mysql_get_proto_info()
  • mysql_get_server_info()
  • mysql_get_server_version()
  • mysql_info()
  • mysql_init()
  • mysql_insert_id()
  • mysql_kill()
  • mysql_list_dbs()
  • mysql_list_fields()
  • mysql_list_processes()
  • mysql_list_tables()
  • mysql_more_results() .
  • mysql_next_result() .
  • mysql_num_rows()
  • mysql_options()
  • mysql_ping()
  • mysql_query()
  • mysql_real_connect()
  • mysql_real_escape_string()
  • mysql_real_query()
  • mysql_reload()
  • mysql_rollback() .
  • mysql_row_seek()
  • mysql_row_tell()
  • mysql_select_db()
  • mysql_server_end()
  • mysql_server_init()
  • mysql_set_sever_option()
  • mysql_shutdown()
  • mysql_sqlstate()
  • mysql_ssl_set()
  • mysql_stat()
  • mysql_stmt_affected_rows()
  • mysql_stmt_attr_get()
  • mysql_stmt_attr_set()
  • mysql_stmt_bind_param()
  • mysql_stmt_bind_result()
  • mysql_stmt_close()
  • mysql_stmt_data_seek()
  • mysql_stmt_errno()
  • mysql_stmt_error() .
  • mysql_stmt_execute()
  • mysql_stmt_fetch()
  • mysql_stmt_fetch_column()
  • mysql_stmt_free_result()
  • mysql_stmt_init()
  • mysql_stmt_insert_id()
  • mysql_stmt_num_rows()
  • mysql_stmt_param_count()
  • mysql_stmt_param_metadata()
  • mysql_stmt_prepare()
  • mysql_stmt_reset()
  • mysql_stmt_result_metadata .
  • mysql_stmt_row_seek()
  • mysql_stmt_row_tell()
  • mysql_stmt_send_long_data() .
  • mysql_stmt_sqlstate()
  • mysql_stmt_store_result()
  • mysql_store_result()
  • mysql_thread_end()
  • mysql_thread_id()
  • mysql_thread_init()
  • mysql_thread_safe()
  • mysql_use_result()
  • mysql_warning_count() .
• A
• • alter database
  • alter function
  • analyze table
  • asbinary()
• B
• • backup table
  • bdmpolyfromtext()
  • bdmpolyfromwkb()
  • bit_count()
• C
• • cache index
  • call
  • case
  • case
  • casts
  • change master to
  • check table
  • checksum table
  • close
  • command-line options
  • comment syntax
  • configure option, --with-extra-charsets
  • constraints
  • convert
  • convexhull()
  • create database
  • create function
  • create index
  • create table
• D
• • date
  • dbi->quote
  • declare
  • delayed
  • delete
  • describe
  • describe
  • distinct
  • distinct
  • division (/)
  • do
  • drop database
  • drop function
  • drop index
  • drop table
  • drop user
  • dumpfile
• E
• • end
• F
• • false
  • fetch
  • flush
  • functions, user-defined
• G
• • geometrycollection()
  • geometryn()
  • grant statemenet
• H
• • handler
• I
• • if
  • ignore key
  • insert
  • insert ... select
  • interval()
  • is null, and indexes
  • isclosed()
  • isolation level
  • issimple()
  • iterate
• K
• • kill
• L
• • last_insert_id()
  • leave
  • left join
  • limit
  • load data from master
  • load data infile
  • load table from master
  • loop
• M
• • master_pos_wait()
  • match ... against()
  • mbrtouches()
  • mysql_info()
  • mysql_info()
  • mysql_info()
• N
• • null
• O
• • open
  • optimize table
  • or
• P
• • parentheses ( and )
  • password()
  • password()
  • pointonsurface()
  • pointonsurface()
  • processlist
  • purge master logs
• R
• • ref_or_null
  • related()
  • rename table
  • repair table
  • replace
  • require grant option
  • reset master
  • reset slave
  • restore table
  • rollback
  • rollback to savepoint
  • rollup
• S
• • select into
  • select into table
  • select speed
  • select, optimising
  • set
  • set global sql_slave_skip_counter
  • set option
  • set password
  • set password statement
  • set sql_log_bin
  • sha()
  • show binlog events
  • show columns
  • show create function
  • show create table
  • show databases
  • show errors
  • show function status
  • show grants
  • show keys
  • show master logs
  • show master status
  • show privileges
  • show slave hosts
  • show slave status
  • show table types
  • show table types
  • show tables
  • show warnings
  • sql_no_cache
  • start slave
  • startpoint()
  • statements, insert
  • stop slave
  • strcmp()
• T
• • table scan
  • table_cache
  • trace dbi method
  • truncate
  • truncate()
• U
• • uncompressed_length()
  • union
  • union
  • unlock tables
  • until
  • upper()
  • use
• V
• • variance()
  • version()
• W
• • where
  • while
• X
• • xor, logical
• Y
• • y()
  • year()