From fab9a6506cd04ec8f840c98772a80c44a79c74a7 Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Wed, 10 Dec 2008 16:52:52 +0000 Subject: MERGED r262:266 from branches/stuart02 to trunk to include new project structure. --- English.lproj/english_help/topics/reference.html | 212 ----------------------- 1 file changed, 212 deletions(-) delete mode 100755 English.lproj/english_help/topics/reference.html (limited to 'English.lproj/english_help/topics/reference.html') 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 @@ - - -Sequel Pro Help - MySQL SQL Referernce - - - - - - - - -
- - - - - - - - - -
- -

MySQL SQL Reference

-
- -
- -
- - Back to the main menu -
-
- - - - -
- - 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. - -
- -
- - - - - -
- - Commands -
- CREATE DATABASE [IF NOT EXISTS] name -
- CREATE [UNIQUE|FULLTEXT] INDEX name ON table (column,..) -
- CREATE TABLE [IF NOT EXISTS] name -
- DELETE FROM table [WHERE clause] [LIMIT n] -
- DROP DATABASE [IF EXISTS] name -
- DROP TABLE [IF EXISTS] name -
- GRANT privilege ON table TO user -
- INSERT [INTO] table [ (column, ...) ] VALUES (values, ...) -
- LOAD DATA INFILE file INTO TABLE name -
- SELECT [DISTINCT|ALL| |] FROM table [WHERE clause ] -
- UPDATE table SET column=value,... [WHERE clause] [LIMIT n] -
-
- Logical Operators -
- NOT or  ! - performs a logical not -
- OR or | | - performs a logical or -
- XOR - performs a logical exclusive or -
- AND or && - performs a logical and - - 		- - Aggregate Functions -
- AVG(expression) -
- BIT_AND(expression) -
- BIT_OR(expression) -
- COUNT(expression) -
- MAX(expression) -
- MIN(expression) -
- STD(expression)/STDDEV(expression) -
- SUM(expression) -
-
- General Functions -
- ABS(number) -
- ACOS(number) -
- ADDDATE(date, INTERVAL, amount, type) -
- ASCII(char) -
- ASIN(number) -
- ATAN(number) -
- ATAN2(x, y) -
- BENCHMARK(num, function) -
- BIN((decimal) -
- BIT_COUNT(number) -
- BIT_LENGTH(number) -
- CEILING(number) -
- CHAR_LENGTH(string) -
- COS(radians) -
- COT(radians) -
- CURDATE() -
- CURTIME() -
- DATABASE() -
- DATE_FORMAT(date, format) -
- DAYNAME(date) -
- DAYOFMONTH(date) -
- DAYOFWEEK(date) -
- DAYOFYEAR(date) -
- EXP(power) -
- FLOOR(number) -
- FORMAT(number, decimals) -
- HOUR(time) -
- LENGTH(string) -
- LOG(number) -
- LOWER(number) -
- MD5(string) -
- MINUTE(time) -
- MONTH(date) -
- MONTHNAME(date) -
- NOW() -
- PASSWORD(string) -
- QUARTER(date) -
- REVERSE(string) -
- SECOND(time) -
- SIGN(number) -
- SPACE(number) -
- SQRT(number) -
- UPPER(string) -
- VERSION() -
- WEEK(date) -
- WEEKDAY(date) -
- YEAR(date) - -
- - - - - \ No newline at end of file -- cgit v1.2.3