ms access queries to mysql

[pranjal]

How do I convert ms access queries to mysql?

I have converted the Tables from ms access to mysql.

Can queries be converted?
How do I use stored queries in mysql?

Thanx in advance.

Pranjal

[jatar_k]

Welcome to WebmasterWorld pranjal,

My access is very rusty to be honest but you could always look at these links
Stored Procedures and Triggers [mysql.com]
SELECT Syntax [mysql.com]

I would think that you can fairly easily rewrite your queries for mysql.

hth

[pranjal]

thanx jatar_k,

Apparently mySQL doesn't have stored procedures.

In msaccess, I can create a query in the query table & call it whenever I want, even though it is not actually a stored procedure.

I think the only workaround is to issue a query & create a new table, query that table for the data & delete the table.

Does anyone have a better suggestion?

Need help please.

Thanx once again jatar_k.

[jatar_k]

what scripting language are you using with mysql and what, more specificly, are you trying to do.

Could you store all of the queries ina file and then include it and call them when you need them? That might simulate a queries table.