MySQL Forums
Forum List  »  Microsoft Access

SQL Statements from Access to MySQL
Posted by: Carlo Uy Matiao
Date: October 31, 2005 07:56PM

I'm currently shifting my Access Database into MySQL. I have some Access SQL Statements which I can't make it work with MySQL. Here are they:

1.) IIF() - What's the equivalent for the IIF function on MySQL. The IIF() function works on MS Access but not on MySQL.

2.) Parameters - I have some where clause where I need to specify the value on runtime. So I need to use parameter variable on this. On Access, we just need to add the semicolon(:) before the word so we it's consider a parameter and we can specify the value on runtime. How can we do this on MySQL? For example: Where Customer Like "%" + :CustName + "%". CustName is the parameter where I'll specify the value on runtime.


Options: ReplyQuote

Written By
SQL Statements from Access to MySQL
October 31, 2005 07:56PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.