quot;Brad Tilley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, April 03, 2004 3:00 PM
Subject: two tables with same field names into one table
> Hello,
>
> I am a mysql newbie. Recently, I've been given the task of joining two
tables
> within the sam
* Brad Tilley
> > create table computers
> > select * from desktops, laptops where
> > desktops.field_1 = laptops.field_1
> > ...
> Thank you Matt, I am using Mysql 3.23.58 on RH Linux 9... UNION isn't
> supported on this version.
You can do it in two steps:
CREATE TABLE computers SELECT * FR
>
> Thanks,
>
> Matt
>
>
> -Original Message-
> From: Brad Tilley [mailto:[EMAIL PROTECTED]
> Sent: 03 April 2004 21:00
> To: [EMAIL PROTECTED]
> Subject: two tables with same field names into one table
>
> Hello,
>
> I am a mysql newbie. R
u can just
do one INSERT into the new table, using a select similar to the one above.
Thanks,
Matt
-Original Message-
From: Brad Tilley [mailto:[EMAIL PROTECTED]
Sent: 03 April 2004 21:00
To: [EMAIL PROTECTED]
Subject: two tables with same field names into one table
Hello,
I am a my
Hello,
I am a mysql newbie. Recently, I've been given the task of joining two tables
within the same DB into one table. Currently, the tables are named 'desktops'
and 'laptops'... ultimately, I would like one table named 'computers' Both
tables have the exact same fields... they fields even hav
