That command is set more secure on the version you use v3.23.53
That's one of the reason why I kept the old version running, which is
v3.23.44
I cant find a way to upgrade to the latest which is giving me headache when
it comes to LOAD DATA statement
I also found out that the LIBMYSQL.DLL used in the latest version is more
secure too...but if you can have the old LIBMYSQL.DLL you can use it.
Check also your statement if followed the correct syntax in loading file
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No. (Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)
-----Original Message-----
From: Weiwei Wang [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 1:29 PM
To: [EMAIL PROTECTED]
Subject: Re: MySQL & Delphi 6
hi,
could you tell me how to load a txt into my table?
I use the comand :
mysql> LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet;
But it fails,the error information is:
ERROR 1148: The used command is not allowed with this MySQL version
I am using the mySql3.23.53 version.
Doesn't this version support the load function?
BTW,how to transfer the Access database into MySql db?
thanks a lot.
weiwei
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, November 20, 2002 12:07 AM
Subject: RE: MySQL & Delphi 6
You can download winzeos for delphi
I use it when connecting to MySQL
Try searching it in google
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No. (Office) (088) 858-1028
(Home) (088) 858-8889
Mobile No. (63) (919-3085267)
-----Original Message-----
From: Patricio Díaz G. [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, November 20, 2002 1:34 PM
To: [EMAIL PROTECTED]
Subject: MySQL & Delphi 6
Can somebody help me with Delphi 6 and MySQL?
I'm using Delphi en a WinXP box and the MySQL server in a Linux box.
I am
having trouble connecting to the server with the CLX/dbExpress
TSQLConnection component.
Please, if somebody can help me, let me know and I'll explain the
whole
situation.
Regards,
Patricio
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
