Nicolay Vasiliev wrote: > Hello there! > > I tried to execute many SQL-clauses ";" separated by DBI::do() method > but got an error message about SQL syntax mistake. If I execute the > same SQL from MySQL shell or some MySQL GUI all works fine. Is > DBI::do() method able to perform many SQL clauses at all? If no what > method or function should I use to perform this?
Current stable versions of MySQL don't support multiple statements in this way. I believe support for this will be added in 5.x, but it *could* be in 4.1.x. Either way, you won't be able to do it for a while. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
