1SELECT @@global.innodb_default_row_format; 2@@global.innodb_default_row_format 3dynamic 4SET GLOBAL innodb_default_row_format = 'redundant'; 5SELECT @@global.innodb_default_row_format; 6@@global.innodb_default_row_format 7redundant 8SET GLOBAL innodb_default_row_format = 'dynamic'; 9SELECT @@global.innodb_default_row_format; 10@@global.innodb_default_row_format 11dynamic 12SET GLOBAL innodb_default_row_format = 'compact'; 13SELECT @@global.innodb_default_row_format; 14@@global.innodb_default_row_format 15compact 16SET GLOBAL innodb_default_row_format = 'compressed'; 17ERROR 42000: Variable 'innodb_default_row_format' can't be set to the value of 'compressed' 18SELECT @@global.innodb_default_row_format; 19@@global.innodb_default_row_format 20compact 21SET GLOBAL innodb_default_row_format = 'foobar'; 22ERROR 42000: Variable 'innodb_default_row_format' can't be set to the value of 'foobar' 23SELECT @@global.innodb_default_row_format; 24@@global.innodb_default_row_format 25compact 26SET GLOBAL innodb_default_row_format = 0; 27SELECT @@global.innodb_default_row_format; 28@@global.innodb_default_row_format 29redundant 30SET GLOBAL innodb_default_row_format = 1; 31SELECT @@global.innodb_default_row_format; 32@@global.innodb_default_row_format 33compact 34SET GLOBAL innodb_default_row_format = 2; 35SELECT @@global.innodb_default_row_format; 36@@global.innodb_default_row_format 37dynamic 38SET GLOBAL innodb_default_row_format = 3; 39ERROR 42000: Variable 'innodb_default_row_format' can't be set to the value of '3' 40SELECT @@global.innodb_default_row_format; 41@@global.innodb_default_row_format 42dynamic 43SET GLOBAL innodb_default_row_format = 123; 44ERROR 42000: Variable 'innodb_default_row_format' can't be set to the value of '123' 45SELECT @@global.innodb_default_row_format; 46@@global.innodb_default_row_format 47dynamic 48SET GLOBAL innodb_default_row_format = default; 49