Cumulative Balance Field

2003-02-22 Thread Bryan Waters
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

Which Database?

2001-12-29 Thread Bryan Waters
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/ ---

RE: getting id or record just inserted

2001-11-29 Thread Bryan Waters
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