Microsoft Word - Sam's Teach Yourself MySQL in 21 Days - SAMS.doc

Example:

SELECT COS(4)

Result:

-0.653644

COT(x)

Returns the cotangent of x.
Example:
SELECT COT(5)
Result:

-0.29581292

COUNT(x)

Returns the of non-NULL values in a resultset. If an is used, it returns the number of rows in the resultset.
Example:
SELECT COUNT(Smokers) as Smokers FROM Customers WHERE Smoker = "Y"
SELECT COUNT() FROM Customers
Results:

129

300

CURDATE() and CURRENT_DATE()

Return the current system date.
Example:
SELECT CURDATE()
Result:

"2000-01-30"

CURTIME() and CURRENT_TIME()

Return the current system time.
Example:
SELECT CURTIME()
Result:

'23:49:00'

CURRENT_TIMESTAMP()

Returns the current date and time. See NOW(), SYSDATE(), and CURTIME().
Example:
SELECT CURRENT_TIMESTAMP()
Result:

'2000-01-30 23:49:34'

DATABASE()

Returns the name of the current database.
Example:
SELECT DATABASE()
Result:

'Meet_A_Geek'

DATE_ADD()

See ADDDATE().