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

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 i

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.

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 m

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.

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:

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]> >

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

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

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

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

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 > #include > #include "winsock.h" > #i