Stackedqueries: Executingmorethanonequeryinonetransaction. does one execution of Multiple SQL statements mean stack query? According to an article, php + mysql does not support stackedqueries. However, such SQL statements: SELECT * FROMmembers ;... stacked queries: Executing more than one query in one transaction.
Is stack query performed when multiple SQL statements are executed at a time?
I saw an article saying that php + mysql does not support stacked queries. However, such an SQL statement:
SELECT * FROM members; DROP members
Obviously, it can be executed in mysql.
Where did I get it wrong?
Reply content:
Stacked queries: Executing more than one query in one transaction.
Is stack query performed when multiple SQL statements are executed at a time?
I saw an article saying that php + mysql does not support stacked queries. However, such an SQL statement:SELECT * FROM members; DROP members
Obviously, it can be executed in mysql.
Where did I get it wrong?
The database certainly supports stack query, but it is not necessary for php to execute SQL statements.
For more information, see the following two articles:
- Stacked Queries
- SQL Injection memo form