I want to keep a cumulative balance field in a mysql table. How do I do
this without corruption...
if the table looks like this:
datetime,desc,amount,balance
How can I insert a new record setting the balance field to the last balance
value + amount and not have data corruption if multiple inser
I am using a binary installation of MySQL for Linux 7.1...how do I tell what
database it is configured to use for the backend? InnoDB or something else?
-bryanw
.BIZ, .INFO, .CC .COM, .NET, .ORG
Pre-register your .NAME address now!
http://www.halfpricenames.com/
---
Take a look at the LAST_INSERT_ID() function.
-bryanw
HalfPriceNames Domain Registry
http://www.halfpricenames.com/
-Original Message-
From: Matt Graham [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 9:12 AM
To: '[EMAIL PROTECTED]'
Subject: getting id or record just inserte