I am not changing the ordering, but i do not want to copy the primary key field since it is auto increment (I neglected too mention that before, sorry). On 10/16/07, Vitali Lovich <[EMAIL PROTECTED]> wrote: > Well, you don't have to list the columns if you're not changing the > ordering. > > INSERT INTO table1 SELECT * FROM table2; > > Rich Rattanni wrote: > > I have two tables in a database with exactly the same schema > > (idNum PRIMARY KEY, data1, data2) > > > > I want to copy all the records in table 2 to table 1, currently I am > > using the following statement: > > INSERT INTO table1 (data1, data2) SELECT data1, data2 FROM table2. > > > > Now this is just a simplified illustration, in my case I am copying > > about 10 columns over. I was wondering if there was a compact way to > > write the SQL statement, that copied the data over from one table to > > the other ignoring the primary key fields. I suspect there is not, > > but I figured it wouldnt hurt to ask. > > > > -- > > Thanks, > > Richard Rattanni > > > > ----------------------------------------------------------------------------- > > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > > > > > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > >
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------