starting with mysql

Anon

hi guys
im looking for the first time to mysql and i thought:
ok i have my table but i have to do a really complicate query on them...
i write this query for the first time...
..and i run it...
...2 days later id like to reuse that query...
can i save it somewhere and recall it or i have to rewrite everytime?
i read that stored procedures r a TODO...
using php is there a way to recall it or i have to rewrite it?

thnx anyway and have a nice day!

Anon

Rick,

Are you running PHP?

If so just write the query in PHP.

eg.

$cnx = mysql_connect('localhost','username','password');

mysql_select_db("database",$cnx);

mysql_query(" ## MYSQL QUERY GOES HERE ## ") or die (mysql_error());

Hope this helps

Mike

Anon

yeh thats good but if i have to write it several times and it is a hard query there is no way...
im working with access now (gulp) and if i have to call a query just build it in the dbms the call it as a table...
theres no way to do that with mysql???

Anon

Rick,

You could write a SQL script and call it from the command line every time you need to use it.

Just write the SQL into a file name scriptname.sql

I don't know the exact commands to do this but this should give you a starting point.

Regards

Mike
www.digitalegg.net

Anon

can u this last technique with php?
have u got a few lines of demo code?
btw thnx anyway

Anon

Rick,

I think you misunderstood my first suggestion, that is how to do it in PHP.

Put this code into a page called run_query.php3 :

$cnx = mysql_connect('localhost','username','password');

mysql_select_db("database",$cnx);

mysql_query(" ## MYSQL QUERY GOES HERE ## ") or die (mysql_error());

Every time you wanted to run the script just open the page in you browser.

If you need to change the query slightly just change it in the PHP file and open it in you browser.

Regards

Mike
www.digitalegg.net

Anon

using php to store queries...
mmm... could be an idea...
but it is only a way to go around the prob...
well np thnx guy

Anon

How about saving the query as a Word Document, and then just cutting & pasting
whenever you need it ? This may be too simplistic of an answer, but I thought it might be worth mentioning.