MySQL Forums
Forum List  »  Newbie

Re: get numbers only question
Posted by: Peter Brawley
Date: July 20, 2014 11:45AM

If you often need to do arithmetic on employee_number values, they need to be numeric, eg decimal(8,3) for numbers up to 99999.999. If you only occasionally need to do arithmetic on them, you can query them as if they were numbers by appending +0 to the column name.

Options: ReplyQuote


Subject
Written By
Posted
July 20, 2014 02:16AM
Re: get numbers only question
July 20, 2014 11:45AM


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.