Create a gist now

Instantly share code, notes, and snippets.

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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment