Recent tweets
- @Wilona the grey text isnt working out too well there. Great gifs though. 2012/02/03
- @JanLomax mostly just lazing about but I have the maths books open again now 2012/02/02
- @JanLomax everything is great. Hope you are too. 2012/02/02
- @JanLomax hey hot stuff. xx 2012/02/02
- @Drewjbeckett applying for the Blue Man Group? ;) 2012/01/24
- @holleyhop I think I'm gonna cut all mine off in the spring :) 2012/01/24
- Logan's Run is on :) 2012/01/24
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 …
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 …