Hi,
I need to copy data from one table into the same table but with some different values as well. Also i'm having trouble since row_timestamp cannot be null.
Example: Table has columns A, A1, A2, A3, A4, A5
I need columns A1, A2, A3 to be copied and i also want to insert new values into A4 and A5.
How can I do this?
So far i have:
----
insert into Table (A1, A2, A3)
select A1, A2, A3 from Table
where A=apple
set A=pear,
A4='XXX',
A5='YYY'
row_timestamp = default
------
I need to copy data from one table into the same table but with some different values as well. Also i'm having trouble since row_timestamp cannot be null.
Example: Table has columns A, A1, A2, A3, A4, A5
I need columns A1, A2, A3 to be copied and i also want to insert new values into A4 and A5.
How can I do this?
So far i have:
----
insert into Table (A1, A2, A3)
select A1, A2, A3 from Table
where A=apple
set A=pear,
A4='XXX',
A5='YYY'
row_timestamp = default
------