Re: C API

2003-06-04 Thread vze2spjf
From: [EMAIL PROTECTED] Date: 2003/06/03 Tue AM 11:45:31 CDT To: [EMAIL PROTECTED] Subject: C API Hello, I'm trying to code a small C client, under windows, with bloddshed Dev-C++, and i always get an error. /* Code */ #include conio.h #include stdarg.h #include winsock.h

Re: URGENT: Problems compiling mysql 3 and 4 on IRIX indy 6.5 IP22 mips

2003-06-05 Thread vze2spjf
Look at http://gcc.gnu.org/ml/gcc-bugs/2000-11/msg00293.html (I don't know anything about this, but that page seems very relevant.) -S From: Jason Buchanan [EMAIL PROTECTED] Date: 2003/06/04 Wed AM 08:22:29 CDT To: [EMAIL PROTECTED] Subject: URGENT: Problems compiling mysql 3 and 4 on

Re: Database Design Question...

2003-06-18 Thread vze2spjf
[snip] Let's say that I have users Mary, Joe, Frank, and Dan. I also have servers panther, cheetah, jaguar and lion. The data for each account that I want to maintain is UID, GID, home directory, and default shell. In designing a table or tables to handle this example what can I make as a

Re: Select with join query question

2003-07-28 Thread vze2spjf
From: Richard Bolen [EMAIL PROTECTED] Date: 2003/07/28 Mon PM 01:37:27 CDT To: [EMAIL PROTECTED] Subject: Select with join query question I'm trying to write a select query that involves 2 tables. One table (Submissions) has a one to many relationship with the other table (Jobs). I'm

Re: Re: Select with join query question

2003-07-28 Thread vze2spjf
[snip] Rich's solution, which I edited out, was a good one. But, if you really want to do it with a single JOIN, try this: select j.* FROM Jobs j LEFT JOIN Submissions s ON j.jobid = s.jobid GROUP BY /* all selected columns */ HAVING min(abs(s.status - 1)) 0 I leave it as an exercise

Re: RE: Books advice

2003-08-04 Thread vze2spjf
Paul's book is long, but like good code, it's modular, so the length isn't an issue. From: Jeffery C. Baldwin [EMAIL PROTECTED] Date: 2003/08/04 Mon AM 11:14:29 CDT To: 'Paul DuBois' [EMAIL PROTECTED], 'Asif Iqbal' [EMAIL PROTECTED], 'Ralph Guzman' [EMAIL PROTECTED] CC: 'Fawad

Re: Fwd: different between index and key when create table

2003-09-02 Thread vze2spjf
From: Vivian Wang [EMAIL PROTECTED] Date: 2003/09/02 Tue PM 02:16:26 CDT To: [EMAIL PROTECTED] Subject: Fwd: different between index and key when create table mysql: Can anyone tell me what is different between index and key when creating table? like this situation: create table

Re: Retrieving info from a Joined column

2003-11-28 Thread vze2spjf
From: Bruce Therrien [EMAIL PROTECTED] Date: 2003/11/28 Fri PM 01:42:14 CST To: [EMAIL PROTECTED] Subject: Retrieving info from a Joined column We ahve a column in our table that has new info added each time using a JOIN function. The data is separated using a : separator. This

Re: Please analyze my project table design

2003-11-28 Thread vze2spjf
From: Paul Fine [EMAIL PROTECTED] Date: 2003/11/28 Fri AM 11:14:25 CST To: [EMAIL PROTECTED] Subject: Please analyze my project table design Greetings, my hands on school project is a small real estate database. I am using MySQL 3.23 without InnoDB, but would like to migrate to 4.x

Re: Re: Please analyze my project table design

2003-11-28 Thread vze2spjf
From: David T-G [EMAIL PROTECTED] Date: 2003/11/28 Fri PM 03:49:17 CST To: mysql users [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Please analyze my project table design -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! ...and then [EMAIL PROTECTED] said... % ... % I

Re: Re[3]: Please analyze my project table design

2003-11-28 Thread vze2spjf
From: Stefan Hinz [EMAIL PROTECTED] Date: 2003/11/28 Fri PM 04:45:24 CST To: [EMAIL PROTECTED] CC: David T-G [EMAIL PROTECTED], mysql users [EMAIL PROTECTED] Subject: Re[3]: Please analyze my project table design % I don't know of a DB theory rule that says it's a bad idea to have the

Re: RE: Please analyze my project table design

2003-11-28 Thread vze2spjf
From: Paul F [EMAIL PROTECTED] Date: 2003/11/28 Fri PM 04:35:04 CST To: 'mysql users' [EMAIL PROTECTED] Subject: 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