delimiter //
DROP TABLE IF EXISTS table1;//
DROP PROCEDURE IF EXISTS P1//
DROP PROCEDURE IF EXISTS p1Inserts//
DROP PROCEDURE IF EXISTS createtab//
DROP PROCEDURE IF EXISTS inserttab//
DROP PROCEDURE IF EXISTS Intproc//
DROP PROCEDURE IF EXISTS Tintproc//
DROP PROCEDURE IF EXISTS Bigintproc//
DROP PROCEDURE IF EXISTS Mediumintproc//
DROP PROCEDURE IF EXISTS Smallintproc//
DROP PROCEDURE IF EXISTS Floatproc//
DROP PROCEDURE IF EXISTS Doubleproc//
DROP PROCEDURE IF EXISTS Dateproc//
DROP PROCEDURE IF EXISTS Timeproc//
DROP PROCEDURE IF EXISTS Timestampproc//
DROP PROCEDURE IF EXISTS Charproc//
DROP PROCEDURE IF EXISTS Binaryproc//
DROP PROCEDURE IF EXISTS Varbinaryproc//
DROP PROCEDURE IF EXISTS Tinytextproc//
DROP PROCEDURE IF EXISTS Textproc//
DROP PROCEDURE IF EXISTS Mediumtextproc//
DROP PROCEDURE IF EXISTS Longtextproc//
DROP PROCEDURE IF EXISTS Bitproc//
DROP PROCEDURE IF EXISTS Decimalproc//
DROP PROCEDURE IF EXISTS Decimalproc//
DROP PROCEDURE IF EXISTS Varcharproc//
DROP PROCEDURE IF EXISTS Mainproc//


create procedure createtab()
begin
create table table1 (
c1 int, 
c2 tinyint, 
c3 mediumint, 
c4 bigint, 
c5 smallint, 
c6 float, 
c7 double, 
c8 date, 
c9 time, 
c10 timestamp, 
c11 char(2),
c12 binary(7), 
c13 varbinary(50), 
c14 tinytext,
c15 mediumtext,
c16 text,
c17 longtext,
c18 bit, 
c19 decimal(4,2), 
c20 varchar(2));
end;//

call createtab();//


DELETE FROM TABLE1//

create procedure inserttab()
begin
insert into table1 values(
640, 
-22, 
1111111, 
123456789012345678,
12344,
 -500000, 
500000.45, 
'1999-12-12', 
'12:12:59', 
'1999-12-12 12:12:59', 
'cc',
 null,
 'bbbb1234567890123456789012345678901234567890',
 '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890', 
'123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890',  
'12345678901234567890123456789012345678901234567890',
'12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890',
1,
12.34,
'dd');
end;//

call inserttab();//



DROP PROCEDURE IF EXISTS Intproc//

create procedure IntProc ( inout io1 int) 
begin
declare i1 int;
set i1=io1;
select c1 into io1 from table1 where c1 = i1;
end;//


DROP PROCEDURE IF EXISTS Tintproc//
create procedure TintProc ( inout io1 tinyint) 
begin
declare i1 tinyint;
set i1=io1;
select c2 into io1 from table1 where c2 = i1;
end;//


DROP PROCEDURE IF EXISTS Mediumintproc//
create procedure Mediumintproc ( inout io1 mediumint) 
begin
declare i1 mediumint;
set i1=io1;
select c3 into io1 from table1 where c3 = i1;
end;//


DROP PROCEDURE IF EXISTS Bigintproc//
create procedure Bigintproc ( inout io1 bigint) 
begin
declare i1 bigint;
set i1=io1;
select c4 into io1 from table1 where c4 = i1;
end;//


DROP PROCEDURE IF EXISTS Smallintproc//
create procedure SmallintProc ( inout io1 smallint) 
begin
declare i1 smallint;
set i1=io1;
select c5 into io1 from table1 where c5 = i1;
end;//


DROP PROCEDURE IF EXISTS Floatproc//
create procedure Floatproc ( inout io1 float) 
begin
declare i1 float;
set i1=io1;
select c6 into io1 from table1 where c6 = i1;
end;//


DROP PROCEDURE IF EXISTS Doubleproc//
create procedure DoubleProc ( inout io1 double) 
begin
declare i1 double;
set i1=io1;
select c7 into io1 from table1 where c7 = i1;
end;//


DROP PROCEDURE IF EXISTS Dateproc//
create procedure DateProc ( inout io1 date) 
begin
declare i1 date;
set i1=io1;
select c8 into io1 from table1 where c8 = i1;
end;//


DROP PROCEDURE IF EXISTS Timeproc//
create procedure TimeProc ( inout io1 time) 
begin
declare i1 time;
set i1=io1;
select c9 into io1 from table1 where c9 = i1;
end;//


DROP PROCEDURE IF EXISTS Timestampproc//
create procedure TimestampProc ( inout io1 timestamp) 
begin
declare i1 timestamp;
set i1=io1;
select c10 into io1 from table1 where c10 = i1;
end;//


DROP PROCEDURE IF EXISTS Charproc//
create procedure CharProc ( inout io1 char(2)) 
begin
declare i1 char(2);
set i1=io1;
select c11 into io1 from table1 where c11 = i1;
end;//


DROP PROCEDURE IF EXISTS Binaryproc//
create procedure BinaryProc ( inout io1 binary(7)) 
begin
declare i1 binary(7);
set i1=io1;
select c12 into io1 from table1 where c12 = i1;
end;//


DROP PROCEDURE IF EXISTS Varbinaryproc//
create procedure VarbinaryProc ( inout io1 varbinary(50)) 
begin
declare i1 varbinary(50);
set i1=io1;
select c13 into io1 from table1 where c13 = i1;
end;//


DROP PROCEDURE IF EXISTS Tinytextproc//
create procedure TinytextProc ( inout io1 tinytext) 
begin
declare i1 tinytext;
set i1=io1;
select c14 into io1 from table1 where c14 = i1;
end;//

DROP PROCEDURE IF EXISTS Mediumtextproc//
create procedure MediumtextProc ( inout io1 mediumtext) 
begin
declare i1 mediumtext;
set i1=io1;
select c15 into io1 from table1 where c15 = i1;
end;//

DROP PROCEDURE IF EXISTS Textproc//
create procedure TextProc ( inout io1 text) 
begin
declare i1 text;
set i1=io1;
select c16 into io1 from table1 where c16 = i1;
end;//


DROP PROCEDURE IF EXISTS Longtextproc//
create procedure LongtextProc ( inout io1 longtext) 
begin
declare i1 longtext;
set i1=io1;
select c17 into io1 from table1 where c17 = i1;
end;//


DROP PROCEDURE IF EXISTS Bitproc//
create procedure BitProc ( inout io1 bit) 
begin
declare i1 bit;
set i1=io1;
select c18 into io1 from table1 where c18 = i1;
end;//


DROP PROCEDURE IF EXISTS Decimalproc//
create procedure DecimalProc ( inout io1 Decimal(4,2)) 
begin
declare i1 decimal(4,2);
set i1=io1;
select c19 into io1 from table1 where c19 = i1;
end;//


DROP PROCEDURE IF EXISTS Varcharproc//
create procedure VarcharProc ( inout io1 varchar(2)) 
begin
declare i1 varchar(2);
set i1=io1;
select c20 into io1 from table1 where c20 = i1;
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 int; 
SET I1 = 640;
CALL Intproc(I1); 
delete from table1 where c1 = I1; 
end;//

DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 tinyint; 
SET I1 = -22;
CALL Tintproc(I1); 
delete from table1 where c2 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 mediumint; 
SET I1 = 1111111;
CALL Mediumintproc(I1); 
delete from table1 where c3 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 bigint; 
SET I1 = 123456789012345678;
CALL Bigintroc(I1); 
delete from table1 where c4 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 smallint; 
 
SET I1 = 12344;
CALL SmallintProc(I1); 
delete from table1 where c5 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 float; 
SET I1 = -500000;
CALL Floatproc(I1); 
delete from table1 where c6 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 double; 
SET I1 = 500000.45;
CALL Doubleproc(I1); 
delete from table1 where c7 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 date; 
SET I1 = '1999-12-12';
CALL Dateproc(I1); 
delete from table1 where c8 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 time;  
SET I1 = '12:12:59';
CALL Timeproc(I1); 
delete from table1 where c9 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 timestamp; 
SET I1 = '1999-12-12 12:12:59';
CALL Timestampproc(I1); 
delete from table1 where c10 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 char(2);  
SET I1 = 'cc';
CALL Charproc(I1); 
delete from table1 where c11 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 binary(7); 
SET I1 = null;
CALL Binaryproc(I1); 
delete from table1 where c12 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 varbinary(50); 

SET I1 = 'bbbb1234567890123456789012345678901234567890';
CALL Varbinaryproc(I1); 
delete from table1 where c13 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 tinytext; 
DECLARE O1 tinytext; 
SET I1 = '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890';
CALL Tinytextproc(I1, O1); 
delete from table1 where c14 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 mediumtext; 
SET I1 = '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890';
CALL Mediumtextproc(I1); 
delete from table1 where c15 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 text;  
SET I1 = '12345678901234567890123456789012345678901234567890';
CALL Textproc(I1); 
delete from table1 where c16 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 longtext; 
SET I1 = '12345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890';
CALL Longtextproc(I1); 
delete from table1 where c17 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 bit;  
SET I1 = 1;
CALL Bitproc(I1); 
delete from table1 where c18 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 decimal(4,2); 
SET I1 = 12.34;
CALL Decimalproc(I1); 
delete from table1 where c19 = I1; 
end;//


DROP PROCEDURE IF EXISTS Mainproc//
call inserttab()//
create procedure MainProc ( ) 
begin 
DECLARE I1 varchar(2); 
SET I1 = 'dd';
CALL Varcharproc(I1); 
delete from table1 where c20 = I1; 
end;//