Does MySQL driver support cursors?

Question

Can I use cursors in MySQL driver? Does the code following work in it (written using PDO)?

$dbConnection->prepare('SELECT * FROM `table`', [PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL]);

Answer 1

Thank you Dayve for your links. Currently, MySQL doesn't support cursors; as mentioned in notes:

http://php.net/manual/en/pdostatement.fetch.php#105277

http://php.net/manual/en/pdostatement.fetch.php#114458

Answer 2

@Mohammad Amin Chitgarha : Oops...tbh, I was not aware of this. Thanks a lot for correcting me. :))

Answer 3

Maybe it does! Check these out :

• http://php.net/manual/en/pdostatement.fetch.php

• http://php.net/manual/en/book.pdo.php

Edit :- Seems like it's not supported in the MySQL driver =]