Unfortunately I am using 3.22.32. Does this mean I am out of luck with
this query.
Peter Schwenk wrote:
>
> If you are using version 3.23.x of MySQL, there is a LIMIT clause that you can use
> to just update up to a certain number of records, so you could add 'LIMIT 1' to the
> UPDATE command to only change one record.
>
> Richard Reina wrote:
>
> > Date DB_amount CR_amount
> > 2001-04-09 NULL 300.00
> > 2001-04-09 NULL 750.00
> > 2001-04-09 NULL 300.00
> >
> > Anyone know how can I do a query that will update the third record
> > without updating the first?
> >
> > ---------------------------------------------------------------------
> > 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 <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> --
> PETER SCHWENK | Campus IT Associate 3
> Department of Mathematical Sciences | University of Delaware
> [EMAIL PROTECTED] | (302)831-0437
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
