MYSQL Auto generated columns syntex
Budget: $30 – $250 USD
Need to write the expression that will auto generate 2 columns in a MYsql table.
table currently looks like photos below
i need to add 2 columns that are stored generated.
column 1 - needs to display the incremental change of data for the day. starting at zero and increasing with each time stamped entry.
column 2 needs to display the difference between itself and the previous entry
they need to use column GL_CB as the data along with the timestamp
GL_CB is a counter that never stops counting wigets and we need to see wigits per line item and total wigets per day
column 1 ( incremental) could be calculated by taking the data from the Last entry from Yesterday and deducting that from the current timestamp OR i can start each day and simply add all of the results of Column 2 to arrive at the same numbers
table currently looks like photos below
i need to add 2 columns that are stored generated.
column 1 - needs to display the incremental change of data for the day. starting at zero and increasing with each time stamped entry.
column 2 needs to display the difference between itself and the previous entry
they need to use column GL_CB as the data along with the timestamp
GL_CB is a counter that never stops counting wigets and we need to see wigits per line item and total wigets per day
column 1 ( incremental) could be calculated by taking the data from the Last entry from Yesterday and deducting that from the current timestamp OR i can start each day and simply add all of the results of Column 2 to arrive at the same numbers