title: how to add data to a column table from mysql function
body: <p>I want to add the return values of a function to a table's column 
  It should all be in mysql no php 
  I have a table with price,tax and price with tax I implemented the function to calculate the price with tax but I don't know how to add those values to that table</p>
  
  <pre><code>CREATE TABLE Faturat
  (Fatura_ID varchar(10),
  price real
  ,tax real,
  CmimiMeTvsh real as (total(price,tax)),
  Data varchar(20),
  PRIMARY KEY (Fatura_ID));
  
  drop function if exists  total;                             
  delimiter //
  create function total( x real, y real)
  returns real
  begin
     return X+x*Y/100;
     select fatura_id,total(price,tax)
     from FATURAT;
  
  
  CREATE TRIGGER trgAuditOnInsertPunetoret AFTER INSERT ON faturat
  FOR EACH ROW   
  BEGIN     
  INSERT INTO faturat
  VALUES (fatura_id,price,tax,total(price,Tax),data);
  
  end ;
  delimiter //
  </code></pre>