Re: design a little inventory db
Posted by: Rick James
Date: December 01, 2014 09:27AM

DECIMAL(3,2) will hold the numbers you mentioned. MySQL will not "enforce" the "0.25 steps".

"cil", etc, should be kept in a separate column.

It sounds like you need one database (CREATE DATABASE) with at least one table (CREATE TABLE), which will contain several columns.

Options: ReplyQuote


Subject
Written By
Posted
November 30, 2014 11:34AM
Re: design a little inventory db
December 01, 2014 09:27AM
December 02, 2014 01:23AM
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.