The reason i am using views is that these tables change very often so if i create the temp table, i do not know if it will be updated after the original table is updated
On Mon, 2006-03-06 at 07:56 -0600, Jay Sprenkle wrote: > > Can anyone help me with creating temporary tables in place of the views, > > which are available during runtime, which have the same fields and data > > as my view such that when one table is updated, the results are appended > > to the temporary table > > Why not just insert the content of the view into the temp table? > > insert into tmp_view_1 > select * from view_1