I think u've got to type the query after typing(next to) ANALYZE. -----Original Message----- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 12, 2006 8:58 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQL error: near "ANALYZE": syntax error
SQLite 3.2.2 does not support ANALYZE. I think it first appears in SQLite 3.2.3. --- Steve Bergman <[EMAIL PROTECTED]> wrote: > I feel kind of silly asking this. I must be doing something really silly. > > I go into the command line client with: > > $ sqlite3 filename.db > > at the sqlite> prompt, I type: > > ANALYZE; > > and I get: > > SQL error: near "ANALYZE": syntax error > > I am running sqlite 3.2.2. > > What am I doing wrong? > > Thanks, > Steve > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
