Hi Ashwin!
> Is there any way to select & insert at the same time? What I want to do
http://www.mysql.com/doc/I/N/INSERT_SELECT.html
> 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?
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
