Oh yes! "set" is the solution. I know that I have missed something... thanks a lot.
no possibilities for indexing on an expression : is it a particularity of SQL or SQLite ? Igor Tandetnik wrote: > > c.panel <[EMAIL PROTECTED]> wrote: >> I'm learning SQL and SQLite C API. >> >> 1)Suppose I have a table with many columns indexed on a column. >> I want to change one value in a column only. >> How can I make it with SQL ? > > If I understand your question, you want something like this: > > update tableName set columnName=:newValue where columnName=:oldValue; > >> 2)Is it possible to index a table on an expression (composed from >> column names) ? > > No. > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/SQL-questions-tp18157126p18159723.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
