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

What are the types of queries?

934

Why mysql is open source?

894

Which datatype is used for email in mysql?

939

How to create a trigger in mysql?

917

What is the default password for mysql?

877

How do I disable mysql?

917

Can mysql store files?

914

What is max connections in mysql?

903

what is the procedure to configure the application of mysql?

1016

What is difference between mysql and mysql workbench?

921

How many primary keys can be there in a table?

970

How many rows can a mysql table hold?

993

What is 'mysqld'?

921

What is ISAM?

1090

What is difference between microsoft sql and mysql?

963