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