Re: Re: [PHP] Multiple SQLite statements

On 11 Oct 2011 at 03:03, Paul M Foster <paulf@quillandmouse.com> wrote: > On Mon, Oct 10, 2011 at 04:14:00PM +0100, Tim Streater wrote: > >> I would like to use the SQLite3 (not PDO) interface to SQLite, and I >> would like to be able to supply a string containing several SQL >> statements and have them all executed, thus saving the overhead of >> several calls. It *appears* that this may be how it actually works, >> but I wondered if anyone could confirm that. > > -- > Cheers -- Tim >> > > The docs appear to agree that this is allowed. See: > > http://us.php.net/manual/en/function.sqlite-exec.php That's the SQLite interface, though, rather than the SQLite3 one. The latter just says: "Executes an SQL query ...". -- Cheers -- Tim