Hello,
after switching from MySQL 5.0.67 to 5.1.59 we get the following problem:
We want to import data from a textfile
example of the textfile:
t...@test.com$yes$432145$xyz
The command is: LOAD DATA LOCAL INFILE 'textfile.txt' INTO TABLE TESTTABLE
FIELDS TERMINATED BY '$';
Selecting the data
note about it in manual but I think it is
useful to know it.
Dusan
- Original Message -
From: "Dušan Pavlica" <[EMAIL PROTECTED]>
To: "list mysql"
Sent: Monday, April 11, 2005 10:52 AM
Subject: Charset and LOAD DATA INFILE problem
Hello,
I'm trying to conve
Hello,
I'm trying to convert tables from Paradox DBs to MySQL and I have a big problem
with setting correct character set. I created small application which generates
csv files which are in cp1250 (I can't change it, it's charset ofmy Paradox
DBs). My databases and tables in MySQL are in latin2
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 takes the file on the se
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
Hi List.
I have been working on a problem that is driving me crazy.
I have to create a process in which I upload some info to a table. Since I
have to add some different information to that table, I decided to do it
like this.
1.I create a temporary table copying the structure of my final table.
* 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
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 TABLE IF EXISTS testthis;
Query OK, 0 rows affected (0.16 sec)
mysql> CREATE TABLE t
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.
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.
i've tried by removing the 'local', but i
I am trying to import a text file that is tab delimited.
I am using the following , but it only returns one line.
LOAD DATA INFILE '/Users/martinsc/documents/jillslist.txt' INTO TABLE
Customers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';
Why would it do one line and then stop? MySQL i
I am trying to import a text file that is tab delimited.
I am using the following , but it only returns one line.
LOAD DATA INFILE '/Users/martinsc/documents/jillslist.txt' INTO TABLE
Customers FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n';
Why would it do one line and then stop? MySQL i
ECTED]
Subject: LOAD DATA INFILE Problem
Stupid problem this one no doubt.
I have a find in mysql\bin called words.txt
The file contains tab separated values with a newline character at the end:
225 20 Residence 73.563.580 187.5
225 20 Planibel195.5
Stupid problem this one no doubt.
I have a find in mysql\bin called words.txt
The file contains tab separated values with a newline character at the end:
225 20 Residence 73.563.580 187.5
225 20 Planibel195.5 63.579.5289
When I do
LOAD DA
22 matches
Mail list logo
