Re: Updating a LONGTEXT field

2005-11-14 Thread Whil Hentzen
I've looked at concat and other string functions as well as searched on 'update' and 'longtext', but the results haven't been useful. Am I missing something easy, or will this be more involved than a simple one-line SQL statement? You obviously didn't look at CONCAT that hard... UPDATE

Updating a LONGTEXT field

2005-11-11 Thread Whil Hentzen
Hi folks, I'm converting a database to MySQL, and rewriting the code to work with MySQL from the old datastore. One of the fields in one of the tables is a longtext type that contains a history of system accesses - each time the system is touched in one form or another, a few more lines of

Re: Updating a LONGTEXT field

2005-11-11 Thread Jasper Bryant-Greene
Whil Hentzen wrote: Hi folks, I'm converting a database to MySQL, and rewriting the code to work with MySQL from the old datastore. One of the fields in one of the tables is a longtext type that contains a history of system accesses - each time the system is touched in one form or another,