|
| cc:
|
| Fax to:
|
|
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
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
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
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
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
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;
+---+--+--+-+-+
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
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,
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
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
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
* 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
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
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
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
-
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
17 matches
Mail list logo