Archives

The List

Archive for March, 2008

« Previous Entries

MySQL Pop Quiz #22

Monday, March 31st, 2008

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!
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, 2008

Function 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, 2008

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!
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, 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

MySQL Pop Quiz #20

Thursday, March 27th, 2008

Today’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, 2008

Ronald 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, 2008

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!
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, 2008

Function 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, 2008

Week 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: [...]

« Previous Entries