Hi,
Egor has right and i didn't read very carefully you e-mail.Sorry
You can try this :
SET @a:=0;
SET @b:=0;
SELECT @a:=COUNT(*),@b:=sekce.id FROM odkaz,sekce WHERE odkaz.sekce_id =
sekce.id;
UPDATE sekce SET pocet = @a WHERE id= @b;
Now...i think it's corect...
Regards,
Gelu
_
Hi,
...adding a new query and using variable:
SET @a:=0; --initialize variable a;
select @:=COUNT(*) from odkaz where odkaz.sekce_id = sekce.id;
update sekce set pocet = @a where odkaz.sekce_id = sekce.id;
Regards,
Gelu
_
G.NET SOFTWARE COMP
Jakub,
Wednesday, August 28, 2002, 5:15:01 PM, you wrote:
JM> how can I do sql command like this:
JM> update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id
First: multi-table updates is supported only since 4.0.2
Second: even on 4.0.2 you can't do it with above query
-
s supported by MySQL, and if so, how...
Thanks,
Wouter
-Oorspronkelijk bericht-
Van: Mary Stickney [mailto:[EMAIL PROTECTED]]
Verzonden: August 28, 2002 16:37
Aan: Jakub Mach; Mysql
Onderwerp: RE: SQL - Update problem
you cant update from is NOT supported
-Original Message--
you cant update from is NOT supported
-Original Message-
From: Jakub Mach [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 28, 2002 9:15 AM
To: Mysql
Subject: SQL - Update problem
Hi,
how can I do sql command like this:
update sekce set pocet = count(*) from odkaz where od