Is this really a limit of MySQL. This look like a join update. This is not
really changing the ID in both tables is it? If it is I have not used this
in MS SQL 2000 either I usually do two updates. What would you use this
for?
I am assuming you can do this in MySQL:
Update Basket
Set Basket.StudentID=
(Select Student.Reg_ID=Baket.reg_ID
From Student
Where Student.Reg_ID=Basket.reg_ID)
--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com
> From: "Atrix Wolfe" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Fri, 30 May 2003 21:26:35 -0700
> To: <[EMAIL PROTECTED]>
> Subject: Re: Witango-Talk: MySQL on Mac and Dev Studio 5.0 on windows
>
> i did some research a while back (not a huge amount of research) but i found
> out that at the time, neither MySQL or PostgreSQL supported multiple table
> updates...IE:
>
> update tableA,tableB
> set TableA.id=tableB.id
> where TableA.Date >= '05/15/1981'
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
