Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
UPDATE tbl1
set name = concat(name, 'aa')
where id in (
    select tbl1_resultalias.nid
    from (
             select id nid
 (select id nid           from tbl1
             where name is not null)
         ) tbl1_resultalias
);


Ref

...