Hi. I have something pretty simple to do. I have to tell MySQL to calculate a field as a function of another field. For instance, the user instert a value for field f1 and I want field f2 to be computed as 10*f1 or as a function of a field of a view. I tried looking up for this in the MySQL manual but I can't find it. Could someone please address me to the right place? I'm Italian so maybe I'm searching with wrong keywords. I found something useful here in these forums, but unfortunately it was for SQL Server.
Thanks to everyone.

why u dont use a store procedure if are using version 5.* and above.
eg.

create procedure ProcedureName(in Tfield1 int,in Tfield2 int)
begin
insert into tablename(field1,field2)values(TField1,Tfield2*10) ;
end