Re: [sqlite] Length=10

So simple. I never thought of using the command-line sqlite3... > in the sqlite3 shell, set output mode to file, and then select as > above. All your select output will go to your file. > > ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Length=10

On Wed, Aug 25, 2010 at 10:05 AM, Ted Rolle Jr. wrote: > I have a table of UPCs with lengths varying from 6 to 12.  I'd like to > print those with length=10 to a file for printing. > SELECT * >  FROM UPCs >  WHERE LENGTH(UPC)=10; > works just fine.  But when I export the table

[sqlite] Length=10

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a table of UPCs with lengths varying from 6 to 12. I'd like to print those with length=10 to a file for printing. SELECT * FROM UPCs WHERE LENGTH(UPC)=10; works just fine. But when I export the table I naturally get the whole table. Would