List:General Discussion« Previous MessageNext Message »
From:Wouter van Vliet Date:August 28 2002 3:13pm
Subject:[select into] RE: SQL - Update problem
View as plain text  
Hmm .. isn't there any workaround for this .. Maybe something like:

	select count(*) into :somerVar FROM table;
	update sekce set pocet = :someVar WHERE ... blabla;

I've seen things like this in other databas servers but haven't been able to
find out if it's supported by MySQL, and if so, how...

Thanks,
Wouter

-----Oorspronkelijk bericht-----
Van: Mary Stickney [mailto:mary.stickney@stripped]
Verzonden: August 28, 2002 16:37
Aan: Jakub Mach; Mysql
Onderwerp: RE: SQL - Update problem



you cant.... update from is NOT supported....


-----Original Message-----
From: Jakub Mach [mailto:asp@stripped]
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 odkaz.sekce_id = sekce.id

Thanks for answer

j.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread118214@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-mary.stickney=tagtmi.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread118216@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-wouter=esctoday.com@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


Thread
SQL - Update problemJakub Mach28 Aug
  • RE: SQL - Update problemMary Stickney28 Aug
    • [select into] RE: SQL - Update problemWouter van Vliet28 Aug
    • Re: MS Access and mySQLNicholas Stuart28 Aug
  • Re: SQL - Update problemEgor Egorov28 Aug
  • Re: SQL - Update problemGelu Gogancea28 Aug
  • Re: SQL - Update problemGelu Gogancea28 Aug