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 Dupont, Paul Dupont). If *all* the columns are the same, you can't. Except... all columns can't be the same. Unless the user over-rides it, all tables have a "rowid" column that *must* be unique. Since the column is automatically created by the database, it isn't shown with a "select * from...", however. Try "select rowid, * from..." and use the rowid to pick out a specific row for modification. > How can I make it with SQL command ? > How can I make it with C API ? The C API uses SQL, so there isn't anything you can do with the C API you can't do with SQL itself. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "'People who live in bamboo houses should not throw pandas.' Jesus said that." - "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
