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
How do I delete a mysql user?
What are the applications required to support mysql?
What is dirty read and phantom read?
Can we rename database in mysql?
How to dump a table to a file with 'mysqldump'?
What do you understand by mysql terminal?
What is mysql primary key?
what is constraints? Also explain the different types of constraints?
Does adding an index lock a table?
What is the data type for image?
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
What are the security alerts while using mysql?
how to dump all databases for backup. Backup file is sql commands to recreate all db's.
What is schema in mysql?
What is the difference between heap table and temporary table?