Hi,
I don't know if this is possible ( my experience with SQL is very short)
but I need to update table A from table B but saving the "Old values"
from certain columns into table C.
In other words I have 3 tables A,B,C.
Table A is going to be updated with values from table B, but
I have to keep track of these changes made to table A into table C.
By tracking I mean that any row changed on A must be saved into table C
( actually not the whole row but certain columns)
for example,
Update tableA
inner join tableB on ( id_tableA = id_tableB )
set tableA.col1 = tableB.col1,
etc..,
etc
But when tableA.col1 is changed I would like to have the original
value from id_tableA and col1 INSERTED into tableC as a new row.
Is it posible to do that at the same time?
I mean without creating a temporary table first then updating tableA
and atfer that using the temporary table to insert the new records into
tableC ?
Thank you
And forgive me if I couldn't make myself clear
Mauricio
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
