From: Aftab Jahan Subedar (jahanbol-online.com)
Date: Fri Jan 09 2004 - 05:27:58 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Try using QUOTE function.
Asif Iqbal wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi All
>
> I have been using mysql database to collect my syslog data. It was
> working fine. However recently I had few logs that had apotrophe and I
> failed to insert those lines into my database. It said syntax error. Is
> there any patch anything I can put and recompile mysql so it won't fail
> while inserting log lines that has apotrophe (') in it ?
>
> Thanks a lot
>
> - --
> Asif Iqbal
> PGP Key: E62693C5
> There's no place like 127.0.0.1
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (SunOS)
>
> iD8DBQE//LS0UAgaF+Ymk8URAs3xAJ0W8c3tSgWd6xE45qLB25KTSJRv3wCffEb3
> eDhzNcJuik1HH3J8CQYj77A=
> =eUX1
> -----END PGP SIGNATURE-----
>

--

Aftab Jahan Subedar
CEO/Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
North Jatrabari
Dhaka 1204
Bangladesh
http://www.DhakaStockExchangeGame.com/ -
architectDhakaStockExchangeGame.com
http://www.CEOBangladesh.com/ - CEOCEOBangladesh.com
http://www.geocities.com/jahan.geo/ - jahangeocities.com
sms://+447765341890
tel://+88027519050
EMail://jahanbol-online.com - Directly to my notebook

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]