quot;value3","value4"
change it to this: (on each line, search replace maybe?)
"","value1","value2","value3","value4",\n
phpninja
-Original Message-
From: Leonardo Javier Belén [mailto:[EMAIL PROTECTED]
Sent: Thursday
Hi all,
I am experiencing a fairly bizarre problem: in MySQL 4.1.7 (Windoze
version), when importing data from a file with semicolon-separated data, I
get random default values for the datetime fields. This turns the data
obviosly unusable.
The same import on the same machine but with the 4.0.
try this:
1. export the data from ms access to a file on
the windows box.
2. fire up ftp from the command line and set it
to ascii mode.
3. ftp the file from the windows box to the
linux box.
if the eol is the problem, the ftp protocol will
insure that the eol is correctly translated wh
-
From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
Sent: Wednesday, November 06, 2002 1:02 PM
To: Schroeder, Bradley (Contractor); 'Black, Kelly W [PCS]';
[EMAIL PROTECTED]
Subject: Re: Problem importing data from Access
Hi,
You must use a HEX editor to see this characters which are not printa
uot; <[EMAIL PROTECTED]>; "'Gelu
Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 9:41 PM
Subject: RE: Problem importing data from Access
> The text
[EMAIL PROTECTED]
- Original Message -
From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]>
To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
-Original Message-
From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com]
Sent: Wednesday, November 06, 2002 12:34 PM
To: 'Gelu Gogancea'; Schroeder, Bradley (Contractor);
[EMAIL PROTECTED]
Subject: RE: Problem importing data from Access
This is incorrect.
!google &
This is incorrect.
!google "new line character" linux windows
-Original Message-
From: Gelu Gogancea [mailto:ggelu@;arctic.ro]
Sent: Wednesday, November 06, 2002 11:33 AM
To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor);
[EMAIL PROTECTED]
Subject: Re: Problem importing
PROTECTED]
- Original Message -
From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]>
To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 20
r 06, 2002 10:54 AM
To: Schroeder, Bradley (Contractor); [EMAIL PROTECTED]
Subject: Re: Problem importing data from Access
Hi,
Are you sure that .txt file is OK?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
adley (Contractor)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 7:06 PM
Subject: Problem importing data from Access
> When I import data from the text file I exported out of Access it works
> correctly except that MySql seems to append and/or pr
When I import data from the text file I exported out of Access it works
correctly except that MySql seems to append and/or prepend some sort of
mystery character to the fields it imports. So, I can get the data into the
database, but I can't get it out (since the SQL statement can't match the
myst
Reformat your import file.
or
Add two columns , import, and drop the two columns.
or
Import to a six column temporary file and do an
insert into select from.
tl wrote:
>Hello,
>
>#If I have a file "t.txt"
>
>
>111 222 333 ddd 444 ddd
>111 222 333 ddd 444 ddd
>111 222 333 ddd 444 ddd
><<
>
Hello,
#If I have a file "t.txt"
>>
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
<<
# A table
>>
CREATE TABLE userdata (
a1 varchar(128) NOT NULL default '',
a2 varchar(128) NOT NULL default '',
a3 varchar(128) NOT NULL default '',
a4 varchar(128) NOT NULL default '',
Hi guys,
I want to migrate data from SQL Server 2000 to Mysql.I have two
problems. First is easy one,
First problem is to migrate big fields which had type varchar(7900) or
so I tried using Text datatype of mysql, is that the right one or I
should have used BLOB. That field doesnt contain any i
Hi guys,
I want to migrate data from SQL Server 2000 to Mysql.
My problem is to migrate big fields which had type varchar(7900) or so
I tried using Text datatype of mysql, then I cant migrate data in that
field
I used command
LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt" INTO TABL
Hi,
I want to migrate data from SQL Server 2000 to Mysql.
My problem is to migrate big fields which had type varchar(7900) or so
I tried using Text datatype of mysql, then I cant migrate data in that
field
I used command
LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt" INTO TABLE
mai
17 matches
Mail list logo
