This article describs the multi-statement queries for DRDS.
DRDS supports multi-statement queries feature, that is the combination of multiple SQL statements separated with semicolons (;).
mysql> SELECT * FROM t1; SELECT * FROM t2; SELECT NOW().
- In the preceding statement, the --delimiter parameter on a MySQL client can be used to set the SQL separator to a period (.), preventing the client from separating SQL statements with semicolons (;).
- After the preceding SQL statements are submitted, DRDS splits the SQL statements by using the semicolons (;) and then executes them in sequence.