1install soname 'ha_example'; 2set sql_mode='ignore_bad_table_options'; 3create table t1 ( 4a int complex='c,f,f,f' invalid=3 5) engine=example ull=10000 str='dskj' one_or_two='one' yesno=0 6foobar=barfoo; 7Warnings: 8Warning 1911 Unknown option 'invalid' 9Warning 1911 Unknown option 'foobar' 10create table t2 (a int, key (a) some_option=2014); 11Warnings: 12Warning 1911 Unknown option 'some_option' 13show create table t1; 14Table Create Table 15t1 CREATE TABLE `t1` ( 16 `a` int(11) DEFAULT NULL `complex`='c,f,f,f' `invalid`=3 17) ENGINE=EXAMPLE DEFAULT CHARSET=latin1 `ull`=10000 `str`='dskj' `one_or_two`='one' `yesno`=0 `foobar`=barfoo 18show create table t2; 19Table Create Table 20t2 CREATE TABLE `t2` ( 21 `a` int(11) DEFAULT NULL, 22 KEY `a` (`a`) `some_option`=2014 23) ENGINE=MyISAM DEFAULT CHARSET=latin1 24set sql_mode=''; 25show create table t1; 26Table Create Table 27t1 CREATE TABLE `t1` ( 28 `a` int(11) DEFAULT NULL `complex`='c,f,f,f' /* `invalid`=3 */ 29) ENGINE=EXAMPLE DEFAULT CHARSET=latin1 `ull`=10000 `str`='dskj' `one_or_two`='one' `yesno`=0 /* `foobar`=barfoo */ 30show create table t2; 31Table Create Table 32t2 CREATE TABLE `t2` ( 33 `a` int(11) DEFAULT NULL, 34 KEY `a` (`a`) /* `some_option`=2014 */ 35) ENGINE=MyISAM DEFAULT CHARSET=latin1 36drop table t1, t2; 37uninstall soname 'ha_example'; 38