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
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
(not
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
Hi all,
I'm designing a hosted application that many clients will access. I've
got all sites running off one PHP code base quite nicely, and now I'm
hoping to reduce the multiple databases down to just one shared DB.
(Note: at this stage, all accounts are fictional, so there's no legacy
data