look up the insert or replace statement, http://www.sqlite.org/lang_insert.html
--- On Wed, 6/3/09, liubin liu <7101...@sina.com> wrote: From: liubin liu <7101...@sina.com> Subject: [sqlite] how to compose the sql sentence? To: sqlite-users@sqlite.org Date: Wednesday, June 3, 2009, 2:05 AM the first step is to tell if there is the data in the table. if the answer is not, I want to insert a row of data into the table if the answer is yes, I need to update the row of data acccording to the data inputting from me. -- View this message in context: http://www.nabble.com/how-to-compose-the-sql-sentence--tp23845882p23845882.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
