批量SQL提交
参考 21.2.6. Connector/NET Connection String Options Reference 。
Allow Batch |
true | When true, multiple SQL statements can be sent with one command execution. -Note- Starting with MySQL 4.1.1, batch statements should be separated by the server-defined separator character. Commands sent to earlier versions of MySQL should be separated with ';'. |
Allow Batch 只从MySQL 4.1.1之后 才支持.
union 在3.0版本中是不支持的.
12.2.7. SELECT Syntax
http://dev.mysql.com/doc/refman/4.1/en/select.html
Support for UNION statements and subqueries is available as of MySQL 4.0 and 4.1, respectively. See Section 12.2.7.3, “UNION Syntax”, and Section 12.2.8, “Subquery Syntax”.
SELECT ... UNION [ALL | DISTINCT] SELECT ... [UNION [ALL | DISTINCT] SELECT ...]
UNION is used to combine the result from multiple SELECT statements into a single result set. UNION is available from MySQL 4.0.0 on.
