[R-sig-DB] updating values

Sean Davis @d@v|@2 @end|ng |rom m@||@n|h@gov
Thu Jun 17 15:32:15 CEST 2010


On Thu, Jun 17, 2010 at 9:21 AM, Daniel <dmsilv using gmail.com> wrote:

> Hello all,I have a table with about 18000 rows, I need to UPDATE the
> strings
> in the "name.x" column in each row by the strings from "name.y" given if
> "name.x" is NA or " ". How can I do it?
>

You didn't really give us enough information to answer your question (what
database, what interface, etc.)  However, you'll probably want to use a SQL
update statement.  The syntax will vary slightly depending on database
engine and a little googling will probably get you the answer you need.

Sean


> Also I want to update values in other columns, but I think that will be the
> same job.
> Daniel
> --
> Daniel Marcelino
> http://bit.ly/pol4vc
>
>        [[alternative HTML version deleted]]
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>

	[[alternative HTML version deleted]]




More information about the R-sig-DB mailing list