Hello all,
I have a database with a type longtext called notes.
Say I wanted to append some text to this field, what command would I use?
I have tried the following sql..
update clients set notes=notes+text to append where id=1;
But this doesn't seem to do the job.
I am new to MySQL so
GV wrote:
I think is better to have an additional record each time a user
inserts
new information
Mr Orange wrote:
Hello all,
I have a database with a type longtext called notes.
Say I wanted to append some text to this field, what command would I
use?
I have tried the following sql
Hello all : )
Can anyone offer any advice on how to achieve the following with SQL?
Say I have a table.
CREATE TABLE page (
pgposition int(6) not null,
pgelement char(20) not null default '',
pgsize int(4) not null default '0'));
and it has this data in.
1,TEXT,20
2,TEXT,30