When does using multiple databases make sense?
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 databases used by one application. And yes, I do mean databases not tables LOL. Thanks for any advice! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Please analyze my project table design
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 table instead however you might notice that there are some columns that each do not have. Ie. home and work numbers for vendors and purchasers, firm for lawyers etc. Also I am expecting several columns to be NULL values for vendors and purchasers but not the other persons. I am very concerned with how I have setup the PK/FK/indices! Thanks guys! The repeated column names for example phone_number -Original Message- From: David T-G [mailto:[EMAIL PROTECTED] Sent: Friday, November 28, 2003 3:49 PM To: mysql users Cc: [EMAIL PROTECTED] Subject: Re: Please analyze my project table design -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! ...and then [EMAIL PROTECTED] said... % ... % I don't know of a DB theory rule that says it's a bad idea to have the same columns in many tables, but it might make the design more compact to take the common stuff and put it into one table. Oh, there is, indeed. CF normalization :-) HTH HAND good luck Paul :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE/x8LcGb7uCXufRwARAq2vAKCDgl6tAoZyQMxRcuweK4fPFO8flQCfT1QU pJXdxLO02cnospbngiqMqzI= =eKBn -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ODBC Encryption?
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 through SSH. Try this link to learn more: http://www.cs.kuleuven.ac.be/system/security/ssh/tunnel.shtml -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot get Digest
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 List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ODBC Encryption?
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:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What would be an efficient way to accomplish this ( Statistic s/Trends in a table?) Thanks!
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 PROTECTED]'; [EMAIL PROTECTED] Subject: RE: What would be an efficient way to accomplish this ( Statistic s/Trends in a table?) Thanks! Paul How about select FIRST_NAME, count(*) from a table group by FIRSTNAME having count(FIRST_NAME) 1 Mike -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What would be an efficient way to accomplish this (Statistics/Trends in a table?) Thanks!
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 predetermined entries (ie., knowing that there are common names like Paul, Bob and John) and do a count on each match but this will not suffice because in this example it will not account for say occurrences of the first name Xanther, LOL. Anyway... I had a nap and am back before I clicked send. During my nap I dreamed up something like selecting all FIRST_NAME ordered by same, and them some kind of script to do counts. Any other/further suggestions appreciated. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]