drop table if exists t1 ;

CREATE TABLE t1 (
testcol_1 int(11) NOT NULL,
testcol_2 smallint(6) NOT NULL,
testcol_3 smallint(6) NOT NULL,
testcol_4 smallint(6) NOT NULL,
testcol_5 char(1) default NULL,
testcol_6 tinyint(4) NOT NULL,
testcol_7 decimal(9,2) default NULL,
testcol_8 decimal(9,2) default NULL,
testcol_9 date default NULL,
testcol_10 date default NULL,
testcol_11 decimal(9,2) default NULL,
testcol_12 date default NULL,
testcol_13 smallint(6) default NULL,
testcol_14 decimal(9,2) default NULL,
testcol_15 date default NULL,
testcol_16 smallint(6) default NULL,
testcol_17 smallint(6) default NULL,
testcol_18 decimal(8,4) default NULL,
testcol_19 date default NULL,
testcol_20 char(1) default NULL,
testcol_21 tinyint(4) default NULL,
testcol_22 tinyint(4) default NULL,
testcol_23 tinyint(4) default NULL,
testcol_24 tinyint(4) default NULL,
testcol_25 tinyint(4) default NULL,
testcol_26 tinyint(4) default NULL,
testcol_27 tinyint(4) default NULL,
testcol_28 decimal(9,2) default NULL,
testcol_29 decimal(9,2) default NULL,
testcol_30 decimal(9,2) default NULL,
testcol_31 decimal(9,2) default NULL,
testcol_32 mediumint(9) default NULL,
testcol_33 decimal(6,2) default NULL,
testcol_34 smallint(6) default NULL,
testcol_35 smallint(6) default NULL,
testcol_36 smallint(6) default NULL,
testcol_37 smallint(6) default NULL,
testcol_38 smallint(6) default NULL,
testcol_39 smallint(6) default NULL,
testcol_40 smallint(6) default NULL,
testcol_41 decimal(9,2) default NULL,
testcol_42 date default NULL,
testcol_43 varchar(1) default NULL,
testcol_44 varchar(1) default NULL,
testcol_45 date default NULL,
testcol_46 smallint(6) default NULL,
testcol_47 smallint(6) default NULL,
testcol_48 smallint(6) default NULL,
testcol_49 smallint(6) default NULL,
testcol_50 smallint(6) default NULL,
testcol_51 smallint(6) default NULL,
testcol_52 smallint(6) default NULL,
testcol_53 smallint(6) default NULL,
testcol_54 smallint(6) default NULL,
testcol_55 smallint(6) default NULL,
testcol_56 smallint(6) default NULL,
testcol_57 smallint(6) default NULL,
testcol_58 smallint(6) default NULL  , 
   PRIMARY KEY  (testcol_1),
   KEY idx_testcol4 (testcol_4)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=FIXED
;





delimiter //

DROP PROCEDURE IF EXISTS insert_to_t1//

CREATE PROCEDURE insert_to_t1 (total_rows INT, rows_per_insert INT)
BEGIN
     DECLARE rows_done INT DEFAULT 0;
     DECLARE per_ins INT DEFAULT 0;

     TRUNCATE TABLE t1;

     WHILE rows_done < total_rows DO
	SET @insert_stmt = "INSERT INTO t1 VALUES ";
	WHILE per_ins < rows_per_insert DO
		SET @insert_stmt = concat(@insert_stmt, "(", rows_done, ",5,3,41,NULL,0,'39.00','0.00','2008-05-23','2008-05-23','39.00','2008-05-23',1,'39.00','2008-05-23',1,1,'0.0969',NULL,NULL,0,0,0,0,0,0,NULL,NULL,'39.00','39.00',NULL,2,'2.00',0,0,1,1,0,1,1,'39.00','2008-05-23','T','D',NULL,0,0,1,1,0,0,0,0,0,0,0,0,1)", IF(per_ins + 1 < rows_per_insert, ",", ""));
		SET rows_done = rows_done + 1;
		SET per_ins = per_ins + 1;
	END WHILE;
	SET per_ins = 0;
	PREPARE stmt FROM @insert_stmt;
	EXECUTE stmt;
     END WHILE;
END//

delimiter ;