problem in table population
Posted: Wed Jun 02, 2004 11:21 am
Hello
I have the following table:
I populate this table using:
LOAD DATA INFILE 'languageSettings.sql' INTO TABLE language_settings;
Here is the content of languageSettings.sql:
For some reason, after the table is populated I get an incorrect langauge_id for the English language:
select * from language_settings;
Somehow the language_id for the first row became 0 instead of 1.
Does anyone know what I am doing wrong?
BTW, I am using MySQL 5.0
I have the following table:
Code: Select all
CREATE TABLE language_settings (
Language_ID INT UNSIGNED NOT NULL,
Lang_Code CHAR(2) NOT NULL,
ISO_Code CHAR(5) NOT NULL,
English_Name VARCHAR(255) NOT NULL,
Locale_Name VARCHAR(255) NOT NULL,
DIR CHAR(3) NOT NULL,
PRIMARY KEY (Language_ID)
) ENGINE=MYISAM;LOAD DATA INFILE 'languageSettings.sql' INTO TABLE language_settings;
Here is the content of languageSettings.sql:
Code: Select all
1 EN en_US English English ltr
2 HE he_IW Hebrew ????? rtl
3 FR fr_FR French Franחais ltrselect * from language_settings;
Code: Select all
+-------------+-----------+----------+--------------+-------------+-----+
| Language_ID | Lang_Code | ISO_Code | English_Name | Locale_Name | DIR |
+-------------+-----------+----------+--------------+-------------+-----+
| 0 | EN | en_US | English | English | ltr |
| 2 | HE | he_IW | Hebrew | +ף+?+¿+?+¬ | rtl |
| 3 | FR | fr_FR | French | Fran+÷ais | ltr |
+-------------+-----------+----------+--------------+-------------+-----+Does anyone know what I am doing wrong?
BTW, I am using MySQL 5.0