res me to alter the application everytime I change the
table, which I don't always want to do.
> -Original Message-
> From: Henrik Schröder [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 29, 2004 3:07 PM
> To: 'Eric J. Janus'; 'MySQL'
> Subject: RE: IN
dd an appropriate
where-clause to the above statement.
/Henrik
-Original Message-
From: Eric J. Janus [mailto:[EMAIL PROTECTED]
Sent: den 29 mars 2004 21:28
To: Matt Chatterley; 'MySQL'
Subject: RE: INSERT ... SELECT question
Views would be nice. :)
That idea sounds like it
tterley [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 29, 2004 2:25 PM
> To: 'Eric J. Janus'; 'MySQL'
> Subject: RE: INSERT ... SELECT question
> Importance: Low
>
>
> Oh, if only there were views!! That would make this easy. Maybe soon
> (*please*). :
te
the query based on the table definition, but I was hoping that MySQL had
something built in to make this easier.
Thanks,
Eric
> -Original Message-
> From: Matt Chatterley [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 29, 2004 2:11 PM
> To: 'Eric J. Janus';
ion, but I was hoping that MySQL had
something built in to make this easier.
Thanks,
Eric
> -Original Message-
> From: Matt Chatterley [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 29, 2004 2:11 PM
> To: 'Eric J. Janus'; 'MySQL'
> Subject: RE: INSERT ..
Can you roughly outline the schema of the two tables?
If the key value doesn't have to match from the input to the final result,
you can always insert into a list of fields, skipping the auto_increment/key
column, and they will continue to be generated..
Assuming you have two tables with id_col,
I use this syntax but I have privilege problem.
Thenk you anyway
- Original Message -
From: "Nitin" <[EMAIL PROTECTED]>
To: "IEEIO AAOOCO" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, October 27, 2003 5:20 PM
Subject: Re: Insert ... Select
Nikos,
Yes. Use the following syntax:
INSERT INTO db_name.tbl_name (col, col, col) SELECT col, col, col FROM
db_name.tbl_name;
Regards,
Adam
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 9:58 AM
To: [EMAIL PROTECTED]
Subject: Insert
of course, the syntax is:
insert into db3.table2 (column list) select from db1.table1
for more information have a look at
http://www.mysql.com/doc/en/INSERT_SELECT.html
Enjoy
Nitin
- Original Message -
From: "ΝΙΚΟΣ ΓΑΤΣΗΣ" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, Octo
Try to look at page 442 to 446 of the mySQL manual, it may give some help
on your field creation using insert & select.
Regards,
Calvin Chin
[EMAIL PROTECTED]
Ipmuda Berhad - Building materials for tomorrow's world !
-Original Message-
From: "Marcus Young" <[EMAIL PROTECTED]>
To: <[EMA
At 8:44 PM -0500 9/9/01, Marcus Young wrote:
>Hi,
>
>I'm fairly new to MySQL. I'm trying to insert data into a table
>where one field is derived from a SELECT on another table (a key)
>and the other fields are defined directly (eg field_01="abcd") .
>The formats I have been trying don't appear
11 matches
Mail list logo