Hi Kabbouri
Please see below, an excerpt from the MySQL manual, that answers your
question.
If the FIELDS TERMINATED BY and FIELDS ENCLOSED BY values are both empty
(''), a
fixed-row (non-delimited) format is used. With fixed-row format, no
delimiters are used
between fields (but you can still have a line terminator). Instead, column
values are
written and read using the "display" widths of the columns. For example, if
a column
is declared as INT(7), values for the column are written using 7-character
fields. On
input, values for the column are obtained by reading 7 characters.
Regards
Rory McKinley
Nebula Solutions
+27 82 857 2391
[EMAIL PROTECTED]
"There are 10 kinds of people in this world,
those who understand binary and those who don't" (Unknown)
----- Original Message -----
From: "Kabbouri Mohammed" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 9:58 AM
Subject: LOAD DATA INFILE
> How can I find the way to import a text file with fixed width fields:
> for example:
> Import file content:
> 3750000120031010143902 KABBOURI MOHAMMED
> Imported in:
> Field 1: 3 char : "375"
> Field 2: 5 char : "00001"
> Field 3: 8 char : "20031010"
> Field 4: 6 char : "143902"
> Field 5: 20 char: " KABBOURI"
> Field 6: 20 char: " MOHAMMED"
>
> Regards,
>
> Kabbouri
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
