minimum: -999.99 maximum: +999.99 It takes M+2 bytes to store. Here M i

If you specify the data type as DECIMAL (5,2), what?s the
range of values that can go in this table?

Question Posted / rajesh kumar

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

Please Help Members By Posting Answers For Below Questions

Is microsoft sql same as mysql?

929

What is the difference between char and varchar?

1095

Do I need to pay for mysql?

850

Can you shard mysql?

877

Does mysql automatically index foreign keys?

876

How do I start mysql in linux?

848

How does mysql store data?

879

How do I start mysql manually?

865

How do I start mysql in mysql workbench?

891

How do I fix a crashed mysql database?

900

Can I copy mysql data directory?

873

What are the technical specifications of mysql?

1088

What is the data type for file in mysql?

927

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1081

Is sql and mysql same?

873