MySQL Forums
Forum List  »  General

Re: SQL Syntax for Multiplication
Posted by: Peter Brawley
Date: December 12, 2016 12:15PM

> I also need to make the Yearly_Wage to do Monthly_Wage * 12.

Design mistake. Your yearly wage column is entirely redundant, and that's a no-no. Consider making it a derived column, or just a column in a View.

The multiplication operator is *. See the manual page for operators.

Options: ReplyQuote


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


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.