When does using multiple databases make sense?

2004-01-07 Thread Paul F
Greetings, I am wandering under what circumstances it is sensible/beneficial to use multiple databases for a single project, and why. The reason I ask is because I am re-developing an existing database with MySQL that someone else created with another engine (DBISAM) and chose to have 5 separate

RE: Please analyze my project table design

2003-11-28 Thread Paul F
Thanks guys. I thought that normalization would refer to redundant info not necessarily the same column names? I would further see the problem with the design if say phone_number in the agent table and lawyer table contained the same data, which of course they won't. I thought about the persons

RE: ODBC Encryption?

2003-10-23 Thread Paul F
Thanks. I was thinking about using stunnel. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, October 23, 2003 3:41 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: ODBC Encryption? What you've seen is what you get. None. Try tunneling

Cannot get Digest

2003-10-20 Thread Paul F
I seem to be unable to get this list in digest format :( I previously signed up for normal version. I have tried unsubscribing and re-subscribing with Digest - MIME instead and I keep getting the normal list (individual e-mails for every post!) Thanks for any help! -- MySQL General Mailing

ODBC Encryption?

2003-10-20 Thread Paul F
Greetings. Can anyone tell me what type of encryption is used when sending mysql username/password through ODBC. I see that the data and username are plaintext. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: What would be an efficient way to accomplish this ( Statistic s/Trends in a table?) Thanks!

2003-10-09 Thread Paul F
Thanks for your help, just what I needed. I will play around but if you have a chance and know how, how would I order the results by count? (ie. highest counts first..) -Original Message- From: Mike Knox [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 5:09 AM To: '[EMAIL

What would be an efficient way to accomplish this (Statistics/Trends in a table?) Thanks!

2003-10-07 Thread Paul F
I would appreciate any advice on this. PHP+MySQL snippets even better :P How can I do this: For example I have a table with a field FIRST_NAME I want to produce the statistics of how many identical FIRST_NAME entries there are in the table. Yes I could hard code queries to match a list of