On Tue, 04 Mar 2008 15:04:30 +0100, Nacho Garcia wrote:
or count the comments on elements_comments table. I guess the last
option could be very slow with lot of rows because mysql has to scan all
of them .. and the first option seems to be very fast.
I would certainly want to be able to:
Hi, i hope this is the right place for this basic question.
i have a table like this:
TABLE elements
`id_element` INT UNSIGNED NOT NULL ,
`name` VARCHAR(100),
`date` DATE
...
and other table with the comments of every element.
TABLE elements_comments
`id_element` INT UNSIGNED NOT NULL ,