sql.Exec

[wmarbut]

• Go Version: go version devel +c8e9255aed3f Thu Jun 05 16:40:23 2014 -0400 darwin/amd64
• go-sql-driver Version: 1.2

When trying to run Exec with multiple statements, the engine complains about a syntax error.

e.g.

DROP TABLE IF EXISTS `table1`;
DROP TABLE IF EXISTS `table2`;
DROP TABLE IF EXISTS `table3`;
DROP TABLE IF EXISTS `table4`;

You get

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `table1`;
DROP TABLE IF EXISTS `table2`;
DROP TABLE IF EXISTS ' at line 2

[arnehormann]

Yes, this is expected.
Multiple statements are unsupported because database/sql has no way to return multiple results and it's impossible to merge them into one.

[wmarbut]

Is there a supported way of running large scripts like importing a schema?

[arnehormann]

You can split them into multiple single expressions.
If you depend on session variables you can either use a transaction or use the driver without database/sql:
session, err := mysql.Open(dsn) instead of db, err := sql.Open("mysql", dsn).

Anyway, if you haven't done so, please read http://go-database-sql.org/ first.

[wmarbut]

Thanks Arne!