On Apr 22, 12:01 am, Fearless Fool <[email protected]> wrote: > ActiveRecord::StatementInvalid: Mysql::Error: 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 $$' at line 1: > DELIMITER $$ > > I'm still not sure what's going on, since (as I mentioned) I can > hand-type this into dbconsole without getting an error. >
As far as i understand things delimiter is a command/setting that is part of the mysql command line utility, not the dialect of sql spoken by mysql (just like exit, help etc). The doc you linked to says >The first thing we do is to change the command-line client's command delimiter, >to ensure that we can use semicolons inside the stored procedure without the >client regarding them as end-of-statement. >If you're using another client, you should of course skip the delimiter >commands when connecting via activerecord you're using a different client so you get to skip the delimiter stuff. Fred -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
