Shawn,
I'm not certain you are saying otherwise (or simply recommending against
it), but I want to point out that mysql can handle separate auto_increment
series for each client_id with MyISAM or BDB tables. You set up the table
like this:
CREATE TABLE messages (client_id UNSIGNED INT NOT NU
Thank you. Michael. I do remember reading that (now that you got me to
re-read that part of the manual. "The manual is your friend. The manual is
your friend. The...") but I have never used that feature so it didn't come
to mind as I was writing. Apologies to all for not pre-checking myself
(no
No, you aren't asking too much of MySQL in most of your questions but in
another question, you are. Let me explain.
PRIMARY KEYs are nothing more than UNIQUE INDEXES on a table. How many
columns it takes to uniquely identify any row of information depends on
your data structure. Many people use
