d chop the necassary fields.
thanks to MySQL.
:)
thank yo again for answer...
- Original Message -
From: "Patrick Connolly" <[EMAIL PROTECTED]>
To: "Ferhat BINGOL" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Sunda
Somewhere about Sat, 20-Nov-2004 at 06:27PM +0100 (give or take), Ferhat BINGOL
wrote:
|> Hi,
|>
|> I have a 72 fields data txt file and I was inserting all data
|> previously but now I need only some of them to dump into the table.
|> I would like to select only 4 fields which are the 1st, 5t
ROTECTED]>
To: "Ferhat BINGOL" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMAIL PROTECTED]>
Sent: Saturday, November 20, 2004 10:41 PM
Subject: Re: LOAD DATA INFILE question...
> You can load the file to an intermediate table and then complete your
> process using
&
You can load the file to an intermediate table and then complete your
process using
INSERT INTO targetTable
SELECT col_1, col_5, col_28, col_71
FROM intermediateTABLE
Ferhat BINGOL wrote:
Hi,
I have a 72 fields data txt file and I was inserting all data previously
but now I need only some of them
sean c peters wrote:
But when I load a parent table, an auto_increment column
autogenerates a value that will be a foreign key in a child table. So i cant
create the file to load into the child table until after the parent table has
been loaded. Then i'll need to get back all the auto increment
For this type of custom loading you may want to explore a programming
language such as Java or C/C++ or Perl. Depending on your platform you could
even explore some third party tools.
-Original Message-
From: sean c peters
To: [EMAIL PROTECTED]
Sent: 8/4/04 3:27 PM
Subject: load data infil
[EMAIL PROTECTED] wrote:
In MYSQL documentation the following line is
Some cases are not supported by LOAD DATA INFILE:
1. Fixed-size rows( FIELDS TERMINATED BY and FIELDS ENCLOSED BY both empty)
and BLOB or TEXT columns
I defined a column in a table as type TEXT. I then loaded values using LOA
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 26, 2003 6:55 AM
To: [EMAIL PROTECTED]
Subject: re: RE: load data infile question
Hi!
>On Tuesday 25 March 2003 19:54, Salada Duncan wrote:
>
>> I was able to work around the probl
On Tuesday 25 March 2003 19:54, Salada Duncan wrote:
> I was able to work around the problem by giving "insert" privileges to the
> user for the WHOLE database. This is definitely not optimal because I only
> wish this user to be able to insert into one table in the database. But as
> soon as I
ge-
From: Salada, Duncan [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 11:08 AM
To: 'Victoria Reznichenko'; [EMAIL PROTECTED]
Subject: RE: load data infile question
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 200
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 9:06 AM
To: [EMAIL PROTECTED]
Subject: re: load data infile question
Hi!
On Friday 21 March 2003 20:41, Salada Duncan wrote:
>> I am using MySQL 3.23.49 and have started ha
On Friday 21 March 2003 20:41, Salada Duncan wrote:
> I am using MySQL 3.23.49 and have started having a problem with the "load
> data infile" command.
>
> I recently created a new user with select,insert,update,and delete on one
> table only (tableA). Because I want the user to be able to use "l
What's the error you're getting? What OS are you running on? If it's *nix,
make sure the file you are trying to load, and the full path to that file,
is readable by the user mysql runs as. I once had some files in a user's
home directory I was trying to load and although the file was
world-readable
Hi, Harpreet:
You should use MySQL C API mysql_escape_string(...) to convert that
description field into a legal SQL string before load data infile.
B.R.
budingc
- Original Message -
From: "Harpreet Kaur" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 4
At 20:41 + 3/26/02, Harpreet Kaur wrote:
>I want to transfer data from a table in sql server to mysql. I use
>C:\> BCP dbname.dbo.tblname out tblname.txt -S srvrname -U sa P sapwd -c
>-t \t -r \n
>to write the data to a text file and then use
>load data infile /var/www/html/tblname.txt' i
At 12:45 PM -0700 9/4/01, Curtis Spencer wrote:
>I have a text file with around 25 fields but I only want 5 of them.
>They are not the first 5 fields that I want. Is there a way to skip
>fields using LOAD DATA INFILE so I don't have to build a 25 field table
>and then cut it down?
>
>Thanks,
>Cu
On Tue, 4 Sep 2001, Curtis Spencer wrote:
> I have a text file with around 25 fields but I only want 5 of them.
> They are not the first 5 fields that I want. Is there a way to skip
> fields using LOAD DATA INFILE so I don't have to build a 25 field table
> and then cut it down?
Read the manual
17 matches
Mail list logo
