Problem executing batch file Mysql

Question

I' experiencing problems while trying to run a batch file within Mysql shell.

I wrote a stored procedure :

DELIMITER $$

DROP PROCEDURE IF EXISTS creaFornitori_prova$$
CREATE PROCEDURE creaFornitori_prova ()
BEGIN
create table Fornitori_prova (id_For mediumint(5) NOT NULL auto_increment,
nome_For varchar(50) NOT NULL,
ind_For varchar(50) NOT NULL,
PRIMARY KEY  (id_For)
) ENGINE=InnoDB;
END$$

DELIMITER ;

I called the file : st_F.sql

Whenever I try to execute the file through the command : source st_F.sql;

I get this error:

ERROR: Failed to open file 'st_F.sql', error: 2

I get the same error when I use \. st_Fornitori.sql;

Thanks Mauro

ajreal · Accepted Answer · 2011-09-08 15:11:26Z

1

source DRIVE:ABSOLUTE_PATH_TO/st_F.sql;

answered Sep 8, 2011 at 15:11

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Margherita Over a year ago

Thanks I moved to where st_F.sql is located and run the command above and everything is ok...

Collectives™ on Stack Overflow

Problem executing batch file Mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related