Archives

The List

MySQL

« Previous Entries

I Really Need to Get a Life…

Sunday, December 26th, 2010

Poul-Henning Kamp, of FreeBSD fame, posted a year-end question (in Danish) on his blog at the IT rag version2.dk: What would be the computer equivalent of Shannon’s ultimate machine?
Based on one of the comment suggestions, inspired by the fact that I’d been messing around with automating the Windows cursor some months back, and having half [...]

E-mail Hosting Recommendations?

Friday, April 2nd, 2010

If you think I’ve been a long time in replying to your e-mails in the past month or so, there’s a good explanation for that.
For the past many years, I’ve been using an e-mail hosting provider that prides itself on offering a special class of services. Things have actually been very good, with few hiccups [...]

Expert PHP and MySQL

Friday, April 2nd, 2010

Just released by Wrox: Expert PHP and MySQL by Andrew Curioso, Ronald Bradford and Patrick Galbraith.
For once, an “Expert” book where you not only can, but must take the title seriously. This book is choke-full of information, examples and best practices written by some of the foremost experts in their respective fields. All of the [...]

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

« Previous Entries