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().
Note
  • 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.