Hello John,
Yes you can have it both way.
However, for the sake of simplicity I personally will go with one database and
3 tables.
Also, if the 3 tables share the same structure, I will go with only one table.
That means with a single connection you are able to search the information.
This scheme also simplifies your insert/update/delete since you always work
with only one database and probably one table.
Finally, for sure you can have concurrent connections to multiple tables in
one database as well as concurrent connections to multiple tables in
multiples databases. As an example some Internet Service Provider (ISP)
provides MySQL as a service to some of their customers and each of these
customers have their own database that contains their own tables.
Hum! another reason to use only one database in your case!
Regards,
Bernard
On Saturday 04 December 2004 18:55, John Fitzsimons wrote:
> Suppose I have three book databases that I want to keep separate as
> far as searching is concerned. Am I right in thinking that I could
> have eg. one database with three different tables or three databases
> with one table each ?
>
> If so then what are the reasons why one would choose one ahead of the
> other ?
>
> Can one have concurrent connections to multiple tables in one database
> on a MySQL server ? Concurrent connections to multiple tables in
> multiple databases on a MySQL server ?
>
> Any input appreciated.
>
> Regards, John.
