Re: Many SQL clauses executing

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 clause

RE: Many SQL clauses executing

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. You must execute statements one at a time with do(). Don't add semicolons at the end. > If I execute the > same SQL from MySQL sh

Many SQL clauses executing

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 fu