I'm using some default table names and such here...my actual code has the
appropriate table, server, un, pw etc...
Montagna, Dan wrote:
Hello,
I'm a very new mysql/php user and am trying to use the load data infile
command without luck. I'd like to replace a table using a text file but
can't get it to work. I set up a test table with no records using a telnet
console. I'm trying to write a php page that ta
Para: [EMAIL PROTECTED]
Asunto: Re: Re: Load Data Infile problem.
The thing is that it will import one, and skip one full record each time.
But the one it inserts, is correctly inserted with the ; and the decimal
point correct. Any idea why it might be pasing one row and adding one?
This
The thing is that it will import one, and skip one full record each time.
But the one it inserts, is correctly inserted with the ; and the decimal
point correct. Any idea why it might be pasing one row and adding one?
This is typically a problem of not having the line-ending terminator
specified
* Clayburn W. Juniel, III <[EMAIL PROTECTED]> [021012 07:30]:
> >I am attempting to delete a table from a database,
> >then recreate it and load data into the table.
> >The drop and create commands are working properly,
> >here's a screen dump:
<..>
> >mysql> LOAD DATA INFILE
> >"
On Friday, Oct 11, 2002, at 15:21 America/Phoenix, Tim Johnson wrote:
> Hello All:
> I am attempting to delete a table from a database,
> then recreate it and load data into the table.
> The drop and create commands are working properly,
> here's a screen dump:
>
> mysql> DROP TA
Tim,
Saturday, October 12, 2002, 1:21:59 AM, you wrote:
TJ> I am attempting to delete a table from a database,
TJ> then recreate it and load data into the table.
TJ> The drop and create commands are working properly,
TJ> here's a screen dump:
TJ> mysql> DROP TABLE IF EXISTS tes
Try putting the file into the MySQL directory, or one the that mysql has
permissions on. I bet 2 cents it will work.
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 13, 2002 6:52 PM
> To: LR P; [EMAIL PROTECTED]
> Subject: Re: l
At 22:21 + 8/13/02, LR P wrote:
>thanx 4 your reply:
>
>
>this is the error message that i got when i tried using the full pathname.
>
>mysql> LOAD DATA INFILE "/home/ihot/member.txt" INTO TABLE member;
>ERROR 13: Can't get stat of '/home/ihot/member.txt' (Errcode: 13)
>mysql>
% perror 13
Err
thanx 4 your reply:
this is the error message that i got when i tried using the full pathname.
mysql> LOAD DATA INFILE "/home/ihot/member.txt" INTO TABLE member;
ERROR 13: Can't get stat of '/home/ihot/member.txt' (Errcode: 13)
mysql>
i've tried using another user account (of course i've set a
At 2:16 + 8/13/02, LR P wrote:
>hi all,
>
>
>i have a problem with "load data..." statement. i'm using MySQL
>3.23.49 from RedHat 7.3. i read Paul DuBois book about MySQL, and
>tried to load data to my member table,
>mysql> LOAD DATA INFILE "member.txt" INTO TABLE member;
>but i didn't work.
Sorry, my fault, realised the file I was writing for VB was cocking it up.
I was adding chr(13) at the end, but the FileSystemObject write method
seemed to be putting the carriage return in too, so MYSQL didn't get the
newline character.
I changed to use the Print command in VB instead just wri
12 matches
Mail list logo
