diff options
Diffstat (limited to 'Resources/Help/topics/reference.html')
| -rwxr-xr-x | Resources/Help/topics/reference.html | 212 |
1 files changed, 0 insertions, 212 deletions
diff --git a/Resources/Help/topics/reference.html b/Resources/Help/topics/reference.html deleted file mode 100755 index b746bed9..00000000 --- a/Resources/Help/topics/reference.html +++ /dev/null @@ -1,212 +0,0 @@ -<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 |