Re: How can I copy rows into same table?

From: Bricklen <bricklen-rem_at_yahoo.comz>
Date: Tue, 10 Feb 2004 17:17:30 GMT
Message-ID: <Km8Wb.28707$QX4.20413@clgrps13>

Bricklen wrote:

>> Andrew Strader wrote:

> Oops, appeared to have missed the title of your email!
>
> describe the structure of your table: you have a primary key etc
hit enter before I finished:

are you able to plunk in a query like

insert into <table> select 'new_id','some new data',... from t where store_id='999'; Received on Tue Feb 10 2004 - 11:17:30 CST