1drop table if exists t1; 2SET @OLD_SQL_MODE=@@SQL_MODE; 3SET SQL_MODE='IGNORE_BAD_TABLE_OPTIONS'; 4create table t1 (a int fkey=vvv, key akey (a) dff=vvv) tkey1='1v1'; 5Warnings: 6Warning 1911 Unknown option 'fkey' 7Warning 1911 Unknown option 'dff' 8Warning 1911 Unknown option 'tkey1' 9show create table t1; 10Table Create Table 11t1 CREATE TABLE `t1` ( 12 `a` int(11) DEFAULT NULL `fkey`=vvv, 13 KEY `akey` (`a`) `dff`=vvv 14) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey1`='1v1' 15drop table t1; 16#reassiginig options in the same line 17create table t1 (a int fkey=vvv, key akey (a) dff=vvv) tkey1=1v1 TKEY1=DEFAULT tkey1=1v2 tkey2=2v1; 18Warnings: 19Warning 1911 Unknown option 'fkey' 20Warning 1911 Unknown option 'dff' 21Warning 1911 Unknown option 'tkey1' 22Warning 1911 Unknown option 'tkey2' 23show create table t1; 24Table Create Table 25t1 CREATE TABLE `t1` ( 26 `a` int(11) DEFAULT NULL `fkey`=vvv, 27 KEY `akey` (`a`) `dff`=vvv 28) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey1`=1v2 `tkey2`=2v1 29#add option 30alter table t1 tkey4=4v1; 31Warnings: 32Warning 1911 Unknown option 'tkey4' 33show create table t1; 34Table Create Table 35t1 CREATE TABLE `t1` ( 36 `a` int(11) DEFAULT NULL `fkey`=vvv, 37 KEY `akey` (`a`) `dff`=vvv 38) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey1`=1v2 `tkey2`=2v1 `tkey4`=4v1 39#remove options 40alter table t1 tkey3=DEFAULT tkey4=DEFAULT; 41Warnings: 42Warning 1911 Unknown option 'tkey3' 43Warning 1911 Unknown option 'tkey4' 44show create table t1; 45Table Create Table 46t1 CREATE TABLE `t1` ( 47 `a` int(11) DEFAULT NULL `fkey`=vvv, 48 KEY `akey` (`a`) `dff`=vvv 49) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey1`=1v2 `tkey2`=2v1 50drop table t1; 51create table t1 (a int fkey1=v1, key akey (a) kkey1=v1) tkey1=1v1 tkey1=1v2 TKEY1=DEFAULT tkey2=2v1 tkey3=3v1; 52Warnings: 53Warning 1911 Unknown option 'fkey1' 54Warning 1911 Unknown option 'kkey1' 55Warning 1911 Unknown option 'TKEY1' 56Warning 1911 Unknown option 'tkey2' 57Warning 1911 Unknown option 'tkey3' 58show create table t1; 59Table Create Table 60t1 CREATE TABLE `t1` ( 61 `a` int(11) DEFAULT NULL `fkey1`=v1, 62 KEY `akey` (`a`) `kkey1`=v1 63) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1 64#change field with option with the same value 65alter table t1 change a a int `FKEY1`='v1'; 66Warnings: 67Warning 1911 Unknown option 'FKEY1' 68show create table t1; 69Table Create Table 70t1 CREATE TABLE `t1` ( 71 `a` int(11) DEFAULT NULL `FKEY1`='v1', 72 KEY `akey` (`a`) `kkey1`=v1 73) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1 74#change field with option with a different value 75alter table t1 change a a int fkey1=v2; 76Warnings: 77Warning 1911 Unknown option 'fkey1' 78show create table t1; 79Table Create Table 80t1 CREATE TABLE `t1` ( 81 `a` int(11) DEFAULT NULL `fkey1`=v2, 82 KEY `akey` (`a`) `kkey1`=v1 83) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1 84#new column no options 85alter table t1 add column b int; 86show create table t1; 87Table Create Table 88t1 CREATE TABLE `t1` ( 89 `a` int(11) DEFAULT NULL `fkey1`=v2, 90 `b` int(11) DEFAULT NULL, 91 KEY `akey` (`a`) `kkey1`=v1 92) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1 93#new key with options 94alter table t1 add key bkey (b) kkey2=v1; 95Warnings: 96Warning 1911 Unknown option 'kkey2' 97show create table t1; 98Table Create Table 99t1 CREATE TABLE `t1` ( 100 `a` int(11) DEFAULT NULL `fkey1`=v2, 101 `b` int(11) DEFAULT NULL, 102 KEY `akey` (`a`) `kkey1`=v1, 103 KEY `bkey` (`b`) `kkey2`=v1 104) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1 105#new column with options 106alter table t1 add column c int fkey1=v1 fkey2=v2; 107Warnings: 108Warning 1911 Unknown option 'fkey1' 109Warning 1911 Unknown option 'fkey2' 110show create table t1; 111Table Create Table 112t1 CREATE TABLE `t1` ( 113 `a` int(11) DEFAULT NULL `fkey1`=v2, 114 `b` int(11) DEFAULT NULL, 115 `c` int(11) DEFAULT NULL `fkey1`=v1 `fkey2`=v2, 116 KEY `akey` (`a`) `kkey1`=v1, 117 KEY `bkey` (`b`) `kkey2`=v1 118) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1 119#new key no options 120alter table t1 add key ckey (c); 121show create table t1; 122Table Create Table 123t1 CREATE TABLE `t1` ( 124 `a` int(11) DEFAULT NULL `fkey1`=v2, 125 `b` int(11) DEFAULT NULL, 126 `c` int(11) DEFAULT NULL `fkey1`=v1 `fkey2`=v2, 127 KEY `akey` (`a`) `kkey1`=v1, 128 KEY `bkey` (`b`) `kkey2`=v1, 129 KEY `ckey` (`c`) 130) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1 131#drop column 132alter table t1 drop b; 133show create table t1; 134Table Create Table 135t1 CREATE TABLE `t1` ( 136 `a` int(11) DEFAULT NULL `fkey1`=v2, 137 `c` int(11) DEFAULT NULL `fkey1`=v1 `fkey2`=v2, 138 KEY `akey` (`a`) `kkey1`=v1, 139 KEY `ckey` (`c`) 140) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1 141#add column with options after delete 142alter table t1 add column b int fkey2=v1; 143Warnings: 144Warning 1911 Unknown option 'fkey2' 145show create table t1; 146Table Create Table 147t1 CREATE TABLE `t1` ( 148 `a` int(11) DEFAULT NULL `fkey1`=v2, 149 `c` int(11) DEFAULT NULL `fkey1`=v1 `fkey2`=v2, 150 `b` int(11) DEFAULT NULL `fkey2`=v1, 151 KEY `akey` (`a`) `kkey1`=v1, 152 KEY `ckey` (`c`) 153) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1 154#add key 155alter table t1 add key bkey (b) kkey2=v2; 156Warnings: 157Warning 1911 Unknown option 'kkey2' 158show create table t1; 159Table Create Table 160t1 CREATE TABLE `t1` ( 161 `a` int(11) DEFAULT NULL `fkey1`=v2, 162 `c` int(11) DEFAULT NULL `fkey1`=v1 `fkey2`=v2, 163 `b` int(11) DEFAULT NULL `fkey2`=v1, 164 KEY `akey` (`a`) `kkey1`=v1, 165 KEY `ckey` (`c`), 166 KEY `bkey` (`b`) `kkey2`=v2 167) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey2`=2v1 `tkey3`=3v1 168drop table t1; 169create table t1 (a int) tkey1=100; 170Warnings: 171Warning 1911 Unknown option 'tkey1' 172show create table t1; 173Table Create Table 174t1 CREATE TABLE `t1` ( 175 `a` int(11) DEFAULT NULL 176) ENGINE=MyISAM DEFAULT CHARSET=latin1 `tkey1`=100 177drop table t1; 178#error on unknown option 179SET SQL_MODE=''; 180create table t1 (a int fkey=vvv, key akey (a) dff=vvv) tkey1=1v1; 181ERROR HY000: Unknown option 'fkey' 182SET @@SQL_MODE=@OLD_SQL_MODE; 183