List:MySQL and Perl« Previous MessageNext Message »
From:Jochen Wiedmann Date:May 3 2002 10:33pm
Subject:Re: UPDATE statemnt
View as plain text  
Zitiere Darragh Buffini <DARRAGH.BUFFINI@stripped>:

> I keep getting a syntax error when executing an UPDATE statement which
> contains an apostrophe ( ' ) as one of the characters in the field to be
> updated. Does anyone know of a way around this?
> Strangely enough this problem never arose with the INSERT

Use placeholders or "quote". See "perldoc DBI".
UPDATE statemntDarragh Buffini3 May
  • Re: UPDATE statemntJochen Wiedmann4 May
  • UPDATE statemntMichael Widenius6 May