> Steve McGill wrote:
> > I have a situation where I am doing lots of complex sorting on records
that
> > already exist in a MySQL table. The table has a 'sort_order' field which
> > means I can do a simple ORDER BY sort_order to keep it nice and quick on
> > SELECT, it's only UPDATE which is slow.
Steve McGill wrote:
I have a situation where I am doing lots of complex sorting on records that
already exist in a MySQL table. The table has a 'sort_order' field which
means I can do a simple ORDER BY sort_order to keep it nice and quick on
SELECT, it's only UPDATE which is slow.
If I change the o
ernet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
> -Original Message-
> From: Peter Lovatt [mailto:[EMAIL PROTECTED]]
> Sent: 18 April 2002 23:30
> To: [EMAIL PROTECTED]; [EMAIL PROTEC
IF there is a formula for the value of quantity eg Quantity = Quantity -1
(UPDATE table SET Quantity = Quantity-1 ) you need to do an update statement
for each row
EG UPDATE table SET Quantity = "9" WHERE Field = Book3
HTH
Peter
---
Excellence in int