>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
>
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 t
You can update the "first" row by adding LIMIT 1 to your update query.
If the rows are identical, "first" vs. "third" doesn't matter. If it
does matter,
you should probably add a unique, tiebreaking field (sequence or
DateTime, if
you can assure there will never be 2 identical records inserted per
Your table has no primary key.
You have a badly malformed database.
How can you tell one transaction from another?
You have debit and credit amounts with no timestamp or account
identifier.
Add an autoincrement id field as a primary key. Then you can update
based on that key.
Richard Reina wrote
insert a unique key field, but I'm not sure if it would
pre-populate existing records.
If it works, you can then use the update function where id="xxx";
Hope this helps
Ben
-Original Message-
From: Richard Reina [mailto:[EMAIL PROTECTED]]
Sent: 09 April 2001 10:59
To: [EMAIL
DateDB_amount CR_amount
2001-04-09 NULL300.00
2001-04-09 NULL750.00
2001-04-09 NULL300.00
Anyone know how can I do a query that will update the third record
without updating the first?
--
