Archives

The List

Archive for March, 2008

« Previous Entries Next Entries »

MySQL Pop Quiz #18

Tuesday, March 25th, 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!
In mysql>, you already know that hitting return on this:
SELECT 1+1, 2+2;
returns this:
+—–+—–+
| 1+1 | 2+2 |
+—–+—–+
| 2 | 4 |
+—–+—–+
What happens if you instead [...]

FIND_IN_SET() :: MySQL Function of the Day

Tuesday, March 25th, 2008

Function name: FIND_IN_SET
Aliases: -
Function type: String function
Purpose: Return position of value in string of comma-separated values

MySQL Pop Quiz #17

Wednesday, March 19th, 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!
As the MySQL root user user, I grant access to a new employee in the organization:
GRANT SELECT ON abc.* TO “user_a”@”192.168.1.%”;
Some time later, the new colleague becomes a former [...]

PASSWORD() :: MySQL Function of the Day

Wednesday, March 19th, 2008

PASSWORD() :: MySQL Function of the Day
Function name: PASSWORD
Aliases: (OLD_PASSWORD)
Function type: Encryption function
Purpose: Convert a plain-text password into the hashed password stored by the server.

MySQL Function of the Day: Week 2

Tuesday, March 18th, 2008

(See this post for background information on MySQL Function of the Day)
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: DIV()

Week One:

Wednesday, March 5th, 2008: CHAR_LENGTH()
Thursday, March 6th, 2008: NOW()
Friday, March 7th, 2008: CONCAT_WS
Monday, March 10th, 2008: LOWER()
Tuesday, March 11th, [...]

DIV :: MySQL Function of the Day

Tuesday, March 18th, 2008

Function name: DIV
Aliases: -
Function type: Numeric operator
Purpose: Integer division

MySQL Pop Quiz #16

Monday, March 17th, 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!
Short questions with somewhat involved answers. In terms of MySQL (and databases in general)…

What is a character set?
What is a collation?
How do they interact?
Is this something you even need [...]

MySQL Pop Quiz #15

Monday, March 17th, 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!
Question: Where can you find a really cool Pop Quiz — like question on the syntax (and pitfalls) of the CASE statement?

FLOOR() :: MySQL Function of the Day

Monday, March 17th, 2008

Function name: FLOOR()
Aliases: -
Function type: Mathematical function
Purpose: Round down to nearest integer

REPEAT() :: MySQL Function of the Day

Friday, March 14th, 2008

Function name: REPEAT()
Aliases: -
Function type: String function
Purpose: Return a string repeated a number of times

« Previous Entries Next Entries »