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
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
it in manual but I think it is
useful to know it.
Dusan
- Original Message -
From: Duan Pavlica [EMAIL PROTECTED]
To: list mysql mysql@lists.mysql.com
Sent: Monday, April 11, 2005 10:52 AM
Subject: Charset and LOAD DATA INFILE problem
Hello,
I'm trying to convert tables from Paradox DBs
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
I'm using some default table names and such here...my actual code has the
appropriate table, server, un, pw etc...
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
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
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
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 is typically a problem of not having the line
* 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
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
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
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 TABLE IF
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 all
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
Error code
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 it
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.
What was
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 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
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
]
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 63.5
21 matches
Mail list logo