mysql - calculated column or stored procedure or just php function needed? -

I have an order table in the MySQL database, which has field / column, which stores the timestamp of the date of the order is.

I need to calculate when the order should be sent. I could possibly understand that how to write the function to calculate the date of the ship and calls whenever it is needed, but I think it can not be ensured that this shippard is a form of a counting column Understand in

said, I have never used any stored procedure or have created a calculated field. Later I think that would be best, but not sure again. I used to use FMP in calculating every time but I got away from that program.

I have to do it as one, it is basically a statement where a result column ship Date is You can also add other relevant columns. Any app with access to the database can access the same view of the normal table.

If your table looks like this:

  table order (id INTEGER PRIMARY KEY AUTO_INCREMENT, order_data DATETIME);  

and you always send it after 3 days, you can use it:

  select view ID_view ID, order_date, order_data + interval 3 days Create Ship_date as the order;  

Selection statements can be made as complicated as necessary. Then, you read order_view in any application, as if it was a simple table.