Re: [PHP] Update identical table

2002-09-29 Thread Justin French
on 30/09/02 8:09 AM, David Freeman ([EMAIL PROTECTED]) wrote: > What about getting rid of "tmp_data" completely and adding an extra > column to your "data" table. The extra column, say "approved" would act > as a flag that, if set (ie. "= 1") means that the data is confirmed and, > if not set, m

RE: [PHP] Update identical table

2002-09-29 Thread David Freeman
> I have 2 identical tables called "tmp_data" and "data". (on > the same mysql database). > What would be the simple and more convenient way to update > table "data" with a row from table "tmp_data". What about getting rid of "tmp_data" completely and adding an extra column to your "data"

RE: [PHP] Update identical table

2002-09-28 Thread John W. Holmes
> I have 2 identical tables called "tmp_data" and "data". (on the same mysql > database). > What would be the simple and more convenient way to update table "data" > with a row from table "tmp_data". > (something like select * from tmp_data and than update data ...). Why not have just one table w

Re: [PHP] Update identical table

2002-09-28 Thread Marek Kilimajer
INSERT INTO data SELECT * FROM tmp_data WHERE condition_definition Radu Manole wrote: >Hi guys, > >I have 2 identical tables called "tmp_data" and "data". (on the same mysql database). >What would be the simple and more convenient way to update table "data" with a row >from table "tmp_data". >(