MySQL« Previous Entries
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 [...]
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 [...]
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 [...]
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
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 [...]
Feb. 15, 2006:
“We will be part of a larger company, but it will be called MySQL” Mickos said.
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 [...]
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 [...]
[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 [...]
…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 [...]