MySQL Reference Manual for version 3.23.15-alpha. - SQL command, type and function index Go to the first, previous, next, last section, table of contents. SQL command, type and function index ! (logical NOT) != (not equal) " % (modulo) % (wildcard character) & (bitwise AND) && (logical AND) () (parentheses) * (multiplication) + (addition) - (subtraction) - (unary minus) .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file, .my.cnf file .mysql_history file .pid (process ID) file / (division) /etc/passwd, /etc/passwd < (less than) << (left shift) <= (less than or equal) <=> (Equal to) <> (not equal) = (equal) > (greater than) >= (greater than or equal) >> (right shift) \" (double quote) \' (single quote) \0 (ASCII 0) \\ (escape) \b (backspace) \n (newline) \r (carriage return) \t (tab) _ (wildcard character) ` A ABS() ACOS() ADDDATE() addition (+) alias ALTER TABLE AND, bitwise AND, logical Arithmetic functions ASCII() ASIN() ATAN() ATAN2() AUTO_INCREMENT, using with DBI AVG() B backspace (\b) BENCHMARK() BETWEEN ... AND BIGINT BIN() BINARY Bit functions BIT_AND() BIT_COUNT() BIT_OR() BLOB, BLOB C carriage return (\r) CASE Casts CC environment variable, CC environment variable, CC environment variable CCX environment variable CEILING() CFLAGS environment variable, CFLAGS environment variable CHAR, CHAR CHAR VARYING CHAR() CHAR_LENGTH() CHARACTER CHARACTER VARYING CHARACTER_LENGTH() CHECK TABLE ChopBlanks DBI method COALESCE() Comment syntax Comparison operators CONCAT() CONCAT_WS() connect() DBI method CONNECT_ID() Control flow functions CONV() COS() COT() COUNT() COUNT(DISTINCT) CREATE DATABASE CREATE FUNCTION CREATE INDEX CREATE TABLE CROSS JOIN CURDATE() CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURTIME() CXX environment variable, CXX environment variable, CXX environment variable, CXX environment variable CXXFLAGS environment variable, CXXFLAGS environment variable, CXXFLAGS environment variable D data_sources() DBI method DATABASE() DATE, DATE Date and time functions DATE_ADD() DATE_FORMAT() DATE_SUB() DATETIME, DATETIME DAYNAME() DAYOFMONTH() DAYOFWEEK() DAYOFYEAR() DBI->connect() DBI->data_sources() DBI->disconnect DBI->do() DBI->execute DBI->fetchall_arrayref DBI->fetchrow_array DBI->fetchrow_arrayref DBI->fetchrow_hashref DBI->finish DBI->prepare() DBI->quote DBI->quote() DBI->rows DBI->trace, DBI->trace DBI->{ChopBlanks} DBI->{insertid} DBI->{is_blob} DBI->{is_key} DBI->{is_not_null} DBI->{is_num} DBI->{is_pri_key} DBI->{length} DBI->{max_length} DBI->{NAME} DBI->{NULLABLE} DBI->{NUM_OF_FIELDS} DBI->{table} DBI->{type} DBI_TRACE environment variable, DBI_TRACE environment variable, DBI_TRACE environment variable DBI_USER environment variable DECIMAL DECODE() DEGREES() DELAYED DELETE DESC DESCRIBE disconnect DBI method DISTINCT, DISTINCT division (/) do() DBI method DOUBLE DOUBLE PRECISION double quote (\") DROP DATABASE DROP FUNCTION DROP INDEX DROP TABLE DUMPFILE E ELT() ENCODE() ENCRYPT() ENUM, ENUM Environment variable, CC, Environment variable, CC, Environment variable, CC Environment variable, CCX Environment variable, CFLAGS, Environment variable, CFLAGS Environment variable, CXX, Environment variable, CXX, Environment variable, CXX Environment variable, CXXFLAGS, Environment variable, CXXFLAGS, Environment variable, CXXFLAGS Environment variable, DBI_TRACE, Environment variable, DBI_TRACE, Environment variable, DBI_TRACE Environment variable, DBI_USER Environment variable, HOME, Environment variable, HOME Environment variable, LD_RUN_PATH, Environment variable, LD_RUN_PATH, Environment variable, LD_RUN_PATH, Environment variable, LD_RUN_PATH Environment variable, MYSQL_DEBUG, Environment variable, MYSQL_DEBUG, Environment variable, MYSQL_DEBUG Environment variable, MYSQL_HISTFILE, Environment variable, MYSQL_HISTFILE Environment variable, MYSQL_HOST, Environment variable, MYSQL_HOST Environment variable, MYSQL_PWD, Environment variable, MYSQL_PWD, Environment variable, MYSQL_PWD Environment variable, MYSQL_TCP_PORT, Environment variable, MYSQL_TCP_PORT, Environment variable, MYSQL_TCP_PORT, Environment variable, MYSQL_TCP_PORT Environment variable, MYSQL_UNIX_PORT, Environment variable, MYSQL_UNIX_PORT, Environment variable, MYSQL_UNIX_PORT, Environment variable, MYSQL_UNIX_PORT, Environment variable, MYSQL_UNIX_PORT Environment variable, PATH, Environment variable, PATH Environment variable, TMPDIR, Environment variable, TMPDIR Environment variable, TZ, Environment variable, TZ Environment variable, UMASK, Environment variable, UMASK Environment variable, UMASK_DIR, Environment variable, UMASK_DIR Environment variable, USER, Environment variable, USER Environment variables, CXX equal (=) escape (\\) execute DBI method EXP() EXPLAIN EXPORT_SET() EXTRACT(type FROM date) F fetchall_arrayref DBI method fetchrow_array DBI method fetchrow_arrayref DBI method fetchrow_hashref DBI method FIELD() FILE FIND_IN_SET() finish DBI method FLOAT, FLOAT FLOAT(M,D) FLOAT(precision), FLOAT(precision) FLOOR() FLUSH FORMAT() FROM_DAYS() FROM_UNIXTIME(), FROM_UNIXTIME() Functions, arithmetic Functions, bit Functions, control flow Functions, date and time Functions, GROUP BY Functions, logical Functions, mathematical Functions, miscellaneous Functions, string Functions, string comparison Functions, user-defined G GET_LOCK() GRANT greater than (>) greater than or equal (>=) GREATEST() GROUP BY functions H HEX() Hexadecimal values HOME environment variable, HOME environment variable host.frm, problems finding HOUR() I IF() IFNULL() IN INNER JOIN INSERT INSERT DELAYED INSERT() insertid DBI method INSTR() INT INTEGER INTERVAL() IS NOT NULL IS NULL IS NULL, and indexes is_blob DBI method is_key DBI method is_not_null DBI method is_num DBI method is_pri_key DBI method ISNULL() J JOIN K KILL L LAST_INSERT_ID() LAST_INSERT_ID([expr]) LCASE() LD_RUN_PATH environment variable, LD_RUN_PATH environment variable, LD_RUN_PATH environment variable, LD_RUN_PATH environment variable LEAST() LEFT JOIN LEFT OUTER JOIN LEFT() length DBI method LENGTH() less than (<) less than or equal (<=) LIKE LIKE, and indexes LIKE, and wildcards LOAD DATA INFILE, LOAD DATA INFILE LOCATE(), LOCATE() LOCK TABLES LOG() LOG10() Logical functions LONGBLOB LONGTEXT LOWER() LPAD() LTRIM() M MAKE_SET() Mathematical functions MAX() max_length DBI method MD5() MEDIUMBLOB MEDIUMINT MEDIUMTEXT MID() MIN() minus, unary (-) MINUTE() Miscellaneous functions MOD() modulo (%) MONTH() MONTHNAME() multiplication (*) my_ulonglong C type my_ulonglong values, printing MYSQL C type mysql_affected_rows() mysql_change_user() mysql_close() mysql_connect() mysql_create_db() mysql_data_seek() MYSQL_DEBUG environment variable, MYSQL_DEBUG environment variable, MYSQL_DEBUG environment variable mysql_debug() mysql_drop_db() mysql_dump_debug_info() mysql_eof() mysql_errno() mysql_error() mysql_escape_string() mysql_escape_string() mysql_fetch_field() mysql_fetch_field_direct() mysql_fetch_fields() mysql_fetch_lengths() mysql_fetch_row() MYSQL_FIELD C type mysql_field_count(), mysql_field_count() MYSQL_FIELD_OFFSET C type mysql_field_seek() mysql_field_tell() mysql_free_result() mysql_get_client_info() mysql_get_host_info() mysql_get_proto_info() mysql_get_server_info() MYSQL_HISTFILE environment variable, MYSQL_HISTFILE environment variable MYSQL_HOST environment variable, MYSQL_HOST environment variable mysql_info(), mysql_info(), mysql_info(), mysql_info() mysql_info() mysql_init() mysql_insert_id() mysql_insert_id() mysql_kill() mysql_list_dbs() mysql_list_fields() mysql_list_processes() mysql_list_tables() mysql_num_fields() mysql_num_rows() mysql_options() mysql_ping() MYSQL_PWD environment variable, MYSQL_PWD environment variable, MYSQL_PWD environment variable mysql_query() mysql_real_connect() mysql_real_escape_string() mysql_real_query() mysql_reload() MYSQL_RES C type MYSQL_ROW C type mysql_row_seek() mysql_row_tell() mysql_select_db() mysql_shutdown() mysql_stat() mysql_store_result() MYSQL_TCP_PORT environment variable, MYSQL_TCP_PORT environment variable, MYSQL_TCP_PORT environment variable, MYSQL_TCP_PORT environment variable mysql_thread_id() MYSQL_UNIX_PORT environment variable, MYSQL_UNIX_PORT environment variable, MYSQL_UNIX_PORT environment variable, MYSQL_UNIX_PORT environment variable, MYSQL_UNIX_PORT environment variable mysql_use_result() N NAME DBI method NATIONAL CHAR NATURAL LEFT JOIN NATURAL LEFT OUTER JOIN NCHAR newline (\n) not equal (!=) not equal (<>) NOT IN NOT LIKE NOT REGEXP NOT, logical NOW() NUL NULL NULL value NULLABLE DBI method NULLIF() NUM_OF_FIELDS DBI method NUMERIC O OCT() OCTET_LENGTH() OPTIMIZE TABLE OR, bitwise OR, logical ORD() P parentheses ( and ) PASSWORD(), PASSWORD(), PASSWORD(), PASSWORD() PATH environment variable, PATH environment variable PERIOD_ADD() PERIOD_DIFF() PI() POSITION() POW() POWER() prepare() DBI method PROCESSLIST Q QUARTER() quote() DBI method Quoting of identifiers R RADIANS() RAND() REAL REGEXP RELEASE_LOCK() REPAIR TABLE REPEAT() REPLACE REPLACE() return (\r) REVERSE() REVOKE RIGHT() RLIKE ROUND(), ROUND() rows DBI method RPAD() RTRIM() S SEC_TO_TIME() SECOND() SELECT SELECT, optimizing SESSION_USER() SET, SET SET OPTION SHOW COLUMNS SHOW DATABASES SHOW FIELDS SHOW GRANTS SHOW INDEX SHOW KEYS SHOW PROCESSLIST SHOW STATUS SHOW TABLE STATUS SHOW TABLES SHOW VARIABLES SIGN() SIN() single quote (\') SMALLINT SOUNDEX() SPACE() SQRT() STD() STDDEV() STRAIGHT_JOIN STRCMP() String comparison functions String functions SUBDATE() SUBSTRING(), SUBSTRING() SUBSTRING_INDEX() subtraction (-) SUM() SYSDATE() SYSTEM_USER() T tab (\t) table DBI method table_cache TAN() TEXT, TEXT Threads TIME, TIME TIME_FORMAT() TIME_TO_SEC() TIMESTAMP, TIMESTAMP TINYBLOB TINYINT TINYTEXT TMPDIR environment variable, TMPDIR environment variable TO_DAYS() trace DBI method, trace DBI method TRIM() TRUNCATE() type DBI method Types TZ environment variable, TZ environment variable U UCASE() UDF functions ulimit UMASK environment variable, UMASK environment variable UMASK_DIR environment variable, UMASK_DIR environment variable unary minus (-) UNION UNIX_TIMESTAMP() UNLOCK TABLES UPDATE UPPER() USE USER environment variable, USER environment variable USER() User-defined functions V VARCHAR, VARCHAR VERSION() W WEEK() WEEKDAY() Wildcard character (%) Wildcard character (_) Y YEAR, YEAR YEAR() | (bitwise OR) || (logical OR) ~ Go to the first, previous, next, last section, table of contents.