If you specify the data type as DECIMAL (5,2), what?s the
range of values that can go in this table?
Answer Posted / rajesh kumar
minimum: -999.99
maximum: +999.99
It takes M+2 bytes to store. Here M is 5 and two extra byte
for storing sign & decimal.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
Is mysql written in c?
What is mysql root?
Tell us something about heap tables?
What is the default port for mysql and how it can change?
What is unsigned int in mysql?
What are the advantages of mysql in comparison to oracle?
how to add a new column to an existing table?
change column name and make a unique column so we get no dupes.
In which language mysql has been written?
What is memory table in mysql?
How many rows mysql can handle?
What are the differences between char and varchar?
What is general log in mysql?
How can you validate emails using a single query?
How does mysql clustering work?