Recent tweets
- RT @bengoldacre: Who is this guy?: great work http://dlvr.it/3Bz85 21 hours ago
- @pauljchambers and its on tonight on Film4 :) 2010/07/29
- @ColHall You get fat. 2010/07/28
- The bread machine just beeped :) 2010/07/27
- I must've missed a few episodes of Smallvillle. Cos Clark is dating Lois! 2010/07/27
- You know what to do: RT @megpickard: all tweets including the word Channel 4 will appear on a screen in the company's lift today 2010/07/27
- Water is bouncy, see: http://www.youtube.com/watch?v=zRSK4k3D-50 2010/07/27
Tag Archives: mysql
Within-group aggregates with another wrinkle.
Recently when optimising an SQL query I needed to return a specific subset of records from a large table. The brilliant Common Queries Tree pointed me in the right direction, but the examples didn’t quite cover my specific case. I … Continue reading
MySQL: Row N was truncated; a solution
You’re importing some data into MySQL and using LOAD DATA INFILE so you can do a SHOW WARNINGS afterwards. Every line of your import file has a warning: | Warning | 1262 | Row 1 was truncated; it contained more … Continue reading