Re: [sqlite] Statements that return a result set?

On Thu, Jul 30, 2009 at 5:12 AM, Robert
Villanoa<robertvillanoa@xxxxxxxxx> wrote:
> Hi folk,
>
> I am new to SQLite, and I have a question: In SQLite, is there a statement 
> apart from SELECT statement that can return a result set? Or the SELECT 
> statement is the only statement that can return a result set?
>

Nothing personal about SQLite here... SELECT is a SQL standard clause,
and as the name implies, does the job of returning a result set. DDL
and DML portions of SQL do other things such as ALTER the table or
UPDATE/DELETE/INSERT, etc. However, if you want something back, then
yes, SELECT is your friend.


> Thank you for reading my question!
>
> Robert.
>
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@xxxxxxxxxx
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
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
=======================================================================
Sent from Madison, WI, United States
_______________________________________________
sqlite-users mailing list
sqlite-users@xxxxxxxxxx
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users