Archive for March, 2008
« Previous EntriesMySQL Pop Quiz #22
Monday, March 31st, 2008I’m still looking for new entries. I get quite a few suggestions, but not all of them make it into quiz questions. Do send in your suggestions!
A column defined as CHAR(x) or VARCHAR(x) will allow you to store up to x characters within each field of that column.
What’s the minimum size of x?
What’s the maximum [...]
LOAD_FILE :: MySQL Function of the Day
Monday, March 31st, 2008Function name: LOAD_FILE()
Aliases: -
Function type: String function
Purpose: Read a file from disk and return it’s contents
MySQL Pop Quiz #21
Friday, March 28th, 2008I’m still looking for new entries. I get quite a few suggestions, but not all of them make it into quiz questions. Do send in your suggestions!
The maximum row size in a MySQL table in 64kb (65,535 bytes).
A LONGTEXT or LONGBLOB column may be up to 4,294,967,296 (4G) in size.
Explain how a LONGTEXT or LONGBLOB [...]
SUBSTRING() :: MySQL Function of the Day
Friday, March 28th, 2008Function 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, 2008Function name: BINARY
Aliases: CAST(… AS BINARY)
Function type: String function
Purpose: force a string to be regarded as binary sequence
MySQL Pop Quiz #20
Thursday, March 27th, 2008Today’s question comes courtesy of Diego Medina.
I’m still looking for new entries. I get quite a few suggestions, but not all of them make it into quiz questions. Do send in your suggestions!
When using a 1-byte character set like Latin-1, a VARCHAR(250) field requires 251 bytes of storage. A VARCHAR(260) field requires 262 bytes [...]
You’ve Got Six Months (if You’re Lucky!)
Wednesday, March 26th, 2008Ronald writes:
Tonight we were told at the NY PHP Meeting MySQL 5.1 is not due to late Q2, so that’s at least June 2008. The MySQL 5.1 Release Notes reveals a history that I don’t find very flattering…
Aside from Ronald’s totally correct observations re. the MySQL release schedule in general, “late Q2″ leads lots of [...]
MySQL Pop Quiz #19
Wednesday, March 26th, 2008I’m still looking for new entries. I get quite a few suggestions, but not all of them make it into quiz questions. Do send in your suggestions!
This entry comes from Rudy Limeback
A user searching your website is moving through categories, and you want to display descriptions of these categories as the user progresses. Your basic [...]
FORMAT() :: MySQL Function of the Day
Wednesday, March 26th, 2008Function name: FORMAT()
Aliases: -
Function type: String function
Purpose: Format a decimal number w/ thousands separator(s)
MySQL Function of the Day: Week 3
Tuesday, March 25th, 2008Week three was rather short, with 3 public holidays around here intervening…
(See this post for background information on MySQL Function of the Day)
Week Three:
Wednesday, March 19, 2008: PASSWORD()
Tuesday, March 2, 2008: FIND_IN_SET()
Week Two:
Wednesday, March 12, 2008: ELT()
Thursday, March 13, 2008: IF()
Friday, March 14, 2008: REPEAT()
Monday, March 17, 2008: FLOOR()
Tuesday, March 18, 2008: [...]