tomipol's articles:

Items(1) /1

trigger to update the same table different row 6 147 (6/1/2012 3:13:41 PM) comp.databases.mysql Hi, i have table: id | data 1 | aa 2 | bb 1 | cc If i will update data in first row to 1 - abc i need to copy this value to 1 | cc so after update table should looks like this: 1 | abc 2 | bb... TomoT

tomipol's replies:

Items(1) /1

trigger to update the same table different row 6 147 (6/1/2012 3:13:41 PM) comp.databases.mysql Hi, i have table: id | data 1 | aa 2 | bb 1 | cc If i will update data in first row to 1 - abc i need to copy this value to 1 | cc so after update table should looks like this: 1 | abc 2 | bb... tomipol (2)