How to execute a sql file file.sql with zend framework 1.12?

Question

Php script:

   $db = Zend_Db_Table::getDefaultAdapter();
   $file_content = file_get_contents('file.sql', FILE_USE_INCLUDE_PATH);
   if($file_content!=''){
       $db->query($sql);
   }

It works for me if the sql file contains a simple sql query.

My sql file contains a procedure declaration:

DELIMITER $$
CREATE PROCEDURE PROC()
BEGIN
    ALTER ...... ;
    DELETE ..... ;
END $$
DELIMITER ;

RomanPerekhrest · Accepted Answer · 2016-03-17 12:57:06Z

1

If content of your file.sql is used as sql query string, it should look like the following(without "delimiters"):

CREATE PROCEDURE PROC()
BEGIN
    ALTER ...... ;
    DELETE ..... ;
END

Also, check if a certain procedure doesn't exist in database beforehand:

SELECT EXISTS (SELECT 1 FROM mysql.proc p WHERE db = 'db_name' 
AND name = 'PROC');

answered Mar 17, 2016 at 12:57

RomanPerekhrest

93.1k4 gold badges75 silver badges112 bronze badges

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

Comments

Sam Jason Braddock · Accepted Answer · 2016-03-17 12:56:59Z

0

Looks like it won't happen with ZF1.12

answered Mar 17, 2016 at 12:56

Sam Jason Braddock

2232 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to execute a sql file file.sql with zend framework 1.12?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related