What sort of support for transactions and table/record locking is there in MySQL right
now? I had heard that only table locking was supported, and limited support for
transactions.
Aaron
-
Before posting, please check:
h
Sent: Wednesday, March 28, 2001 15:53
To: Alberni-dot-Net
Cc: [EMAIL PROTECTED]
Subject: RE: Complex SQL Query
Aaron,
Are you inserting both values at once? Or inserting the startdate first,
then
updating the stopdate later. You may or may not be able to do this in one
query.
To determine how much ti
I have been trying for the last while to come up with a query that will do
the following:
Say I have table with these records:
StartDate StopDate
---
2001-01-23 23:43:12 2001-01-24 04:29:12
2001-01-24 15:24:00 2001-01-26 01:15
