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,
.
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: Sunday, November 21, 2004 10:00 AM
Subject: Re: LOAD DATA INFILE question...
Somewhere about Sat, 20
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
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
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
INSERT INTO targetTable
SELECT col_1, col_5, col_28, col_71
FROM
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
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
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
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
[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
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 gave
-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 problem by giving
[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, 2003 9:06 AM
To: [EMAIL PROTECTED]
Subject
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 load
-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 having a problem
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
-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,
I am using MySQL 3.23.49 and have started having a problem
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
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
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
load data infile ?var/www/html/tblname.txt' into table
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
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' into
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
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
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,
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
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
27 matches
Mail list logo