Thanks a lot guys. I tried my insert using MYSQL Query Browser and
manage to insert the syslog. Remo, you're correct, the Windows Command
prompt limitation is the cause since i'm using windows xp cmd.exe.
I'll try to do import as you've suggested.
What a relief, i can proceed in building my syslog
Liz you didn't mention by I suppose you're using Windows client too i.e.
mysql.exe. A quick test revealed that in such a case char limit is <=255
i.e. that's limitation of Windows Command Prompt: command.com or in case
of Win NT,2000,XP - cmd.exe
try writing your long SQL command in text file a
Dear Guys,
Can please anyone advice me how to successfully insert long text data
into my innodb table rawlog with table stucture as follows:
mysql> desc rawlog;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+