Gentlemen,
I need update a column from another column, like
- update mytable set field1 = field2, field3 = field4*2
as a result field1’s value will be ‘field2’ string. So how can I point fields and expressions for update?
Gentlemen,
I need update a column from another column, like
as a result field1’s value will be ‘field2’ string. So how can I point fields and expressions for update?
The tag does only support constants. If you want to use a more complex update statement, you will need to to use the tag. That allows you to have
Nathan