MySQL Forums
Forum List  »  Triggers

Re: Need help with a simple trigger
Posted by: Darren White
Date: January 20, 2012 06:24AM

I'll describe what I'm trying to do.

I have a table with perhaps 20 columns and 50 rows. The position of data is fixed and continually updates, i.e. table doesn't grow in size.

I want to log particular columns of data and so set up a new table2 where the columns represent the rows of the first table. So table1.row1 = table2.col1

For example, in the first table I may have a column "temperature", where the 50 rows are temperature readouts from 50 different sensors. I want to log the temperature over time for particular sensors. So my log table for temperature would have columns sensor1, sensor2, sensor3....sensor50.

Options: ReplyQuote

Written By
January 20, 2012 05:06AM
January 20, 2012 05:24AM
January 20, 2012 05:45AM
Re: Need help with a simple trigger
January 20, 2012 06:24AM
January 27, 2012 01:38PM
February 23, 2012 02:50PM
February 23, 2012 08:05PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.