1create table t1 ( 2a int, b char(10), c char(10), filler char(10), primary key(a, b(2)), unique key (a, c(2)) 3) character set utf8 engine = MyISAM; 4create table t2 ( 5a int, b char(10), c char(10), filler char(10), primary key(a, b(2)), unique key (a, c(2)) 6) character set ucs2 engine = MyISAM; 7insert into t1 values (1,'abcdefg','abcdefg','one'); 8insert into t1 values (2,'ijkilmn','ijkilmn','two'); 9insert into t1 values (3,'qrstuvw','qrstuvw','three'); 10insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four'); 11insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five'); 12insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six'); 13insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven'); 14insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight'); 15insert into t2 values (1,'abcdefg','abcdefg','one'); 16insert into t2 values (2,'ijkilmn','ijkilmn','two'); 17insert into t2 values (3,'qrstuvw','qrstuvw','three'); 18insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four'); 19insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five'); 20insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six'); 21insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven'); 22insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight'); 23insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten'); 24insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven'); 25insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point'); 26insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken'); 27update t1 set filler = 'boo' where a = 1; 28update t2 set filler ='email' where a = 4; 29select a,hex(b),hex(c),filler from t1 order by filler; 30a hex(b) hex(c) filler 311 61626364656667 61626364656667 boo 324 D0B1 D0B1 eight 334 5B 5B five 344 E880BD E880BD four 354 E880BDD0B1E880BD E880BDD0B1E880BD seven 364 E880BDE880BD E880BDE880BD six 373 71727374757677 71727374757677 three 382 696A6B696C6D6E 696A6B696C6D6E two 39select a,hex(b),hex(c),filler from t2 order by filler; 40a hex(b) hex(c) filler 414 05612020 05612020 email 424 0000563001FC0563 0000563001FC0563 email 434 05630563 05630563 email 444 0563 0563 email 454 0120 0120 email 464 01FC 01FC email 474 00E400E50068 00E400E50068 email 484 00640065 00640065 email 494 0000E400 0000E400 email 501 0061006200630064006500660067 0061006200630064006500660067 one 513 0071007200730074007500760077 0071007200730074007500760077 three 522 0069006A006B0069006C006D006E 0069006A006B0069006C006D006E two 53drop table t1; 54drop table t2; 55create table t1 ( 56a int, b varchar(10), c varchar(10), filler varchar(10), primary key(a, b(2)), unique key (a, c(2)) 57) character set utf8 engine = MyISAM; 58create table t2 ( 59a int, b varchar(10), c varchar(10), filler varchar(10), primary key(a, b(2)), unique key (a, c(2)) 60) character set ucs2 engine = MyISAM; 61insert into t1 values (1,'abcdefg','abcdefg','one'); 62insert into t1 values (2,'ijkilmn','ijkilmn','two'); 63insert into t1 values (3,'qrstuvw','qrstuvw','three'); 64insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four'); 65insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five'); 66insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six'); 67insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven'); 68insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight'); 69insert into t2 values (1,'abcdefg','abcdefg','one'); 70insert into t2 values (2,'ijkilmn','ijkilmn','two'); 71insert into t2 values (3,'qrstuvw','qrstuvw','three'); 72insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four'); 73insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five'); 74insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six'); 75insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven'); 76insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight'); 77insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten'); 78insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven'); 79insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point'); 80insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken'); 81update t1 set filler = 'boo' where a = 1; 82update t2 set filler ='email' where a = 4; 83select a,hex(b),hex(c),filler from t1 order by filler; 84a hex(b) hex(c) filler 851 61626364656667 61626364656667 boo 864 D0B1 D0B1 eight 874 5B 5B five 884 E880BD E880BD four 894 E880BDD0B1E880BD E880BDD0B1E880BD seven 904 E880BDE880BD E880BDE880BD six 913 71727374757677 71727374757677 three 922 696A6B696C6D6E 696A6B696C6D6E two 93select a,hex(b),hex(c),filler from t2 order by filler; 94a hex(b) hex(c) filler 954 05612020 05612020 email 964 0000563001FC0563 0000563001FC0563 email 974 05630563 05630563 email 984 0563 0563 email 994 0120 0120 email 1004 01FC 01FC email 1014 00E400E50068 00E400E50068 email 1024 00640065 00640065 email 1034 0000E400 0000E400 email 1041 0061006200630064006500660067 0061006200630064006500660067 one 1053 0071007200730074007500760077 0071007200730074007500760077 three 1062 0069006A006B0069006C006D006E 0069006A006B0069006C006D006E two 107drop table t1; 108drop table t2; 109create table t1 ( 110a int, b text(10), c text(10), filler text(10), primary key(a, b(2)), unique key (a, c(2)) 111) character set utf8 engine = MyISAM; 112create table t2 ( 113a int, b text(10), c text(10), filler text(10), primary key(a, b(2)), unique key (a, c(2)) 114) character set ucs2 engine = MyISAM; 115insert into t1 values (1,'abcdefg','abcdefg','one'); 116insert into t1 values (2,'ijkilmn','ijkilmn','two'); 117insert into t1 values (3,'qrstuvw','qrstuvw','three'); 118insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four'); 119insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five'); 120insert into t1 values (4,_utf8 0xe880bde880bd,_utf8 0xe880bde880bd,'six'); 121insert into t1 values (4,_utf8 0xe880bdD0B1e880bd,_utf8 0xe880bdD0B1e880bd,'seven'); 122insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight'); 123insert into t2 values (1,'abcdefg','abcdefg','one'); 124insert into t2 values (2,'ijkilmn','ijkilmn','two'); 125insert into t2 values (3,'qrstuvw','qrstuvw','three'); 126insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four'); 127insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five'); 128insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six'); 129insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven'); 130insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight'); 131insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten'); 132insert into t2 values (4,_ucs2 0x05630563,_ucs2 0x05630563,'eleven'); 133insert into t2 values (4,_ucs2 0x0563001fc0563,_ucs2 0x0563001fc0563,'point'); 134insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken'); 135update t1 set filler = 'boo' where a = 1; 136update t2 set filler ='email' where a = 4; 137select a,hex(b),hex(c),filler from t1 order by filler; 138a hex(b) hex(c) filler 1391 61626364656667 61626364656667 boo 1404 D0B1 D0B1 eight 1414 5B 5B five 1424 E880BD E880BD four 1434 E880BDD0B1E880BD E880BDD0B1E880BD seven 1444 E880BDE880BD E880BDE880BD six 1453 71727374757677 71727374757677 three 1462 696A6B696C6D6E 696A6B696C6D6E two 147select a,hex(b),hex(c),filler from t2 order by filler; 148a hex(b) hex(c) filler 1494 0000E400 0000E400 email 1504 00640065 00640065 email 1514 00E400E50068 00E400E50068 email 1524 01FC 01FC email 1534 0120 0120 email 1544 0563 0563 email 1554 05630563 05630563 email 1564 0000563001FC0563 0000563001FC0563 email 1574 05612020 05612020 email 1581 0061006200630064006500660067 0061006200630064006500660067 one 1593 0071007200730074007500760077 0071007200730074007500760077 three 1602 0069006A006B0069006C006D006E 0069006A006B0069006C006D006E two 161drop table t1; 162drop table t2; 163create table t1 ( 164a int, b blob(10), c blob(10), filler blob(10), primary key(a, b(2)), unique key (a, c(2)) 165) character set utf8 engine = MyISAM; 166create table t2 ( 167a int, b blob(10), c blob(10), filler blob(10), primary key(a, b(2)), unique key (a, c(2)) 168) character set ucs2 engine = MyISAM; 169insert into t1 values (1,'abcdefg','abcdefg','one'); 170insert into t1 values (2,'ijkilmn','ijkilmn','two'); 171insert into t1 values (3,'qrstuvw','qrstuvw','three'); 172insert into t1 values (4,_utf8 0xe880bd,_utf8 0xe880bd,'four'); 173insert into t1 values (4,_utf8 0x5b,_utf8 0x5b,'five'); 174insert into t1 values (4,_utf8 0xD0B1,_utf8 0xD0B1,'eight'); 175insert into t2 values (1,'abcdefg','abcdefg','one'); 176insert into t2 values (2,'ijkilmn','ijkilmn','two'); 177insert into t2 values (3,'qrstuvw','qrstuvw','three'); 178insert into t2 values (4,_ucs2 0x00e400,_ucs2 0x00e400,'four'); 179insert into t2 values (4,_ucs2 0x00640065,_ucs2 0x00640065,'five'); 180insert into t2 values (4,_ucs2 0x00e400e50068,_ucs2 0x00e400e50068,'six'); 181insert into t2 values (4,_ucs2 0x01fc,_ucs2 0x01fc,'seven'); 182insert into t2 values (4,_ucs2 0x0120,_ucs2 0x0120,'eight'); 183insert into t2 values (4,_ucs2 0x0563,_ucs2 0x0563,'ten'); 184insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken'); 185update t1 set filler = 'boo' where a = 1; 186update t2 set filler ='email' where a = 4; 187select a,hex(b),hex(c),filler from t1 order by filler; 188a hex(b) hex(c) filler 1891 61626364656667 61626364656667 boo 1904 D0B1 D0B1 eight 1914 5B 5B five 1924 E880BD E880BD four 1933 71727374757677 71727374757677 three 1942 696A6B696C6D6E 696A6B696C6D6E two 195select a,hex(b),hex(c),filler from t2 order by filler; 196a hex(b) hex(c) filler 1974 0000E400 0000E400 email 1984 00640065 00640065 email 1994 00E400E50068 00E400E50068 email 2004 01FC 01FC email 2014 0120 0120 email 2024 0563 0563 email 2034 05612020 05612020 email 2041 61626364656667 61626364656667 one 2053 71727374757677 71727374757677 three 2062 696A6B696C6D6E 696A6B696C6D6E two 207drop table t1; 208drop table t2; 209commit; 210CREATE TABLE t1 ( 211ind enum('0','1','2') NOT NULL default '0', 212string1 varchar(250) NOT NULL, 213PRIMARY KEY (ind) 214) ENGINE=MyISAM DEFAULT CHARSET=utf8; 215CREATE TABLE t2 ( 216ind enum('0','1','2') NOT NULL default '0', 217string1 varchar(250) NOT NULL, 218PRIMARY KEY (ind) 219) ENGINE=MyISAM DEFAULT CHARSET=ucs2; 220INSERT INTO t1 VALUES ('1', ''),('2', ''); 221INSERT INTO t2 VALUES ('1', ''),('2', ''); 222SELECT hex(ind),hex(string1) FROM t1 ORDER BY string1; 223hex(ind) hex(string1) 22431 22532 226SELECT hex(ind),hex(string1) FROM t2 ORDER BY string1; 227hex(ind) hex(string1) 2280031 2290032 230drop table t1,t2; 231CREATE TABLE t1 ( 232ind set('0','1','2') NOT NULL default '0', 233string1 varchar(250) NOT NULL, 234PRIMARY KEY (ind) 235) ENGINE=MyISAM DEFAULT CHARSET=utf8; 236CREATE TABLE t2 ( 237ind set('0','1','2') NOT NULL default '0', 238string1 varchar(250) NOT NULL, 239PRIMARY KEY (ind) 240) ENGINE=MyISAM DEFAULT CHARSET=ucs2; 241INSERT INTO t1 VALUES ('1', ''),('2', ''); 242INSERT INTO t2 VALUES ('1', ''),('2', ''); 243SELECT hex(ind),hex(string1) FROM t1 ORDER BY string1; 244hex(ind) hex(string1) 24531 24632 247SELECT hex(ind),hex(string1) FROM t2 ORDER BY string1; 248hex(ind) hex(string1) 2490031 2500032 251drop table t1,t2; 252CREATE TABLE t1 ( 253ind bit not null, 254string1 varchar(250) NOT NULL, 255PRIMARY KEY (ind) 256) ENGINE=MyISAM DEFAULT CHARSET=utf8; 257CREATE TABLE t2 ( 258ind bit not null, 259string1 varchar(250) NOT NULL, 260PRIMARY KEY (ind) 261) ENGINE=MyISAM DEFAULT CHARSET=ucs2; 262insert into t1 values(0,''),(1,''); 263insert into t2 values(0,''),(1,''); 264select hex(ind),hex(string1) from t1 order by string1; 265hex(ind) hex(string1) 2660 2671 268select hex(ind),hex(string1) from t2 order by string1; 269hex(ind) hex(string1) 2700 2711 272drop table t1,t2; 273create table t2 ( 274a int, b char(10), filler char(10), primary key(a, b(2)) 275) character set utf8 engine = MyISAM; 276insert into t2 values (1,'abcdefg','one'); 277insert into t2 values (2,'ijkilmn','two'); 278insert into t2 values (3, 'qrstuvw','three'); 279update t2 set a=5, filler='booo' where a=1; 280drop table t2; 281create table t2 ( 282a int, b char(10), filler char(10), primary key(a, b(2)) 283) character set ucs2 engine = MyISAM; 284insert into t2 values (1,'abcdefg','one'); 285insert into t2 values (2,'ijkilmn','two'); 286insert into t2 values (3, 'qrstuvw','three'); 287update t2 set a=5, filler='booo' where a=1; 288drop table t2; 289create table t1(a int not null, b char(110),primary key(a,b(100))) engine=MyISAM default charset=utf8; 290insert into t1 values(1,'abcdefg'),(2,'defghijk'); 291insert into t1 values(6,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1); 292insert into t1 values(7,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2); 293select a,hex(b) from t1 order by b; 294a hex(b) 2951 61626364656667 2962 6465666768696A6B 2976 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1 2987 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2 299update t1 set b = 'three' where a = 6; 300drop table t1; 301create table t1(a int not null, b text(110),primary key(a,b(100))) engine=MyISAM default charset=utf8; 302insert into t1 values(1,'abcdefg'),(2,'defghijk'); 303insert into t1 values(6,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1); 304insert into t1 values(7,_utf8 0xD0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2); 305select a,hex(b) from t1 order by b; 306a hex(b) 3071 61626364656667 3082 6465666768696A6B 3096 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1 3107 D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B1D0B2 311update t1 set b = 'three' where a = 6; 312drop table t1; 313