MySQL Forums
Forum List  »  Newbie

Data Types
Posted by: Arj Banner
Date: November 22, 2009 05:14AM

What would be the correct data types for the following types of data (I have put what I think would be best)...

* A transaction date (e.g. 2009-10-29) = DATE
* A transaction number (e.g. 1, 2 or 10988) = INT w/ Auto Increment
* An accounting code (e.g. 1099) = CHAR(4)
* A transaction amount (e.g. $1000) = DECIMAL

Do these look like the right choices for the date to go in them, and the queries that would be asked of them, (e.g. accounting and bookkeeping type queries)?

Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Data Types
November 22, 2009 05:14AM
November 22, 2009 06:30AM
November 22, 2009 10:27AM
November 22, 2009 10:26AM


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.