On Saturday 20 January 2007 05:52, ViSolve DB Team wrote:
> Hi
>
> Update will never support group by clause, only supports group functions;
> Try as:
>
> Update teams t
> inner join rider_team as rt on (rt.team_id=t.id)
> inner join participants as p on (p.rider_id=rt.rider
Hi
Update will never support group by clause, only supports group functions;
Try as:
Update teams t
inner join rider_team as rt on (rt.team_id=t.id)
inner join participants as p on (p.rider_id=rt.rider_id)
inner join races as r on (r.id=p.race_id)
set t.created
On 26-Feb-2003 Andrew Maynes wrote:
> problably a silly question but if I am updating a table in a MySQL DB with a
> table structure like this:
>
> TABLE xxx
> ItemSKU
> ItemName
> ItemDescription
> PostCode
> Category
> CityID
> CTelephone
> ItemID
> Cfax
> Cemail
> Caddre
Check the REPLACE command...
http://www.mysql.com/doc/en/REPLACE.html
I think it suits your problem...
On Mon, 2003-01-20 at 08:14, Michael Watson wrote:
> This may be very simple, but the solution eludes me..
>
> I have two tables Products and NewProducts, The Products table contains a
> list