Re: design a little inventory db
Posted by: Rick James
Date: December 03, 2014 12:49AM

The "(2)" in INT(2) does not mean anything. Perhaps you wanted TINYINT UNSIGNED ?

Normalizing DECIMAL(5,2) to an INT is replacing one 4-byte number with another. I would not do that; simply put the DECIMAL in the table that needs it.

Options: ReplyQuote


Subject
Written By
Posted
November 30, 2014 11:34AM
December 01, 2014 09:27AM
December 02, 2014 01:23AM
Re: design a little inventory db
December 03, 2014 12:49AM


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.