Hi.
On Tue, Sep 25, 2001 at 08:39:01AM -0300, [EMAIL PROTECTED] wrote:
> Is there any way to select & insert at the same time?
Yes. Have a look at
INSERT ... SELECT
and
CREATE TABLE ... SELECT
in the manual.
Bye,
Benjamin.
> What I want to do
> is select say 10 out 13 field values from one table and dump it into
> another table. Would it be possible to do this via a select and an
> insert at the same time and how exactly would the sql statement look? OR
> do I have to write a script and store the values in an array and go from
> there? Also, is there any way without me creating new tables with all
> its fields all the time to copy over the fields from certain tables to
> new tables? That is copy over its attributes, etc.?
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
