1

Would PDO be able to handle MySQL functions when interfacing a SQL Server (Microsoft)? For example would PDO convert "SELECT MYSQL-FUNCTION(col1) FROM tbl" where in such a use case MYSQL-FUNCTION only exists in SQL Server as SQLSERVER-FUNCTION?

4
  • PDO is an abstraction layer, its not psychic Commented Oct 21, 2013 at 22:10
  • Fortunately, I have something like StackOverflow to provide me with knowledge, Dagon. It's the way we learn. Thanks for the feedback, though. :) Commented Oct 21, 2013 at 22:23
  • 1
    people learnt before S.O and even the internet - think about it ;-) Commented Oct 21, 2013 at 22:24
  • 1
    A better way to learn is to try it and see what happens. Commented Oct 21, 2013 at 22:36

1 Answer 1

1

No. PDO does not rewrite SQL, not even as much as JDBC does.

As far as I know, only syntax PDO will rewrite is parameter placeholders, for RDBMS brands that don't support named parameters.

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

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.