Re: appending to longtext field

2003-03-19 Thread Mr Orange
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 s

appending to longtext field

2003-03-19 Thread Mr Orange
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

Fw: Swapping around values in a database

2003-03-15 Thread Mr Orange
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",