MySQL User Guide Part VII Appendixes
[edit] Part VII. Appendixes
[edit] Appendix A. Date Format Specifiers Table
[edit] Appendix B. Functions and Operators Tables *Complete*
This appendix contains a listing of all the MySQL functions and operators.
| Name | Description |
|---|---|
| Return the absolute value | |
| Return the arc cosine | |
|
| Add dates |
|
| Add time |
| Decrypt using AES | |
| Encrypt using AES | |
| Logical AND | |
| Return numeric value of left-most character | |
| Return the arc sine | |
| Return the arc tangent of the two arguments | |
| Return the arc tangent | |
| Return the average value of the argument | |
| Repeatedly execute an expression | |
| Check whether a value is within a range of values | |
| Return a string representation of the argument | |
| Cast a string to a binary string | |
| Return bitwise and | |
| Return the number of bits that are set | |
| Return length of argument in bits | |
| Return bitwise or | |
|
| Return bitwise xor |
| Bitwise AND | |
| Invert bits | |
| Bitwise OR | |
| Bitwise XOR | |
| Case operator | |
| Cast a value as a certain type | |
| Return the smallest integer value not less than the argument | |
| Return the smallest integer value not less than the argument | |
| Return number of characters in argument | |
| Return the character for each integer passed | |
| A synonym for CHAR_LENGTH() | |
|
| Return the character set of the argument |
| Return the first non-NULL argument | |
|
| Return the collation coercibility value of the string argument |
|
| Return the collation of the string argument |
|
| Return result as a binary string |
| Return concatenate with separator | |
| Return concatenated string | |
| Return the connection ID (thread ID) for the connection | |
| Convert numbers between different number bases | |
|
| Convert from one timezone to another |
| Cast a value as a certain type | |
| Return the cosine | |
| Return the cotangent | |
| Return the count of a number of different values | |
| Return a count of the number of rows returned | |
|
| Compute a cyclic redundancy check value |
| Return the current date | |
| Synonyms for CURDATE() | |
| Synonyms for CURTIME() | |
| Synonyms for NOW() | |
| Return the username and hostname combination | |
| Return the current time | |
| Return the default (current) database name | |
| Add two dates | |
| Format date as specified | |
| Subtract two dates | |
|
| Extract the date part of a date or datetime expression |
|
| Subtract two dates |
|
| Synonym for DAYOFMONTH() |
|
| Return the name of the weekday |
| Return the day of the month (1-31) | |
| Return the weekday index of the argument | |
| Return the day of the year (1-366) | |
| Decodes a string encrypted using ENCODE() | |
| Return the default value for a table column | |
| Convert radians to degrees | |
| Decrypt a string | |
| Encrypt a string | |
|
| Integer division |
| Division operator | |
| Return string at index number | |
| Encode a string | |
| Encrypt a string | |
| NULL-safe equal to operator | |
| Equal operator | |
| Raise to the power of | |
| Return a string such that for every bit set in the value bits, you get an on string and for every unset bit, you get an off string | |
| Extract part of a date | |
|
| Extracts a value from an XML string using XPath notation |
| Return the index (position) of the first argument in the subsequent arguments | |
| Return the index position of the first argument within the second argument | |
| Return the largest integer value not greater than the argument | |
| Return a number formatted to specified number of decimal places | |
| For a SELECT with a LIMIT clause, the number of rows that would be returned were there no LIMIT clause | |
| Convert a day number to a date | |
| Format date as a UNIX timestamp | |
|
| Return a date format string |
| Get a named lock | |
| Greater than or equal operator | |
| Greater than operator | |
| Return the largest argument | |
|
| Return a concatenated string |
| Return a hexadecimal representation of a decimal or string value | |
| Extract the hour | |
| If/else construct | |
| Null if/else construct | |
| Check whether a value is within a set of values | |
| Return the numeric value of an IP address | |
| Return the IP address from a numeric value | |
| Insert a substring at the specified position up to the specified number of characters | |
| Return the index of the first occurrence of substring | |
| Return the index of the argument that is less than the first argument | |
| Checks whether the named lock is free | |
| NOT NULL value test | |
| Test a value against a boolean | |
| NULL value test | |
|
| Checks whether the named lock is in use. Return connection identifier if true. |
| Test a value against a boolean | |
| Test whether the argument is NULL | |
|
| Return the last day of the month for the argument |
| Value of the AUTOINCREMENT column for the last INSERT | |
| Synonym for LOWER() | |
| Return the smallest argument | |
| Left shift | |
| Return the leftmost number of characters as specified | |
| Return the length of a string in bytes | |
| Less than or equal operator | |
| Less than operator | |
| Simple pattern matching | |
| Return the natural logarithm of the argument | |
| Load the named file | |
| Synonym for NOW() | |
|
| Synonym for NOW() |
| Return the position of the first occurrence of substring | |
| Return the base-10 logarithm of the argument | |
| Return the base-2 logarithm of the argument | |
| Return the natural logarithm of the first argument | |
| Return the argument in lowercase | |
| Return the string argument, left-padded with the specified string | |
| Remove leading spaces | |
| Return a set of comma-separated strings that have the corresponding bit in bits set | |
|
| Create a date from the year and day of year |
|
| MAKETIME() |
| Block until the slave has read and applied all updates up to the specified position | |
| Perform full-text search | |
| Return the maximum value | |
| Calculate MD5 checksum | |
|
| Return the microseconds from argument |
| Return a substring starting from the specified position | |
| Return the minimum value | |
| Minus operator | |
| Return the minute from the argument | |
| Return the remainder | |
| Modulo operator | |
| Return the month from the date passed | |
|
| Return the name of the month |
|
| Causes the column to have the given name |
| Check whether a value is not within a range of values | |
| Not equal operator | |
| Check whether a value is not within a set of values | |
| Negation of simple pattern matching | |
| Negation of REGEXP | |
| Negates value | |
| Return the current date and time | |
| Return NULL if expr1 = expr2 | |
| Return an octal representation of a decimal number | |
| A synonym for LENGTH() | |
|
| Return the value of the old (pre-4.1) implementation of PASSWORD |
| Logical OR | |
| If the leftmost character of the argument is a multi-byte character, returns the code for that character | |
| Calculate and return a password string | |
| Add a period to a year-month | |
| Return the number of months between periods | |
| Return the value of pi | |
| Addition operator | |
| A synonym for LOCATE() | |
| Return the argument raised to the specified power | |
| Return the argument raised to the specified power | |
| Analyze the results of a query | |
| Return the quarter from a date argument | |
| Escape the argument for use in an SQL statement | |
| Return argument converted to radians | |
| Return a random floating-point value | |
| Pattern matching using regular expressions | |
| Releases the named lock | |
| Repeat a string the specified number of times | |
| Replace occurrences of a specified string | |
| Reverse the characters in a string | |
| Right shift | |
| Return the specified rightmost number of characters | |
| Synonym for REGEXP | |
| Round the argument | |
|
| The number of rows updated |
| Append string the specified number of times | |
| Remove trailing spaces | |
|
| A synonym for DATABASE() |
| Converts seconds to 'HH:MM:SS' format | |
| Return the second (0-59) | |
| Synonym for USER() | |
| Calculate an SHA-1 160-bit checksum | |
| Return the sign of the argument | |
| Return the sine of the argument | |
|
| Sleep for a number of seconds |
| Return a soundex string | |
|
| Compare sounds |
| Return a string of the specified number of spaces | |
| Return the square root of the argument | |
| Return the population standard deviation | |
|
| Return the population standard deviation |
|
| Return the sample standard deviation |
| Return the population standard deviation | |
|
| Convert a string to a date |
| Compare two strings | |
| When invoked with three arguments a synonym for DATE_SUB() | |
| Return the substring as specified | |
| Return a substring from a string before the specified number of occurrences of the delimiter | |
| Return the substring as specified | |
|
| Subtract times |
| Return the sum | |
| Return the time at which the function executes | |
| Synonym for USER() | |
| Return the tangent of the argument | |
| Format as time | |
| Return the argument converted to seconds | |
|
| Extract the time portion of the expression passed |
|
| Subtract time |
| Times operator | |
|
| With a single argument, this function returns the date or datetime expression. With two arguments, the sum of the arguments |
|
| Add an interval to a datetime expression |
|
| Subtract an interval from a datetime expression |
| Return the date argument converted to days | |
| Remove leading and trailing spaces | |
| Truncate to specified number of decimal places | |
| Synonym for UPPER() | |
| Change the sign of the argument | |
|
| Uncompress a string compressed |
|
| Return the length of a string before compression |
|
| Convert each pair of hexadecimal digits to a character |
| Return a UNIX timestamp | |
|
| Return replaced XML fragment |
| Convert to uppercase | |
| Return the current username and hostname | |
|
| Return the current UTC date |
|
| Return the current UTC time |
|
| Return the current UTC date and time |
|
| Return a Universal Unique Identifier (UUID) |
|
| Defines the values to be used during an INSERT |
|
| Return the population standard variance |
|
| Return the sample variance |
|
| Return the population standard variance |
| Returns a string that indicates the MySQL server version | |
| Return the week number | |
| Return the weekday index | |
|
| Return the calendar week of the date (1-53) |
| Logical XOR | |
| Return the year | |
| Return the year and week |
[edit] Appendix C. Options Tables *Complete*
This appendix contains listings of options for the most-used MySQL programs. These tables contain brief descriptions along with hyperlinks to the manual. Where applicable, listings of commands are also supplied.
[edit] C.1. mysql Options *Complete*
Table C.1. mysql Option Reference
| Format | Config File | Description | Introduced |
|---|---|---|---|
| Enable automatic rehashing | |||
| Don't use history file | |||
| --bind-address=host_name | Determine which client network interface (IP address or hostname) to use when connecting to the MySQL Server | 5.1.22-ndb-6.3.4 | |
| Set the default character set | |||
| Write column names in results | |||
| Display result set metadata | 5.1.14 | ||
| Whether to retain or strip comments in statements sent to the server | 5.1.23 | ||
| Compress all information sent between the client and the server | |||
| The number of seconds before connection timeout | |||
| The database to use | |||
| Write a debugging log | |||
| Print debugging information when the program exits | 5.1.21 | ||
| Print debugging information, memory and CPU statistics when the program exits | |||
| Use charset_name as the default character set | |||
| Set the statement delimiter | |||
| Execute the statement and quit | |||
| Continue even if an SQL error occurs | |||
| Display help message and exit | |||
| Connect to the MySQL server on the given host | |||
| Produce HTML output | |||
| Ignore spaces after function names | |||
| Write line numbers for errors | |||
| Enable or disable for LOCAL capability for LOAD DATA INFILE | |||
| The maximum packet length to send to or receive from the server | |||
| The automatic limit for rows in a join when using --safe-updates | |||
| Enable named mysql commands | |||
| --net_buffer_length=value | net_buffer_length | The buffer size for TCP/IP and socket communication | |
| Disable automatic rehashing | |||
| Do not beep when errors occur | |||
| Disable named mysql commands | |||
| Deprecated form of --skip-pager | |||
| Do not copy output to a file | |||
| Ignore statements except those for the default database named on the command line | |||
| Use the given command for paging query output | |||
| The password to use when connecting to the server | |||
| The TCP/IP port number to use for the connection | |||
| Set the prompt to the specified format | |||
| The connection protocol to use | |||
| Do not cache each query result | |||
| Write column values without escape conversion | |||
| If the connection to the server is lost, automatically try to reconnect | |||
| Allow only UPDATE and DELETE statements that specify key values | |||
| --secure-auth | secure-auth | Do not send passwords to the server in old (pre-4.1.1) format | |
| The automatic limit for SELECT statements when using --safe-updates | |||
| Show warnings after each statement if there are any | |||
| Ignore SIGINT signals (typically the result of typing Control-C) | |||
| Silent mode | |||
| --skip-auto-rehash | skip-auto-rehash | Disable automatic rehashing | |
| Do not write column names in results | |||