Re: getting size of query rows

2004-01-24 Thread Roger Baklund
* Juan Nin > I want to get amount of disk space used by certain rows on disk, > not a whole table, but only some rows. Is this possible? How accurate does it have to be? On the byte? On the K? > For example I got a table like: > > CREATE TABLE `categories` ( > `id` int(11) NOT NULL auto_increme

getting size of query rows

2004-01-24 Thread Juan Nin
Hi! I want to get amount of disk space used by certain rows on disk, not a whole table, but only some rows. Is this possible? For example I got a table like: CREATE TABLE `categories` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `parent_category_id` int(