Table Create Table bitz_MyISAM CREATE TABLE `bitz_MyISAM` (\n `bitfld` bit(1) default NULL,\n `numfld` int(1) default NULL\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 Table Create Table bitz_InnoDB CREATE TABLE `bitz_InnoDB` (\n `bitfld` bit(1) default NULL,\n `numfld` int(1) default NULL\n) ENGINE=InnoDB DEFAULT CHARSET=latin1 ### SQL: insert into bitz_MyISAM (bitfld, numfld) values (0, 0), (1, 1), (2, 2) bitfld numfld 0 0 1 1 1 2 ### SQL: insert into bitz_InnoDB (bitfld, numfld) values (0, 0), (1, 1), (2, 2) bitfld numfld 0 0 1 1 1 2 ### SQL: insert into bitz_MyISAM (numfld, bitfld) values (0, 0), (1, 1), (2, 2) bitfld numfld 0 0 1 1 1 NULL ### SQL: insert into bitz_InnoDB (numfld, bitfld) values (0, 0), (1, 1), (2, 2) bitfld numfld 0 0 1 1 1 2 ### SQL: insert into bitz_MyISAM (bitfld, numfld) values ('0', '0'), ('1', '1'), ('2', '2') bitfld numfld 1 0 1 1 1 2 ### SQL: insert into bitz_InnoDB (bitfld, numfld) values ('0', '0'), ('1', '1'), ('2', '2') bitfld numfld 1 0 1 1 1 2 ### SQL: insert into bitz_MyISAM (numfld, bitfld) values ('0', '0'), ('1', '1'), ('2', '2') bitfld numfld 1 NULL 1 NULL 1 NULL ### SQL: insert into bitz_InnoDB (numfld, bitfld) values ('0', '0'), ('1', '1'), ('2', '2') bitfld numfld 1 0 1 1 1 2 ### SQL: insert into bitz_MyISAM (bitfld, numfld) values ('0', 0), ('1', 1), ('2', 2) bitfld numfld 1 0 1 1 1 2 ### SQL: insert into bitz_InnoDB (bitfld, numfld) values ('0', 0), ('1', 1), ('2', 2) bitfld numfld 1 0 1 1 1 2 ### SQL: insert into bitz_MyISAM (numfld, bitfld) values ('0', 0), ('1', 1), ('2', 2) bitfld numfld 0 0 1 1 1 NULL ### SQL: insert into bitz_InnoDB (numfld, bitfld) values ('0', 0), ('1', 1), ('2', 2) bitfld numfld 0 0 1 1 1 2 ### SQL: insert into bitz_MyISAM (bitfld, numfld) values (0, '0'), (1, '1'), (2, '2') bitfld numfld 0 0 1 1 1 2 ### SQL: insert into bitz_InnoDB (bitfld, numfld) values (0, '0'), (1, '1'), (2, '2') bitfld numfld 0 0 1 1 1 2 ### SQL: insert into bitz_MyISAM (numfld, bitfld) values (0, '0'), (1, '1'), (2, '2') bitfld numfld 1 NULL 1 NULL 1 NULL ### SQL: insert into bitz_InnoDB (numfld, bitfld) values (0, '0'), (1, '1'), (2, '2') bitfld numfld 1 0 1 1 1 2