diff options
Diffstat (limited to 'Resources/Help/topics/reference.html')
| -rwxr-xr-x | Resources/Help/topics/reference.html | 212 |
1 files changed, 212 insertions, 0 deletions
diff --git a/Resources/Help/topics/reference.html b/Resources/Help/topics/reference.html new file mode 100755 index 00000000..b746bed9 --- /dev/null +++ b/Resources/Help/topics/reference.html @@ -0,0 +1,212 @@ +<html> +<head> +<title>Sequel Pro Help - MySQL SQL Referernce</title> +<meta name="AppleTitle" content="SQL Reference"> +<meta name="AppleFont" content="Lucida Grande"> +<meta ROBOTS="robots" CONTENT="anchors"> +</head> +<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0"> + +<font face="Lucida Grande,Geneva,Arial"> + +<br> + +<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80"> + <tr> + <td align="left" valign="top" width="70"> + <img src="sequel-pro_logo.jpg" width="60" height="60" border="0"> + </td> + <td align="left"><h1>MySQL SQL Reference</h1> + </td> + </tr> + <tr> + <td colspan="2"> + <img src="bar.gif" width="100%" height="20"> + </td> + </tr> +</table> + +<br> +<font size="-1"> + <a href="../index.html">Back to the main menu</a> +<br> +<br> +<table border="0" width="95%"> + <tr> + <td> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + In the following commands and functions, any italicized text should be replaced by a variable + or name of your choice. Any text within brackets ( [ and ] ) is optional. This is only a short reference + of the SQL commands supported in MySQL. It is NOT the full list and also may not be complete + nor up-to-date. + </font> + </td> + </tr> +</table> + +<br> +<table border="0" cellpadding="5" cellspacing="2" width="100%"> + <tr> + <td width="60%" valign="top"> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + <b>Commands</b> + <br> + CREATE DATABASE [IF NOT EXISTS] <i>name</i> + <br> + CREATE [UNIQUE|FULLTEXT] INDEX <i>name</i> ON <i>table</i> (<i>column</i>,..) + <br> + CREATE TABLE [IF NOT EXISTS] <i>name</i> + <br> + DELETE FROM <i>table</i> [WHERE <i>clause</i>] [LIMIT <i>n</i>] + <br> + DROP DATABASE [IF EXISTS] <i>name</i> + <br> + DROP TABLE [IF EXISTS] <i>name</i> + <br> + GRANT <i>privilege</i> ON <i>table</i> TO <i>user</i> + <br> + INSERT [INTO] <i>table</i> [ (column, ...) ] VALUES (values, ...) + <br> + LOAD DATA INFILE <i>file</i> INTO TABLE <i>name</i> + <br> + SELECT [DISTINCT|ALL| |] FROM <i>table</i> [WHERE <i>clause</i> ] + <br> + UPDATE <i>table</i> SET <i>column=value,...</i> [WHERE <i>clause</i>] [LIMIT <i>n</i>] + <br> + <br> + <b>Logical Operators</b> + <br> + NOT <i>or</i> ! - performs a logical not + <br> + OR <i>or</i> | | - performs a logical or + <br> + XOR - performs a logical exclusive or + <br> + AND <i>or</i> && - performs a logical and + </font> + </td> + <td width="40%" valign="top"> + <font face="Lucida Grande,Geneva,Arial" size="-1"> + <b>Aggregate Functions</b> + <br> + AVG(<i>expression</i>) + <br> + BIT_AND(<i>expression</i>) + <br> + BIT_OR(<i>expression</i>) + <br> + COUNT(<i>expression</i>) + <br> + MAX(<i>expression</i>) + <br> + MIN(<i>expression</i>) + <br> + STD(<i>expression</i>)/STDDEV(<i>expression</i>) + <br> + SUM(<i>expression</i>) + <br> + <br> + <b>General Functions</b> + <br> + ABS(<i>number</i>) + <br> + ACOS(<i>number</i>) + <br> + ADDDATE(<i>date</i>, INTERVAL, <i>amount</i>, <i>type</i>) + <br> + ASCII(<i>char</i>) + <br> + ASIN(<i>number</i>) + <br> + ATAN(<i>number</i>) + <br> + ATAN2(x, y) + <br> + BENCHMARK(<i>num</i>, <i>function</i>) + <br> + BIN((<i>decimal</i>) + <br> + BIT_COUNT(<i>number</i>) + <br> + BIT_LENGTH(<i>number</i>) + <br> + CEILING(<i>number</i>) + <br> + CHAR_LENGTH(<i>string</i>) + <br> + COS(<i>radians</i>) + <br> + COT(<i>radians</i>) + <br> + CURDATE() + <br> + CURTIME() + <br> + DATABASE() + <br> + DATE_FORMAT(<i>date</i>, <i>format</i>) + <br> + DAYNAME(<i>date</i>) + <br> + DAYOFMONTH(<i>date</i>) + <br> + DAYOFWEEK(<i>date</i>) + <br> + DAYOFYEAR(<i>date</i>) + <br> + EXP(<i>power</i>) + <br> + FLOOR(<i>number</i>) + <br> + FORMAT(<i>number</i>, <i>decimals</i>) + <br> + HOUR(<i>time</i>) + <br> + LENGTH(<i>string</i>) + <br> + LOG(<i>number</i>) + <br> + LOWER(<i>number</i>) + <br> + MD5(<i>string</i>) + <br> + MINUTE(<i>time</i>) + <br> + MONTH(<i>date</i>) + <br> + MONTHNAME(<i>date</i>) + <br> + NOW() + <br> + PASSWORD(<i>string</i>) + <br> + QUARTER(<i>date</i>) + <br> + REVERSE(<i>string</i>) + <br> + SECOND(<i>time</i>) + <br> + SIGN(<i>number</i>) + <br> + SPACE(<i>number</i>) + <br> + SQRT(<i>number</i>) + <br> + UPPER(<i>string</i>) + <br> + VERSION() + <br> + WEEK(<i>date</i>) + <br> + WEEKDAY(<i>date</i>) + <br> + YEAR(<i>date</i>) + </font> + </td> + </tr> +</table> + +</font> + +</body> +</html>
\ No newline at end of file |