Re: [sqlite] SQL understanding problem

2008-06-26 Thread Fred Williams
@sqlite.org Subject: Re: [sqlite] SQL understanding problem OK! so rowid should be ok ! thank you! -- View this message in context: http://www.nabble.com/SQL-understanding-problem-tp18142381p18144242.html Sent from the SQLite mailing list archive at Nabble.com

Re: [sqlite] SQL understanding problem

2008-06-26 Thread c.panel
OK! so rowid should be ok ! thank you! -- View this message in context: http://www.nabble.com/SQL-understanding-problem-tp18142381p18144242.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list

Re: [sqlite] SQL understanding problem

2008-06-26 Thread Jay A. Kreibich
On Thu, Jun 26, 2008 at 02:09:14PM -0700, c.panel scratched on the wall: > > I'm new to SQL(ite). > I have two records in a table that have the same values in all columns. I > want to replace a column of only one record. (ex: Firstname Lastname: Pierre > Dupont, Pierre Dupont =>become => Pierre

[sqlite] SQL understanding problem

2008-06-26 Thread c.panel
I'm new to SQL(ite). I have two records in a table that have the same values in all columns. I want to replace a column of only one record. (ex: Firstname Lastname: Pierre Dupont, Pierre Dupont =>become => Pierre Dupont, Paul Dupont). How can I make it with SQL command ? How can I make it with C