mysql> create table student(
-> student_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> name VARCHAR(20) NOT NULL,
-> department_id INT,
-> birth DATE,
-> city VARCHAR(20)
-> );
Query OK, 0 rows affected (0.00 sec)
mysql> LOAD DATA LOCAL INFILE "C:/data/student.txt"
-> FIELDS
-> TERMINATED BY '\t'
-> ENCLOSED BY ''
-> ESCAPED BY '\'
-> LINES TERMINATED BY '\n';
Query OK, 20 rows affected (0.00 sec)
Records: 20 Deleted: 0 Skipped: 0 Warnings: 100
THE CONTENT OF "student" IS:
100 linshengzhi 2 1976-12-06 BEIJING
101 yanghua 2 1980-10-11 SHANGHAI
102 zhongxin 2 1980-12-01 CHENGDU
103 huanghe 2 1978-01-02 GUANGZHOU
104 changjiang 2 1978-01-02 BEIJING
105 chaocao 3 1975-01-02 SHANGHAI
106 zhouyu 3 1975-01-02 FUJIAN
107 zhugeliang 3 1977-01-04 XIANGYANG
108 huanggai 3 1954-04-05 JIANGDONG
109 huanggai 3 1954-04-05 JIANGDONG
110 linzhi 4 1976-12-06 BEIJING
111 yanghua 4 1980-10-18 SHANGHAI
112 zhongxin 4 1977-12-01 CHENGDU
113 huanghe 4 1978-01-02 GUANGZHOU
114 changjiang 4 1978-01-02 BEIJING
115 chaomengde 2 1975-01-02 SHANGHAI
116 zhougongjing 1 1975-01-02 FUJIAN
117 zhugeliang 1 1977-01-04 XIANGYANG
118 huanggongfu 1 1954-04-05 JIANGDONG
BUT WHEN I USE :
mysql> select student_id,name,department_id,birth,city from student;
IT SHOW ME :
+------------+------+---------------+-------+------+
| student_id | name | department_id | birth | city |
+------------+------+---------------+-------+------+
| 100 | | NULL | NULL | NULL |
| 101 | | NULL | NULL | NULL |
| 102 | | NULL | NULL | NULL |
| 103 | | NULL | NULL | NULL |
| 104 | | NULL | NULL | NULL |
| 105 | | NULL | NULL | NULL |
| 106 | | NULL | NULL | NULL |
| 107 | | NULL | NULL | NULL |
| 108 | | NULL | NULL | NULL |
| 109 | | NULL | NULL | NULL |
| 110 | | NULL | NULL | NULL |
| 111 | | NULL | NULL | NULL |
| 112 | | NULL | NULL | NULL |
| 113 | | NULL | NULL | NULL |
| 114 | | NULL | NULL | NULL |
| 115 | | NULL | NULL | NULL |
| 116 | | NULL | NULL | NULL |
| 117 | | NULL | NULL | NULL |
| 118 | | NULL | NULL | NULL |
| 119 | | NULL | NULL | NULL |
+------------+------+---------------+-------+------+
20 rows in set (0.00 sec)
SO ,WHERE DO THE CONTENT OF (name,department,birth,city)GO???
I USE MySQL ON winxp~!
