Andy Sy a écrit :
In MySQL,
I want to use an auto-incrementing value that works
across multiple tables. For example I have 3 tables
forumA, forumB, forumC, each of which has a primary
key field called 'msgnum'. However, if I declare
'msgnum' auto_increment, 'msgnum' will not be
unique
In MySQL,
I want to use an auto-incrementing value that works
across multiple tables. For example I have 3 tables
forumA, forumB, forumC, each of which has a primary
key field called 'msgnum'. However, if I declare
'msgnum' auto_increment, 'msgnum' will not be
unique across the 3 tables.
In MySQL,
I want to use an auto-incrementing value that works
across multiple tables. For example I have 3 tables
forumA, forumB, forumC, each of which has a primary
key field called 'msgnum'. However, if I declare
'msgnum' auto_increment, 'msgnum' will not be
unique across the 3 tables.
Andy
2) Locks are by thread. If thread dies, so does
it's lock.
David
-Original Message-
From: Andy Sy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 12:03 PM
To: [EMAIL PROTECTED]
Subject: Auto-increment across multiple tables / Atomicity of update
statements