clone tableentry

[Anon]

Hi,

I have two tables, one for the actual use and one for backup.
My problem is, when I want to copy a specific row from one to the other table I have to read out the row and adding it to the other one.

Isn't there a function where I can specify both tables? Honestly I don't want to read the whole manual to search this function 😉

Thanks in advance.

[amcgrath]

why not just create a trigger to do that when u insert into the first table...?

[Anon]

The singles entrys are 'developed'. The user is asked to enter some text/integer --> stored in the first field then he has to enter some more --> stored in the next field. If he at any time cancels this process I would have a half entry in my backup table :\

And on the otherhand I have about 15k entrys in this table and the method I tried to read the originals out and then inserting them costs too much time...

[tomhath]

You mean something like:

insert into table2
select * from table1
where blah blah blah

by the way, reading the manual is not such a bad thing.

[amcgrath]

OK, well, why can't the user enter all of the data at once? (again, i mention the trigger advice above) plus, if you design it with the possibility of orphaned data, that may speak to a larger issue....

[Anon]

Ok, I guess you're right 🙂
I don't see any other possibility. Thanks 🙂

[Anon]

Yes exactly, but such a query dont work 🙁

And for the manual, I don't have the patience to read it all and most stuff I won't need in near future... I've searched for a function like that but wasn't succesfull. 🙁