use test; drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9,t10; create table t1 (pk int key ,a1 BIT(1), a2 BIT(5), a3 BIT(33), a4 BIT(63), a5 BIT(64) ,b1 TINYINT, b2 TINYINT UNSIGNED ,c1 SMALLINT, c2 SMALLINT UNSIGNED ,d1 INT, d2 INT UNSIGNED ,e1 BIGINT, e2 BIGINT UNSIGNED ,f1 CHAR(1) BINARY, f2 CHAR(32) BINARY, f3 CHAR(255) BINARY ,g1 VARCHAR(32) BINARY, g2 VARCHAR(255) BINARY, g3 VARCHAR(1000) BINARY ,h1 BINARY(1), h2 BINARY(8), h3 BINARY(255) ,i1 VARBINARY(32), i2 VARBINARY(255), i3 VARBINARY(1000) ) engine myisam; insert into t1 values (1 ,0x1, 0x17, 0x789a, 0x789abcde, 0xfedc0001 ,127, 255 ,32767, 65535 ,2147483647, 4294967295 ,9223372036854775807, 18446744073709551615 ,'1','12345678901234567890123456789012','123456789' ,'1','12345678901234567890123456789012','123456789' ,0x12,0x123456789abcdef0, 0x012345 ,0x12,0x123456789abcdef0, 0x00123450 ); insert into t1 values (2 ,0, 0, 0, 0, 0 ,-128, 0 ,-32768, 0 ,-2147483648, 0 ,-9223372036854775808, 0 ,'','','' ,'','','' ,0x0,0x0,0x0 ,0x0,0x0,0x0 ); insert into t1 values (3 ,NULL,NULL,NULL,NULL,NULL ,NULL,NULL ,NULL,NULL ,NULL,NULL ,NULL,NULL ,NULL,NULL,NULL ,NULL,NULL,NULL ,NULL,NULL,NULL ,NULL,NULL,NULL ); select pk ,hex(a1), hex(a2), hex(a3), hex(a4), hex(a5) ,b1, b2 ,c1 , c2 ,d1 , d2 ,e1 , e2 ,f1 , f2, f3 ,g1 , g2, g3 ,hex(h1), hex(h2), hex(h3) ,hex(i1), hex(i2), hex(i3) from t1 order by pk; pk 1 hex(a1) 1 hex(a2) 17 hex(a3) 789A hex(a4) 789ABCDE hex(a5) FEDC0001 b1 127 b2 255 c1 32767 c2 65535 d1 2147483647 d2 4294967295 e1 9223372036854775807 e2 18446744073709551615 f1 1 f2 12345678901234567890123456789012 f3 123456789 g1 1 g2 12345678901234567890123456789012 g3 123456789 hex(h1) 12 hex(h2) 123456789ABCDEF0 hex(h3) 012345000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 hex(i1) 12 hex(i2) 123456789ABCDEF0 hex(i3) 00123450 pk 2 hex(a1) 0 hex(a2) 0 hex(a3) 0 hex(a4) 0 hex(a5) 0 b1 -128 b2 0 c1 -32768 c2 0 d1 -2147483648 d2 0 e1 -9223372036854775808 e2 0 f1 f2 f3 g1 g2 g3 hex(h1) 00 hex(h2) 0000000000000000 hex(h3) 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 hex(i1) 00 hex(i2) 00 hex(i3) 00 pk 3 hex(a1) NULL hex(a2) NULL hex(a3) NULL hex(a4) NULL hex(a5) NULL b1 NULL b2 NULL c1 NULL c2 NULL d1 NULL d2 NULL e1 NULL e2 NULL f1 NULL f2 NULL f3 NULL g1 NULL g2 NULL g3 NULL hex(h1) NULL hex(h2) NULL hex(h3) NULL hex(i1) NULL hex(i2) NULL hex(i3) NULL alter table t1 engine ndb; select pk ,hex(a1), hex(a2), hex(a3), hex(a4), hex(a5) ,b1, b2 ,c1 , c2 ,d1 , d2 ,e1 , e2 ,f1 , f2, f3 ,g1 , g2, g3 ,hex(h1), hex(h2), hex(h3) ,hex(i1), hex(i2), hex(i3) from t1 order by pk; pk 1 hex(a1) 1 hex(a2) 17 hex(a3) 789A hex(a4) 789ABCDE hex(a5) FEDC0001 b1 127 b2 255 c1 32767 c2 65535 d1 2147483647 d2 4294967295 e1 9223372036854775807 e2 18446744073709551615 f1 1 f2 12345678901234567890123456789012 f3 123456789 g1 1 g2 12345678901234567890123456789012 g3 123456789 hex(h1) 12 hex(h2) 123456789ABCDEF0 hex(h3) 012345000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 hex(i1) 12 hex(i2) 123456789ABCDEF0 hex(i3) 00123450 pk 2 hex(a1) 0 hex(a2) 0 hex(a3) 0 hex(a4) 0 hex(a5) 0 b1 -128 b2 0 c1 -32768 c2 0 d1 -2147483648 d2 0 e1 -9223372036854775808 e2 0 f1 f2 f3 g1 g2 g3 hex(h1) 00 hex(h2) 0000000000000000 hex(h3) 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 hex(i1) 00 hex(i2) 00 hex(i3) 00 pk 3 hex(a1) NULL hex(a2) NULL hex(a3) NULL hex(a4) NULL hex(a5) NULL b1 NULL b2 NULL c1 NULL c2 NULL d1 NULL d2 NULL e1 NULL e2 NULL f1 NULL f2 NULL f3 NULL g1 NULL g2 NULL g3 NULL hex(h1) NULL hex(h2) NULL hex(h3) NULL hex(i1) NULL hex(i2) NULL hex(i3) NULL CREATE TEMPORARY TABLE IF NOT EXISTS test.backup_info (id INT, backup_id INT) ENGINE = HEAP; DELETE FROM test.backup_info; LOAD DATA INFILE '../tmp.dat' INTO TABLE test.backup_info FIELDS TERMINATED BY ','; SELECT @the_backup_id:=backup_id FROM test.backup_info; @the_backup_id:=backup_id DROP TABLE test.backup_info; 1;0x1;0x17;0x789A;0x789ABCDE;0xFEDC0001;127;255;32767;65535;2147483647;4294967295;9223372036854775807;18446744073709551615;1;12345678901234567890123456789012;123456789;1;12345678901234567890123456789012;123456789;0x12;0x123456789ABCDEF0;0x012345;0x12;0x123456789ABCDEF0;0x00123450 2;0x0;0x0;0x0;0x0;0x0;-128;0;-32768;0;-2147483648;0;-9223372036854775808;0;;;;;;;0x0;0x0;0x0;0x0;0x0;0x0 3;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N;\N 1,0x1,0x17,0x789A,0x789ABCDE,0xFEDC0001,127,255,32767,65535,2147483647,4294967295,9223372036854775807,18446744073709551615,'1','12345678901234567890123456789012','123456789','1','12345678901234567890123456789012','123456789',0x12,0x123456789ABCDEF0,0x012345,0x12,0x123456789ABCDEF0,0x00123450 2,0x0,0x0,0x0,0x0,0x0,-128,0,-32768,0,-2147483648,0,-9223372036854775808,0,'','','','','','',0x0,0x0,0x0,0x0,0x0,0x0 3,,,,,,,,,,,,,,,,,,,,,,,,, drop table t1; create table t1 (pk int key ,f1 CHAR(1) BINARY, f2 CHAR(32) BINARY, f3 CHAR(255) BINARY ,g1 VARCHAR(32) BINARY, g2 VARCHAR(255) BINARY, g3 VARCHAR(1000) BINARY ,h1 BINARY(1), h2 BINARY(9), h3 BINARY(255) ,i1 VARBINARY(32), i2 VARBINARY(255), i3 VARBINARY(1000) ) engine ndb; insert into t1 values (1 ,'1','12345678901234567890123456789012','123456789 ' ,'1 ','12345678901234567890123456789012 ','123456789 ' ,0x20,0x123456789abcdef020, 0x012345000020 ,0x1200000020,0x123456789abcdef000000020, 0x00123450000020 ); create table t2 (pk int key, a int) engine ndb; create table t3 (pk int key, a int) engine ndb; create table t4 (pk int key, a int) engine ndb; insert into t2 values (1,11),(2,12),(3,13),(4,14),(5,15); insert into t3 values (1,21),(2,22),(3,23),(4,24),(5,25); insert into t4 values (1,31),(2,32),(3,33),(4,34),(5,35); CREATE TEMPORARY TABLE IF NOT EXISTS test.backup_info (id INT, backup_id INT) ENGINE = HEAP; DELETE FROM test.backup_info; LOAD DATA INFILE '../tmp.dat' INTO TABLE test.backup_info FIELDS TERMINATED BY ','; SELECT @the_backup_id:=backup_id FROM test.backup_info; @the_backup_id:=backup_id DROP TABLE test.backup_info; '1' '1' '12345678901234567890123456789012' '123456789' '1' '12345678901234567890123456789012' '123456789' '0x20' '0x123456789ABCDEF020' '0x012345000020' '0x1200000020' '0x123456789ABCDEF000000020' '0x00123450000020' t1 -- 1 1 12345678901234567890123456789012 123456789 1 12345678901234567890123456789012 123456789 0x20 0x123456789ABCDEF020 0x012345000020 0x1200000020 0x123456789ABCDEF000000020 0x00123450000020 t2 -- 1 11 2 12 3 13 4 14 5 15 t3 -- 1 21 2 22 3 23 4 24 5 25 t4 -- 1 31 2 32 3 33 4 34 5 35 drop table t1; create table t1 (pk int key ,a1 MEDIUMINT, a2 MEDIUMINT UNSIGNED ) engine ndb; insert into t1 values(1, 8388607, 16777215); insert into t1 values(2, -8388608, 0); insert into t1 values(3, -1, 1); CREATE TEMPORARY TABLE IF NOT EXISTS test.backup_info (id INT, backup_id INT) ENGINE = HEAP; DELETE FROM test.backup_info; LOAD DATA INFILE '../tmp.dat' INTO TABLE test.backup_info FIELDS TERMINATED BY ','; SELECT @the_backup_id:=backup_id FROM test.backup_info; @the_backup_id:=backup_id DROP TABLE test.backup_info; 1;8388607;16777215 2;-8388608;0 3;-1;1 drop table t1; drop table t2; drop table t3; drop table t4;