Archives

The List

MySQL Function of the day

« Previous Entries Next Entries »

CEILING() :: MySQL Function of the Day

Tuesday, April 15th, 2008

Function name: CEILING()
Aliases: CEIL()
Function type: Numeric function
Purpose: Return the nearest integer which is equal or higher

MySQL Function of the Day: Week 4, ehr, 5, uhm.. something

Monday, April 14th, 2008

Got sidetracked in a major way the past few weeks, so “of the day” became something of a misnomer. Hoping to get back on track, here’s a rundown of the latest posts.
Since we’ve had this break anyway, I’m also resetting the “week” to start on Mondays.
(See this post for background information on MySQL Function of [...]

REVERSE() :: MySQL Function of the Day

Monday, April 14th, 2008

Function name: REVERSE()
Aliases: -
Function type: String function
Purpose: Return a string with characters in reverse order

IFNULL :: MySQL Function of the Day

Tuesday, April 8th, 2008

Function name: IFNULL
Aliases: -
Function type: Control Flow function
Purpose: Test whether an expression evaluates to NULL

DATE_ADD() :: MySQL Function of the Day

Monday, April 7th, 2008

Function name: DATE_ADD()
Aliases: (DATE_SUB)
Function type: Temporal function
Purpose: Add or subtract a period of time to an existing date

HEX() :: MySQL Function of the Day

Tuesday, April 1st, 2008

Function name: HEX()
Aliases: -
Function type: String function
Purpose: Return the hexadecimal representation of a string

LOAD_FILE :: MySQL Function of the Day

Monday, March 31st, 2008

Function name: LOAD_FILE()
Aliases: -
Function type: String function
Purpose: Read a file from disk and return it’s contents

SUBSTRING() :: MySQL Function of the Day

Friday, March 28th, 2008

Function name: SUBSTRING()
Aliases: MID(), SUBSTR()
Function type: String function
Purpose: Extract part of a string from another string

BINARY :: MySQL Function of the Day

Thursday, March 27th, 2008

Function name: BINARY
Aliases: CAST(… AS BINARY)
Function type: String function
Purpose: force a string to be regarded as binary sequence

FORMAT() :: MySQL Function of the Day

Wednesday, March 26th, 2008

Function name: FORMAT()
Aliases: -
Function type: String function
Purpose: Format a decimal number w/ thousands separator(s)

« Previous Entries Next Entries »