Archives

The List

MySQL Function of the day

« Previous Entries

DATABASE() :: MySQL Function of the Day

Tuesday, April 29th, 2008

Function name: DATABASE()
Aliases: -
Function type: Information function
Purpose: Return the name of the current database

MySQL Function of the Day: Week Seven

Monday, April 28th, 2008

The weekly run-down of MFotD
(See this post for background information on MySQL Function of the Day)
Week Seven:

Monday, April 21st, 2008: ROUND()
Tuesday, April 22nd, 2008: TRUNCATE
Wednesday, April 23rd, 2008: LOG()

ENCODE() :: MySQL Function of the Day

Monday, April 28th, 2008

Function name: ENCODE
Aliases: -
Function type: Encryption function
Purpose: Encrypt a string using a password

LOG() :: MySQL Function of the Day

Wednesday, April 23rd, 2008

Function name: LOG()
Aliases: (LN, LOG2, LOG10)
Function type: Numerical function
Purpose: Return the logarithm of a number

TRUNCATE :: MySQL Function of the Day

Tuesday, April 22nd, 2008

Function name: TRUNCATE
Aliases: -
Function type: Numerical function
Purpose: Round a number toward zero

ROUND() :: MySQL Function of the Day

Monday, April 21st, 2008

Function name: ROUND
Aliases: -
Function type: Numerical function
Purpose: Round a number to a certain number of decimal places
Description: MySQLs ROUND() is an extremely versatile implementation of rounding functions wrapped into one single function. To wit:

MySQL Function of the Day: Week Six

Monday, April 21st, 2008

The weekly run-down of MFotD
(See this post for background information on MySQL Function of the Day)
Week Six:

Monday, April 14th 2008:REVERSE()
Tuesday, April 15th 2008: CEILING()
Wednesday, April 16 2008: BENCHMARK()
Thursday, April 17 2008: MD5()
Friday, April 18 2008: CRC32()

CRC32 :: MySQL Function of the Day

Friday, April 18th, 2008

Function name: CRC32
Aliases: -
Function type: Numerical function
Purpose: Return a Cyclic Redundancy Check value of a string

MD5() :: MySQL Function of the Day

Thursday, April 17th, 2008

Function name: MD5()
Aliases: -
Function type: Encryption/compression function
Purpose: Return the MD5 Message-Digest of a string

BENCHMARK() :: MySQL Function of the Day

Wednesday, April 16th, 2008

unction name: BENCHMARK()
Aliases: -
Function type: Information Function
Purpose: Repeat an operation a number of times

« Previous Entries