-- drop procedure SP_MYLOAD;
DELIMITER //
create procedure SP_MYLOAD() 
myexit_label:BEGIN

    DECLARE v_proc_name VARCHAR(50) DEFAULT 'SP_MYLOAD'; -- 程序名称


           set @sql=concat('LOAD DATA INFILE ''/home/myload.txt'' ','INTO TABLE myload ','FIELDS TERMINATED BY '','' ',
                           'ENCLOSED BY ''"'' ',
                           'LINES TERMINATED BY ''\\r'' ',
                           'IGNORE 1 LINES ',
                           '(no1, no2, no3) ');
              CALL SP_PASSYS_XTRZ('0', v_proc_name,@sql);
              PREPARE stmt FROM @sql;
              EXECUTE stmt;
              DEALLOCATE PREPARE stmt;
              COMMIT;
end//
DELIMITER ;


/*  调试
create table myload(no1 varchar(100),no2 varchar(100),no3 varchar(100));

SET @result= 0;
CALL SP_MYLOAD();
SELECT @result;

*/