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

mysql sql question

2004-07-04 Thread bruce
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 how i'd go about inserting a name

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

newbie mysql-SQL question

2002-07-06 Thread Laszlo G. Szijarto
Thank you in advance for your help. I'm trying to run two tables with identical table structures into a single continuous resultset. To simpify, I have one table with columns ID int and NAME varchar(32) and another table2 with columsn ID int and NAME varchar(32), and each table has 100 items.

Re: newbie mysql-SQL question

2002-07-06 Thread Roger Baklund
* Laszlo G. Szijarto I'm trying to run two tables with identical table structures into a single continuous resultset. To simpify, I have one table with columns ID int and NAME varchar(32) and another table2 with columsn ID int and NAME varchar(32), and each table has 100 items. How would I

MySQL SQL question

2002-02-12 Thread Mike McLagan
Hello, I hope this isn't too far afield of the list discussions but here goes. I'm trying to fashion a query against a MySQL database. There are three tables that are relevant. They are: listing (ID, OfficeID, CatID, SubID, Visible, Deleted) category (ID, Name) subcategory

MySQL SQL question

2002-02-08 Thread Mike McLagan
Hello, I hope this isn't too far afield of the list discussions but here goes. I'm trying to fashion a query against a MySQL database. There are three tables that are relevant. They are: listing (ID, OfficeID, CatID, SubID, Visible, Deleted) category (ID, Name) subcategory

a mysql SQL question

2001-03-05 Thread christopher sagayam
a mysql SQL question - I am programming a TV guide script and I am getting stuck 1) Admin must be able to add tv listings to a database using a form at http://1001cgi.hypermart.net/project1/admin2.html Please IGNORE all the form fields above "Start date - (mm/dd