Re: mysql sql question

2004-07-07 Thread SGreen
| | cc: | | Fax to: | |

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 in

Re: mysql sql question

2004-07-04 Thread John Hicks
ob... You are correct. 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 s

RE: mysql sql question

2004-07-04 Thread bruce
al 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 and collegeid'. The select says "get two columns, 'to

RE: mysql sql question

2004-07-04 Thread bruce
of the insert be derived from.. -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 c

RE: mysql sql question

2004-07-04 Thread Quentin Bennett
mysql> insert into dept (name,collegeid) -> 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 wor

RE: mysql sql question

2004-07-04 Thread Quentin Bennett
to:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 10:41 a.m. To: 'Emmett Bishop'; [EMAIL PROTECTED] Subject: RE: mysql sql question i created the following as a simple test... mysql> describe test; +---+--+--+-+-+

RE: mysql sql question

2004-07-04 Thread bruce
7;t it be possible to extend the basic approach to multiple tables, using FROM tbl1, 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 s

RE: mysql sql question

2004-07-04 Thread bruce
me = $ownername; -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,

RE: mysql sql question

2004-07-04 Thread bruce
riginal Message- 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 ow

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

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

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 wou

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. H

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 (ID

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 (ID

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