aboutsummaryrefslogtreecommitdiffstats
path: root/English.lproj/english_help/topics/reference.html
diff options
context:
space:
mode:
Diffstat (limited to 'English.lproj/english_help/topics/reference.html')
-rwxr-xr-xEnglish.lproj/english_help/topics/reference.html212
1 files changed, 0 insertions, 212 deletions
diff --git a/English.lproj/english_help/topics/reference.html b/English.lproj/english_help/topics/reference.html
deleted file mode 100755
index b746bed9..00000000
--- a/English.lproj/english_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">
-&nbsp;<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>&nbsp; ! - 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> &amp;&amp; - 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