Re: mysql sql question

2004-07-07 Thread SGreen
: | | Fax to: | | Subject: Re: mysql sql question

Re: mysql sql question

2004-07-05 Thread Peter Brawley
Bruce, i have two hypothetical tables create table owner ( - name char(20) , - ownerid int(10) auto_increment primary key); create table dog ( - name char(20) , - ownerid int(10), - dogid int(10) auto_increment primary key); i'm curious as to how i'd go about inserting a

Re: mysql sql question

2004-07-04 Thread Paul DuBois
At 12:54 -0700 7/4/04, bruce wrote: hi... i have two hypothetical tables create table owner ( - name char(20) , - ownerid int(10) auto_increment primary key); create table dog ( - name char(20) , - ownerid int(10), - dogid int(10) auto_increment primary key); i'm curious as to

RE: mysql sql question

2004-07-04 Thread bruce
- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 12:59 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mysql sql question At 12:54 -0700 7/4/04, bruce wrote: hi... i have two hypothetical tables create table owner ( - name char(20) , - ownerid int(10

RE: mysql sql question

2004-07-04 Thread bruce
-Original Message- From: Emmett Bishop [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 12:59 PM To: [EMAIL PROTECTED] Subject: Re: mysql sql question Bruce, what you want it the insert into ... select statement. It's like this: insert into dog (name, ownerid) select name

RE: mysql sql question

2004-07-04 Thread bruce
, tbl2, tbl3.. - -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 3:26 PM To: 'Emmett Bishop'; [EMAIL PROTECTED] Subject: RE: mysql sql question what you provided would almost do it... but i want to insert into the dog table

RE: mysql sql question

2004-07-04 Thread Quentin Bennett
:41 a.m. To: 'Emmett Bishop'; [EMAIL PROTECTED] Subject: RE: mysql sql question i created the following as a simple test... mysql describe test; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra

RE: mysql sql question

2004-07-04 Thread Quentin Bennett
) - select name, id from test where name=sammy; -Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 10:50 a.m. To: Quentin Bennett Subject: RE: mysql sql question i can't see how this would work at all... unless you're saying the select will return tom

RE: mysql sql question

2004-07-04 Thread bruce
-Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 3:41 PM To: [EMAIL PROTECTED]; Emmett Bishop; [EMAIL PROTECTED] Subject: RE: mysql sql question Hi, You've already specified some values, so you can't then add a 'select' clause as well. Try mysql

RE: mysql sql question

2004-07-04 Thread bruce
: Quentin Bennett [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 3:49 PM To: [EMAIL PROTECTED] Cc: MySQL (E-mail) Subject: RE: mysql sql question Hi, The insert says 'insert data in to two columns, name and collegeid'. The select says get two columns, 'tom' and id - 'tom' is a fixed value

Re: mysql sql question

2004-07-04 Thread John Hicks
. Good luck, --John thanks -bruce -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED] Sent: Sunday, July 04, 2004 3:49 PM To: [EMAIL PROTECTED] Cc: MySQL (E-mail) Subject: RE: mysql sql question Hi, The insert says 'insert data in to two columns, name