PDO：调用mysql存储过程，创建临时表，然后从中进行选择

Question

This is a simplified version of my query:

CALL Create_List( 'company' ); SELECT name FROM tmpCompany;

Create_List creates a temporary table tmpCompany.

These two statements work correctly when run directly into the database using phpmyadmin but when i call it using PDO in php, I don't get a result.

Is there a specific way of calling stored procedures from php?

PHP Code

$result = $this->db->prepare( "CALL Create_List( :table ); SELECT name FROM tmpCompany;" );
$result->bindParam( ':table', $this->table );
$result->execute();     
return $result->fetch();

EDIT

Possibly related?

http://bugs.php.net/bug.php?id=38001

Answer 1

Try breaking the CALL and SELECT into separate statements.