RE: MySQL: my.cnf in Windows 2000

2001-07-17 Thread Dinkler, Fred
want to do. Anyway, the ini file work fine. Fred -Original Message- From: Mike Baranski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 4:28 PM To: Dinkler, Fred; Philip Daggett Cc: Mysql List (E-mail) Subject: Re: MySQL: my.cnf in Windows 2000 Just go (in windows explorer) t

RE: MySQL: my.cnf in Windows 2000

2001-07-17 Thread Dinkler, Fred
Problem under Win2000 with any file having a .cnf extension. That extension is reserved by Win2000 as a system (Speed Dial) file and will automatically hide the extension from you. You can't search for it and it will not show it. IF you create a my.cnf file, it appears as "my" I use 'WINNT\my

RE: Referential Integrity

2001-07-11 Thread Dinkler, Fred
In my experience, most "large corporate" databases are not implemented with RI enabled. The RI constraints often interfere with user workflows (incomplete data or data entered out of sequence) and adds processing overhead that adds up to serious cycle drain for lengthy runs. \\|//

RE: Referential Integrity

2001-07-11 Thread Dinkler, Fred
One real-world example: RBOC changes an area code for certain prefixes. If you haven't decomposed the phone number into separate fields, e.g. your phone number is a single field ala "--" you have a really interesting job ahead of you to accomplish the update. Especially if you are a telecom

RE: unix_timestamp doesn't understand year 2038

2001-07-11 Thread Dinkler, Fred
UNIX version of Y2K problem... \\|// (@ @) ---oOO---(_)---OOo || | Fred Dinkler | | SVP Technology | | DFII Atlanta | | Office: 01.770.596.1443| || -

RE: Join syntax

2001-07-11 Thread Dinkler, Fred
Rodney - You can't execute a query across two connections simultaneously. If you must split the tables between two hosts, network then together at the file system level so that the database directories are accessible by one instance of MySQL. Then connect and query that instance...