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


Subject
Views
Written By
Posted
2639
January 20, 2012 05:06AM
1450
January 20, 2012 05:24AM
1209
January 20, 2012 05:45AM
Re: Need help with a simple trigger
1278
January 20, 2012 06:24AM
1317
January 27, 2012 01:38PM
1174
February 23, 2012 02:50PM
1162
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.