Hi,
I want to know if we can pass multiple query in a single query?
I am updating a php form on web page with multiple values. I want to know if I can join or make a single query for those update.
Thanks in advance.
Hi,
I want to know if we can pass multiple query in a single query?
I am updating a php form on web page with multiple values. I want to know if I can join or make a single query for those update.
Thanks in advance.
What do you mean by MySQL query in a query?
I don't think its a good idea to marge multiple queries. What you can do is just use joiner or tolls present in Mysql for your help according to the scenario.
Personally I don't combine multiple MySQL queries. Its better if you keep them separate. SO it wont get messy & you can always troubleshoot or work on your code at later time with less pain.
Technically speaking its not supported in current MySQL environment to sent multiple queries in a single query. You can create procedures & triggers if you wish?
According to MySQL & PHP what you want to do is not supported.
Anyway I have a question about nested query.
I have this code.
Can anyone help?Code:SELECT column_1, column_2, column_1 FROM table1 a, table2 b WHERE a.playerid = b.playerid AND b.matchid IN ( SELECT matchid FROM matches WHERE season =2000 ) GROUP BY nickname ORDER BY avg( score ) DESC
You need to learn the Update statement in SQL.
I think this tutorial will help you.
http://www.tizag.com/mysqlTutorial/mysqlupdate.php
Bookmarks