Skip to Content
0
Former Member
Jul 28, 2014 at 04:36 PM

how to read/update text column?

14 Views

I have a table with text column. there is text data in this column.

I want to get the value and update it.

For example, suppose the data for text column is:

this is line 1.

this is line 2.

this is line 3.

this is line 4.

this is line 5. ...

...

this is line 10000.

I want to insert one more line in text value, the new value would be like:

this is line 1.

this is line 2.

this is new line.

this is line 3.

this is line 4.

this is line 5. ...

...

this is line 10000.

I try to use select mytextcolumn from mytab, but only get part of it from output.

how to get the full value and then put it in notepad to edit, then copy.paste it back to database?