Sunday, July 15, 2012

Are Procedures Supported

I cannot seem to create a procedure.  Is this supported?  I've tried to do it in the API Console and the command line tool google_sql.py.

Below is what I am pasting into the command line tool 

===================================
delimiter $$

DROP PROCEDURE IF EXISTS `addressSelect`$$
CREATE PROCEDURE `addressSelect`(
)
BEGIN
SELECT * from address;
END$$

DELIMITER ;
===================================

Below is what the console spits back at me.

===================================
sql> delimiter $$
  -> 
  -> DROP PROCEDURE IF EXISTS `addressSelect`$$
  -> CREATE PROCEDURE `addressSelect`(
  -> )
  -> BEGIN
  -> SELECT * from address;
ERROR:google_sql: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 'delimiter $ DROP PROCEDURE IF EXISTS `addressSelect`$ CREATE PROCEDURE `addressS' at line 1
sql> END$$
  -> 
  -> DELIMITER ;
ERROR:google_sql: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 'end$ DELIMITER' at line 1
===================================

No comments:

Post a Comment