:
|
| Fax to:
|
| Subject: Re: mysql sql question
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
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
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
-
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
-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
, 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
: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
)
- 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
-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
: 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
.
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
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.
* 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
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
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
-
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