Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4991

Warning: Creating default object from empty value in /www/htdocs/v030397/mysql-qotd/wp-content/plugins/sitepress-multilingual-cms/sitepress.class.php on line 4993
Question 6: Which is the highest value column n can store? – MySQL Question of the Day

Skip to content

Question 6: Which is the highest value column n can store?

4. February 2010
By urs in mysql questions

1 Comment

The following table was created:

create table dtest (n decimal(5,2),m decimal(7,2));

a) 99999.99
b) 65536
c) 2147483647
d) 999.99
 

[ Data Types (15%) - Numeric Data Types ]

 

Tags: , ,

Comment Feed

One Response

  1. urs — 5. February 2010 @ 00:17:33 —


    Answer:

    d

    5 digits altogether, 2 after the comma.

You must be logged in to post a comment.