Be careful out there… cars are WMDs

This happened a few days ago a few houses up our street: Man crashes car into swimming pool (in the Australian, other mentions on ABC and news.com.au).
(There’s a Dutch driving instruction joke: “kaboom = halt!, splash = water”. This nutball managed to do both at the same time.)
FYI: two kids had just come out that [...]

|

Filed under: Uncategorized | by arjen
No Comments »

Challenge: getting information out of INSERT/UPDATE

One annoying aspect of SQL is that sometimes you really want to get some result out of an INSERT or UPDATE statement. But in MySQL, you can. It’s just a nifty construct.
First just an UPDATE:

UPDATE tbl SET col = (@var := col), bla=value WHERE …
SELECT @var

So, you can assign a column to itself (MySQL does [...]

|

Filed under: Uncategorized | by arjen
4 Comments »

Last chance/reminder: call for papers MySQL Miniconf @ LCA07 Sydney

We’ll have a MySQL Miniconf at LinuxConfAU 2007 in Sydney on Monday, January 15th, before the conference proper starts. Some weeks ago we posted a call for papers and we’ve received excellent submissions! There’s a few slots left – so if you were pondering putting in for a talk, now is your (last) chance….
Please submit [...]

|

Filed under: Uncategorized | by arjen
No Comments »