Home Learn Patterns Paths

SQL

SQL References

SQL References centers on SQL Data Types for MySQL, SQL Server, and MS Access, plus the ideas that build on it.

MySQL Functions

MySQL has many built-in functions.

Read lesson →

SQL Server Functions

SQL Server has many built-in functions.

Read lesson →

MS Access Functions

MS Access has many built-in functions.

Read lesson →

MySQL Functions

MySQL ASCII() Function MySQL CHAR_LENGTH() Function MySQL CHARACTER_LENGTH() Function MySQL CONCAT() Function MySQL CONCAT_WS() Function MySQL FIELD() Function MySQL FIND_IN_SET() Function MySQL FORMAT() Function MySQL INSERT() Function MySQL INSTR() Function MySQL LCASE() Function MySQL LEFT() Function MySQL LENGTH() Function MySQL LOCATE() Function MySQL LOWER() Function MySQL LPAD() Function MySQL LTRIM() Function MySQL MID() Function MySQL POSITION() Function MySQL REPEAT() Function MySQL REPLACE() Function MySQL REVERSE() Function MySQL RIGHT() Function MySQL RPAD() Function MySQL RTRIM() Function MySQL SPACE() Function MySQL STRCMP() Function MySQL SUBSTR() Function MySQL SUBSTRING() Function MySQL SUBSTRING_INDEX() Function MySQL TRIM() Function MySQL UCASE() Function MySQL UPPER() Function MySQL ABS() Function MySQL ACOS() Function MySQL ASIN() Function MySQL ATAN() Function MySQL ATAN2() Function MySQL AVG() Function MySQL CEIL() Function MySQL CEILING() Function MySQL COS() Function MySQL COT() Function MySQL COUNT() Function MySQL DEGREES() Function MySQL DIV Function MySQL EXP() Function MySQL FLOOR() Function MySQL GREATEST() Function MySQL LEAST() Function MySQL LN() Function MySQL LOG() Function MySQL LOG10() Function MySQL LOG2() Function MySQL MAX() Function MySQL MIN() Function MySQL MOD() Function MySQL PI() Function MySQL POW() Function MySQL POWER() Function MySQL RADIANS() Function MySQL RAND() Function MySQL ROUND() Function MySQL SIGN() Function MySQL SIN() Function MySQL SQRT() Function MySQL SUM() Function MySQL TAN() Function MySQL TRUNCATE() Function MySQL ADDDATE() Function MySQL ADDTIME() Function MySQL CURDATE() Function MySQL CURRENT_DATE() Function MySQL CURRENT_TIME() Function MySQL CURRENT_TIMESTAMP() Function MySQL CURTIME() Function MySQL DATE() Function MySQL DATEDIFF() Function MySQL DATE_ADD() Function MySQL DATE_FORMAT() Function MySQL DATE_SUB() Function MySQL DAY() Function MySQL DAYNAME() Function MySQL DAYOFMONTH() Function MySQL DAYOFWEEK() Function MySQL DAYOFYEAR() Function MySQL EXTRACT() Function MySQL FROM_DAYS() Function MySQL HOUR() Function MySQL LAST_DAY() Function MySQL LOCALTIME() Function MySQL LOCALTIMESTAMP() Function MySQL MAKEDATE() Function MySQL MAKETIME() Function MySQL MICROSECOND() Function MySQL MINUTE() Function MySQL MONTH() Function MySQL MONTHNAME() Function MySQL NOW() Function MySQL PERIOD_ADD() Function MySQL PERIOD_DIFF() Function MySQL QUARTER() Function MySQL SECOND() Function MySQL SEC_TO_TIME() Function MySQL STR_TO_DATE() Function MySQL SUBDATE() Function MySQL SUBTIME() Function MySQL SYSDATE() Function MySQL TIME() Function MySQL TIME_FORMAT() Function MySQL TIME_TO_SEC() Function MySQL TIMEDIFF() Function MySQL TIMESTAMP() Function MySQL TO_DAYS() Function MySQL WEEK() Function MySQL WEEKDAY() Function MySQL WEEKOFYEAR() Function MySQL YEAR() Function MySQL YEARWEEK() Function MySQL BIN() Function MySQL BINARY Function MySQL CASE Function MySQL CAST() Function MySQL COALESCE() Function MySQL CONNECTION_ID() Function MySQL CONV() Function MySQL CONVERT() Function MySQL CURRENT_USER() Function MySQL DATABASE() Function MySQL IF() Function MySQL IFNULL() Function MySQL ISNULL() Function MySQL LAST_INSERT_ID() Function MySQL NULLIF() Function MySQL SESSION_USER() Function MySQL SYSTEM_USER() Function MySQL USER() Function MySQL VERSION() Function

SQL Server Functions

SQL Server ASCII() Function SQL Server CHAR() Function SQL Server CHARINDEX() Function SQL Server CONCAT() Function SQL Server CONCAT_WS() Function SQL Server DATALENGTH() Function SQL Server DIFFERENCE() Function SQL Server FORMAT() Function SQL Server LEFT() Function SQL Server LEN() Function SQL Server LOWER() Function SQL Server LTRIM() Function SQL Server NCHAR() Function SQL Server PATINDEX() Function SQL Server QUOTENAME() Function SQL Server REPLACE() Function SQL Server REPLICATE() Function SQL Server REVERSE() Function SQL Server RIGHT() Function SQL Server RTRIM() Function SQL Server SOUNDEX() Function SQL Server SPACE() Function SQL Server STR() Function SQL Server STUFF() Function SQL Server SUBSTRING() Function SQL Server TRANSLATE() Function SQL Server TRIM() Function SQL Server UNICODE() Function SQL Server UPPER() Function SQL Server ABS() Function SQL Server ACOS() Function SQL Server ASIN() Function SQL Server ATAN() Function SQL Server ATN2() Function SQL Server AVG() Function SQL Server CEILING() Function SQL Server COUNT() Function SQL Server COS() Function SQL Server COT() Function SQL Server DEGREES() Function SQL Server EXP() Function SQL Server FLOOR() Function SQL Server LOG() Function SQL Server LOG10() Function SQL Server MAX() Function SQL Server MIN() Function SQL Server PI() Function SQL Server POWER() Function SQL Server RADIANS() Function SQL Server RAND() Function SQL Server ROUND() Function SQL Server SIGN() Function SQL Server SIN() Function SQL Server SQRT() Function SQL Server SQUARE() Function SQL Server SUM() Function SQL Server TAN() Function SQL Server CURRENT_TIMESTAMP Function SQL Server DATEADD() Function SQL Server DATEDIFF() Function SQL Server DATEFROMPARTS() Function SQL Server DATENAME() Function SQL Server DATEPART() Function SQL Server DAY() Function SQL Server GETDATE() Function SQL Server GETUTCDATE() Function SQL Server ISDATE() Function SQL Server MONTH() Function SQL Server SYSDATETIME() Function SQL Server YEAR() Function SQL Server CAST() Function SQL Server COALESCE() Function SQL Server CONVERT() Function SQL Server CURRENT_USER Function SQL Server IIF() Function SQL Server ISNULL() Function SQL Server ISNUMERIC() Function SQL Server NULLIF() Function SQL Server SESSION_USER Function SQL Server SESSIONPROPERTY() Function SQL Server SYSTEM_USER Function SQL Server USER_NAME() Function

SQL Keywords

SQL ADD Keyword SQL ADD CONSTRAINT Keyword SQL ALL Keyword SQL ALTER Keyword SQL ALTER COLUMN Keyword SQL ALTER TABLE Keyword SQL ALTER VIEW Keyword SQL AND Keyword SQL ANY Keyword SQL AS Keyword SQL ASC Keyword SQL BACKUP DATABASE Keyword SQL BETWEEN Keyword SQL CASE Keyword SQL CHECK Keyword SQL COLUMN Keyword SQL CONSTRAINT Keyword SQL CREATE Keyword SQL CREATE DATABASE Keyword SQL CREATE INDEX Keyword SQL CREATE OR REPLACE VIEW Keyword SQL CREATE TABLE Keyword SQL CREATE PROCEDURE Keyword SQL CREATE UNIQUE INDEX Keyword SQL CREATE VIEW Keyword SQL DATABASE Keyword SQL DEFAULT Keyword SQL DELETE Keyword SQL DESC Keyword SQL SELECT DISTINCT Keyword SQL DROP Keyword SQL DROP COLUMN Keyword SQL DROP CONSTRAINT Keyword SQL DROP DATABASE Keyword SQL DROP DEFAULT Keyword SQL DROP INDEX Keyword SQL DROP TABLE and TRUNCATE TABLE Keywords SQL DROP VIEW Keyword SQL EXEC Keyword SQL EXISTS Keyword SQL FOREIGN KEY Keyword SQL FROM Keyword SQL FULL OUTER JOIN Keyword SQL GROUP BY Keyword SQL HAVING Keyword SQL IN Keyword SQL INDEX Keyword SQL INNER JOIN Keyword SQL INSERT INTO Keyword SQL INSERT INTO SELECT Keyword SQL IS NULL Keyword SQL IS NOT NULL Keyword SQL JOIN Keyword SQL LEFT JOIN Keyword SQL LIKE Keyword SQL SELECT TOP, LIMIT and ROWNUM Keywords SQL NOT Keyword SQL NOT NULL Keyword SQL OR Keyword SQL ORDER BY Keyword SQL FULL OUTER JOIN Keyword SQL PRIMARY KEY Keyword SQL CREATE PROCEDURE Keyword SQL RIGHT JOIN Keyword SQL SELECT TOP, LIMIT and ROWNUM Keywords SQL SELECT Keyword SQL SELECT DISTINCT Keyword SQL SELECT INTO Keyword SQL SELECT TOP, LIMIT and ROWNUM Keywords SQL SET Keyword SQL TABLE Keyword SQL SELECT TOP, LIMIT and ROWNUM Keywords SQL DROP TABLE and TRUNCATE TABLE Keywords SQL UNION Keyword SQL UNION ALL Keyword SQL UNIQUE Keyword SQL UPDATE Keyword SQL VALUES Keyword SQL VIEW Keyword SQL WHERE Keyword

MS Access Functions

MS Access Asc() Function MS Access C hr() Function MS Access CurDir() Function MS Access Format() Function MS Access InStr() Function MS Access InstrRev() Function MS Access LCase() Function MS Access Left() Function MS Access Len() Function MS Access LTrim() Function MS Access Mid() Function MS Access Replace() Function MS Access Right() Function MS Access RTrim() Function MS Access Space() Function MS Access Split() Function MS Access Str() Function MS Access StrComp() Function MS Access StrConv() Function MS Access StrReverse() Function MS Access Trim() Function MS Access UCase() Function MS Access Abs() Function MS Access Atn() Function MS Access Avg() Function MS Access Cos() Function MS Access Count() Function MS Access Exp() Function MS Access Fix() Function MS Access Format() Function MS Access Int() Function MS Access Max() Function MS Access Min() Function MS Access Randomize() Function MS Access Rnd Function MS Access Round() Function MS Access Sgn() Function MS Access Sqr() Function MS Access Sum() Function MS Access Val() Function MS Access Date() Function MS Access DateAdd() Function MS Access DateDiff() Function MS Access DatePart() Function MS Access DateSerial() Function MS Access DateValue() Function MS Access Day() Function MS Access Format() Function MS Access Hour() Function MS Access Minute() Function MS Access Month() Function MS Access MonthName() Function MS Access Now() Function MS Access Second() Function MS Access Time() Function MS Access TimeSerial() Function MS Access TimeValue() Function MS Access Weekday() Function MS Access WeekdayName() Function MS Access Year() Function MS Access CurrentUser() Function MS Access Environ() Function MS Access IsDate() Function MS Access IsNull() Function MS Access IsNumeric() Function

SQL Reference

SQL Data Types for MySQL, SQL Server, and MS Access SQL Server Concat With +MS Access Concat With &