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 is text?

974

What are mysql functions?

951

How do I add a column to a table in mysql?

917

State the differences between mongodb and mysql.

1183

How to use regular expression in pattern match conditions?

954

What is the role of a limit in a mysql query?

1009

How to create table with same structure of student table in mysql?

951

How do you create a primary key?

1012

Does uninstalling mysql delete database?

1028

What are the advantages/disadvantages of mysql and php?

964

Can mysql function return a table?

1098

How do you backup a database in mysql?

1073

How do I tune a mysql query?

896

What are the technical specifications of mysql?

1165

How to use like conditions?

987