On Wed, Aug 25, 2010 at 10:05 AM, Ted Rolle Jr. <ster...@gmail.com> 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 I naturally get the whole > table. Would a View help here? Or create a temporary table. > I believe there's a simple solution, but it eludes me. For now.
in the sqlite3 shell, set output mode to file, and then select as above. All your select output will go to your file. -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
