Question on Stored Procedure Usage

[zachgersh]

Was conditionally trying to add a column to a table with something along the lines of this:

DROP PROCEDURE IF EXISTS foo;
CREATE PROCEDURE foo() BEGIN
    DECLARE CONTINUE HANDLER FOR 1060 BEGIN END;
    ALTER TABLE `tableName` ADD `columnName` int(10) NULL AFTER `otherColumn`;
END;
CALL foo();
DROP PROCEDURE foo;

I have read that go-sql-driver does not support some forms of stored procedures but I thought the above was completely acceptable (believe this only returns one value).

[arnehormann]

The driver does not support creating any kind of stored procedure.
You can try to declare it externally, maybe just using CALL is possible.
As a rule of thumb, queries containing semicolons won't work (except for strings or comments).
Have a look at the comments in #66. Maybe adding clientMultiStatements works for you.

Btw, why the stored procedure and not just ALTER?