megz90 Posted March 31, 2008 Share Posted March 31, 2008 im very confused. i have a mysql table the firld type decimal(5,2) Unsigned not null ..... does this mean i can have 5 digits and 2 after the decimal point or max 5 digits (3 before and 2 after point) ive read 3 different websites and now im confused cus they have all said different things. i think my confusion is because of the changes in different mysql versions... im using version: 5.0.45 thanks anyone who knows. Quote Link to comment Share on other sites More sharing options...
AndyB Posted March 31, 2008 Share Posted March 31, 2008 Trust the documentation: http://dev.mysql.com/doc/refman/5.0/en/precision-math-decimal-changes.html 5,2 = five digits of which two are after the decimal Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.