mysql_execute_batch
Execute multiple SQL queries sequentially on a single connection, preserving session variables and temporary tables across statements. Returns an array with each query and its result.
Instructions
Execute multiple SQL queries sequentially on a single connection. Useful for running several queries at once. All queries share the same connection, so SET variables and temporary tables persist across queries. Returns an array of { query, result } pairs.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| alias | No | MySQL connection alias (optional, uses default if omitted) | |
| queries | Yes | Array of SQL queries to execute sequentially |