MySQL Forums
Forum List  »  General

SQL Syntax for Multiplication
Posted by: Reuben Bezzina
Date: December 12, 2016 08:30AM

Hi, I have a table called 'Employee' with rows: Name, Surname, Monthly_Wage and Yearly_Wage. Now I need to insert data in this table using SQL statement. I also need to make the Yearly_Wage to do Monthly_Wage * 12.

Can you please tell me how this can be done?

Thanks.

Options: ReplyQuote


Subject
Written By
Posted
SQL Syntax for Multiplication
December 12, 2016 08:30AM


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.