>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?
> > >
Sir, create a new table containing no duplicates.
INSERT INTO new_table
SELECT *
FROM old_table
GROUP BY Date, DB_amount, CR_amount
Delete old_table. Change the name of new_table to old_table.
And finally, redesign your table to avoid this kind of embarrassment.
You don't want to make a habit of deleting tables in order to
overcome design problems.
Bob Hall
Know thyself? Absurd direction!
Bubbles bear no introspection. -Khushhal Khan Khatak
MySQL list magic words: sql query database
---------------------------------------------------------------------
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
