Update on Duplicate with Text-Strings?
Hello together
I'm using mySQL 4.1.7 on W2k and have this problem. A statement like
c = is an Integer
SELECT ...
ON DUPLICATE KEY UPDATE c = c + 1
works fine but ...
cStr = is a large Textfield
SELECT ...
ON DUPLICATE KEY UPDATE cStr = Str & 'new text...'
works not
I have tried many combinations like VALUES(cStr), but i mine it is not possible to extend a String... Has anyone an idea, how i can update a String without to send the hold data in the statement?
Regards Peter Witschi
Subject
Views
Written By
Posted
Update on Duplicate with Text-Strings?
5056
November 24, 2004 12:21AM
2493
November 24, 2004 03:28AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.