Archives

The List

MySQL

« Previous Entries

More MySQL quizzes

Saturday, February 6th, 2010

Not quite pop quiz format, but if you enjoyed the ones I published some time ago (almost 2 years ago now… how time flies), you’ll probably be interested to know that

Please stop wasting my time…

Tuesday, April 28th, 2009

Another day, another application that insists on having to count every single object in the db/filesystem/whatever, just to show me a progress bar as it copies/updates/deletes something.
I. Don’t. Care.
Really. I just want you to get started on your task and get the job done.
If you insist on showing a progress bar, fine. But then get [...]

Those were the days…

Monday, April 20th, 2009

Feb. 15, 2006:
“We will be part of a larger company, but it will be called MySQL” Mickos said.
Sigh…

MySQL Pop Quiz #29

Thursday, September 25th, 2008

Yet another quiz inspired by Freenode#mysql IRC discussions. If you haven’t been around on the channel lately, you should have a peek. Lots of interesting discussions going on!
mysql> SELECT c1, c2 FROM t WHERE c2 LIKE ‘a%’;
+——+——+
| c1   | c2   |
+——+——+
| a    | abc  |
+——+——+
Is the following construct for the LIKE clause legal?
SELECT c1, c2 [...]

MySQL Pop Quiz #28

Wednesday, September 24th, 2008

Don’t forget to send in your suggestions for new quizzes!
This quiz originated on FreeNode#mysql, where someone asked how to count the number of newline-separated “fields” in a TEXT column. For the purposes of the quiz, I’ve changed the idea slightly but you should be able to appreciate the usefulness of this method for any x-separated [...]

“My turn to play MySQL”

Thursday, August 28th, 2008

[Update: A couple of people have told me they really like "your game". I am not the creator of this game; I merely point to it. To my knowledge, I don't know any of the people involved in creating it.]
“The ATTACK query is an undocumented feature of the development branch of MySQL…”
With the popularity [...]

PHP array_merge is Slow

Wednesday, April 30th, 2008

…or I’m doing something stupid, in which case I hope someone would enlighten me.
We grab a number of data from two different MySQL servers, get them back as arrays ($ar1 and $ar2) and then we concatenate the two arrays. $ar1 consists of 30 to 200 elements, sometimes more. $ar2 typically contains 30 elements.
The PHP way [...]

MySQL Pop Quiz #27

Tuesday, April 29th, 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 wonderful quiz from Vladimir Kolesnikov is one of those that should make you stop and think for a moment…
Given this table and data:
mysql> SELECT * FROM t;
+——+——+
| i1 [...]

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()

MySQL Pop Quiz #26

Thursday, April 24th, 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!
Today’s quiz question, which subsequently became three, comes courtesy of Janek Bogucki.
Since questions 2 and 3 contain hints on the other questions, they are embedded within the answers to [...]

« Previous Entries