temporary tables question

[knickerlas]

Hi
I want to use a temporary table to allow a user to update and edit it's contents and then, when happy, swap it with the original.

How do I transform the temp into the original?

Thanks

Nick

[toma42]

Just use a transaction to do this...that's what they are for.

[knickerlas]

I dont think MySQL supports them.
Any other suggestions?

Nick

[kparker]

You could have some kind of status/generation column, that's set to one value for editing, and another for displaying. Thus you get all the rows together in one grand unified table, but the normal display routines ask for only those rows with 'generation = 0' or some other similar scheme.

[knickerlas]

Certainly seems to be the general consensus!

Cheers

Nick

[[deleted]]

I'd like to see you do that over a web-page.

[[deleted]]

Actually it does.