JakeJ wrote:Start with the obvious features and add the rest as time marches on. That's the beauty of Open Source.
So is this list "obvious"?
- SELECT <field list> FROM table WHERE <conditions>
- does <field list> support AS?
- <conditions> : =, !=, >, <, >=, <=, LIKE, NOT LIKE, IS NULL, IS NOT NULL?
- INSERT <INTO> table (<field list>) VALUES (<value list>)
- INSERT <INTO> table SET (<assignment list>)
- REPLACE <INTO> table (<field list>) VALUES (<value list>)
- REPLACE <INTO> table SET (<assignment list>)
- UPDATE table SET (<assignment list>) WHERE <conditions>
What functions are supported? Here is a short list:
SQL Aggregate Functions
MAX() and MIN() functions allow you to display maximum and minimum values in a set.
COUNT() function used to count number of record of each database table.
AVG() calculates the arithmetic average of the series of numbers of its argument
SUM() function uses to sum the values
SQL Mathematical Functions
CEIL(or CEILING) and FLOOR functions are round the numbers. SQL CEIL roundup to the nearest integer value while FLOOR round down to the next least integer value.
RAND() function is used to generate some random numbers at run time.
ABS function returns the absolute value of an numeric input argument.
EXP() function returns e raised to the n-th power (e is the base of the natural logarithm and is equal to approximately 2.718281828459).
PI() function maybe the most simplest mathematical SQL function because it returns a constant value of pi
SQRT function extracts the square root from the positive numeric input argument. SQL SQRT function accepts only positive arguments, andreturns an error when a negative argument is passed in.
POWER() function returns the
ROUND function rounds a number to a specific length or precision.
LOG() function allows us to operate mathematical logarithmic calculation
Trigonometric functions?
SQL String Functions
ASCII() - If you want to find a numerical value of a character which is in range of 0 to 255 you can use SQL ASCII function
LENGTH() or LEN() - To get the length of a string.
CONCAT() - is used to concatenate two or more strings. MySQL allows you concatenate more than two strings while other force exactly two.
CHAR() or CHR() function is the opposite of ASCII. It converts an integer in range 0-255 into a ascii character.
REPLACE() - SQL replace function replaces every occurrence of the string specified as the searched string with the replacement string.
UPPER() and LOWER() - Upper function allow you to convert all characters in a string into uppercase. Otherwise SQL lower function allow you to convert all characters in a string into lowercase.
SUBSTRING() or SUBSTR() - In order to get a part of a string we can use sql substring or substr function.