AIL PROTECTED]>
Sent: Wednesday, August 28, 2002 5:15 PM
Subject: SQL - Update problem
> Hi,
>
> how can I do sql command like this:
>
> update sekce set pocet = count(*) from odkaz where odkaz.sekce_id =
sekce.id
>
> Thanks for answer
>
> j.
>
>
>
COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Jakub Mach" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, August 28, 2002 5:15 PM
Subject: SQL
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
Hi,
how can I do sql command like this:
update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id
Thanks for answer
j.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
h
