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
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, 5th,28th and 71st
fields.
Is there a statement to do that.
I have read http://dev.mysql.com/doc/mysql
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
I haven't used load data infile much, mainly because of issues like this
question. I want to load a bunch of data for our data warehouse into about 10
different tables. 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
[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
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 LOAD
DATA INFILE into the tabl
-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
h the file was
world-readable, the directory permissions restricted access.
--jeff
- Original Message -
From: "Salada, Duncan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 21, 2003 10:41 AM
Subject: load data infile question
> Hi everyone,
>
>
Hi everyone,
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 "load data
infile" to load records into tableA, I
On Tuesday 17 December 2002 11:08, moka at hol dot gr wrote:
> I am looking at the following situation:
> I am reading some files arriving every minute and parsing them and
> creating a set of files ready to be inserted into tables.
> on the fly. While I am waiting for the next
sql,query
Hi,
I am looking at the following situation:
I am reading some files arriving every minute and parsing them and
creating a set of files ready to be inserted into tables.
on the fly. While I am waiting for the next burst of files, I want to
insert these in
nesday, March 27, 2002 4:41 AM
Subject: load data infile question
> 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
> lo
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
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' into table tblname;
It works fine for all the tabl
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
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,
Curtis
Ok, the company I work for does not host its own websites, etc.. we pay a company for
space on their servers. They use Unix boxes and the database they support is MySQL
with a PHPMyAdmin GUI. Here is my dillema.. I need to move some of our existing
Microsoft (Excel and Access) databases to MySQ
I have a one time load of an extremely large file. It's a tab delimited
file, the problem I'm getting is importing the following field.
C:\Borland\server\bin\gbak.exe- The field how it looks on the import
file (it's delimited by tabs)
C:Borlandserver ingbak.exe - How it looks onc
27 matches
Mail list logo