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 16: Which row_format does the following table have? – MySQL Question of the Day

Skip to content

Question 16: Which row_format does the following table have?

12. February 2010
By urs in mysql questions

1 Comment

 

CREATE TABLE `rftst` (
  `a` char(8) default NULL,
  `b` int(11) NOT NULL auto_increment,
  `c` decimal(10,2) default NULL,
  PRIMARY KEY  (`b`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

a) Fixed
b) Dynamic
c) Compact
d) Redundant

 
[ Tables and Indexes (15%) - Table Properties ]
 

Tags: , ,

Comment Feed

One Response

  1. urs — 12. February 2010 @ 19:13:25 —


    Answer:

    a

    That’s because all columns have a constant length.
    If you’d add for example a varchar field, then the rowtype changes to dynamic.
    c and d are innodb row-formats.

You must be logged in to post a comment.