Finding the size of an individual row

[0ddball]

Hi hi hi,

I'm trying to do something that should look like the following:

SELECT SIZE() FROM `companies` WHERE `companyId` = ?guid

It's an odd request but there *is* a point. I'm trying to find which tuple has the most data in it as an arbitrary method of choosing a destination for merging non-unique records.


Yet another unchecked rambling brought to you by:
Oddball

 

[r937]

select char_length(col3)
+char_length(col7)
+char_length(col9)
/* repeat for all char/varchar/text columns */
+ 4 * 11 /* number of integer columns */
+ 2 * 3 /* number of smallint columns */
+ 1 * 6 /* number of tinyint columns */
from ...

get the idea?


r937.com | rudy.ca

 

[0ddball]

Gosh - that's rubbish isn't it

Surely there's a better way?


Yet another unchecked rambling brought to you by:
Oddball