length_test.sql

drop table if exists varchar_length;
create table varchar_length(
      id int auto_increment NOT NULL,
      letter016 varchar(16),
      letter256 varchar(256),
      primary key(id)
);

drop table if exists int_length;
create table int_length(
      id int auto_increment NOT NULL,
      number03 int(3),
      number10 int(10),
      number50 int(50),
      number03_fill int(3) zerofill,
      number10_fill int(10) zerofill,
      number50_fill int(50) zerofill,
      primary key(id)
);


insert into varchar_length(letter016,letter256) values('1234567890123456'  , '1234567890123456');
insert into varchar_length(letter016,letter256) values('12345678901234567' , '12345678901234567');
 
insert into int_length(number03,number10,number50,number03_fill,number10_fill,number50_fill) values(100 ,100 ,100 ,100 ,100 ,100);
insert into int_length(number03,number10,number50,number03_fill,number10_fill,number50_fill) values(1000,1000,1000,1000,1000,1000);