Dear all,
I am in need to import the Data from .DAT file to my database.when I tried with LOAD DATA INFILE statement ,it's working fine.But my ultimate aim is to do the same with stored procedure ,it fails and gives an error message
Script line: 4 LOAD DATA is not allowed in stored procedures
Script line: 4 LOAD DATA is not allowed in stored procedures
This is my Stored procedure
DELIMITER $
DROP PROCEDURE IF EXISTS `paylink`.`Test` $
CREATE PROCEDURE `paylink`.`Test` ()
BEGIN