4 messages in com.mysql.lists.win32More "newbie" questions.
FromSent OnAttachments
John Fitzsimons04 Dec 2004 15:55 
Bernard Clement04 Dec 2004 17:01 
John Fitzsimons04 Dec 2004 23:11 
Marcel Forget05 Dec 2004 07:30 
Subject:More "newbie" questions.
From:John Fitzsimons (joh@net2000.com.au)
Date:12/04/2004 03:55:30 PM
List:com.mysql.lists.win32

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.