| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Josh Trutwin | Date: | June 9 2004 4:34pm |
| Subject: | Re: UPDATE...WHERE ... IN (SELECT...) | ||
| View as plain text | |||
On Wed, 9 Jun 2004 18:25:11 +0200 Markus Källander <markus.kallander@stripped> wrote: > Hi all, > > Can someone tell me what is wrong with this statement? > > UPDATE nummer SET gold = '1' WHERE anr IN (SELECT no FROM gull); > > I use MySQL 3.23.49. ^^^^^^^ 4.1 or higher is required for sub-selects. http://dev.mysql.com/doc/mysql/en/Subqueries.html Josh
| Thread | ||
|---|---|---|
| • UPDATE...WHERE ... IN (SELECT...) | Markus Källander | 9 Jun |
| • RE: UPDATE...WHERE ... IN (SELECT...) | Victor Pendleton | 9 Jun |
| • RE: UPDATE...WHERE ... IN (SELECT...) | Michael Young | 9 Jun |
| • Re: UPDATE...WHERE ... IN (SELECT...) | Josh Trutwin | 9 Jun |
| • RE: UPDATE...WHERE ... IN (SELECT...) | Laercio Xisto Braga Cavalcanti | 9 Jun |