create a new table and copy the data from your source table by doing lower(col1), drop the old table and rename the new table to old table.
On Fri, Mar 16, 2012 at 3:56 AM, Richard <codemon...@163.com> wrote: > if I wang to update a table, e.g, > > insert overwrite table mytable > select lower(col1), col2, col3 from mytable; > > if mytable has many columns but I only need to update one of them, how can > I write the > statement short? > > > >
