mysql导入数据的两种方式

• 第一种：将以上数据整理成SQL语句，insert into pet…

• 第二种：通过加载文件的方式将数据导入到表中
  1、创建一个pet.txt的文件（注：每个字段中用tab键隔开，字段没有值得记录用\N代替）
  Fluffy Harold cat f 1993-02-04
  Claws Gwen cat m 1994-03-17
  Buffy Harold dog f 1989-05-13
  Fang Benny dog m 1990-08-27
  Bowser Diane dog m 1979-08-31 1995-07-29
  Chirpy Gwen bird f 1998-09-11
  Whistler Gwen bird \N 1997-12-09 \N
  Slim Benny snake m 1996-04-29

  2、加载数据
  mysql> load data local infile ‘/root/data/pet.txt’ into table pet;
  Query OK, 8 rows affected, 6 warnings (0.06 sec)
  Records: 8 Deleted: 0 Skipped: 0 Warnings: 6
  3、校验是否加载进去
  mysql> select *from pet;
  ±---------±-------±--------±-----±-----------±-----------+
  | name | owner | species | sex | birth | death |
  ±---------±-------±--------±-----±-----------±-----------+
  | Fluffy | Harold | cat | f | 1993-02-04 | NULL |
  | Claws | Gwen | cat | m | 1994-03-17 | NULL |
  | Buffy | Harold | dog | f | 1989-05-13 | NULL |
  | Fang | Benny | dog | m | 1990-08-27 | NULL |
  | Bowser | Diane | dog | m | 1979-08-31 | 1995-07-29 |
  | Chirpy | Gwen | bird | f | 1998-09-11 | NULL |
  | Whistler | Gwen | bird | NULL | 1997-12-09 | NULL |
  | Slim | Benny | snake | m | 1996-04-29 | NULL |
  ±---------±-------±--------±-----±-----------±-----------+
  8 rows in set (0.01 sec)