On Wed, 6 May 2009 19:13:29 +0200, Daniel Wolny <[email protected]> wrote:
>Hi, >Is possible to increase output of -column? > >1 nightwalker nightwalker.szelka.net 1 >3 nightwalker stolezka.pl 1 >4 nightwalker czteroipolkilogramowya 1 >259 nightwalker satan.edu.pl 1 >260 nightwalker prison.net.pl 1 > >czteroipolkilogramowya should be displayed as czteroipolkilogramowyarbuz.pl In the sqlite command line tool: .width 10 13 30 3 >I need -column sorting type. I'm not sure what you mean here. Guessing: To sort by the third column of your result set, use: SELECT * FROM mytable ORDER BY name_of_third_column; or SELECT * FROM mytable ORDER BY 3; >Thanks in advance. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
