Search Results

I've tried it. If you want to pass in a VARCHAR, you'll have to quote it, egCALL createtable("accounts");

OK, I've read up on Stored Procedures (http://dev.mysql.com/tech-resources/articles/mysql-storedproc.html). Seems you can only use DDL statements if you CONCAT them into a variable, and then use that...

Moved by request.

Also, I'm not 100% sure, but I think you have to define the tname parameter explicitly, eg:CREATE PROCEDURE createtable(IN tname varchar(20))
BEGIN
DROP TABLE IF EXISTS tname;...