SQL/MySQL/Backup Load/Load Data Into Table

Load data in txt file into database

   <source lang="sql">

Drop table Bird; CREATE TABLE Bird (

   name VARCHAR(20), 
   owner VARCHAR(20),
   species VARCHAR(20), 
   sex CHAR(1), 
   birth DATE, 
   death DATE

);

INSERT INTO Bird VALUES ("BlueBird","Joe","Car","f","1999-03-30",NULL);

/* Suppose that your Bird records can be described as shown here. (Observe that MySQL expects dates in "YYYY-MM-DD" format; this may be different from what you are used to.

• /

name owner species sex birth death Blue Joe cat f 1993-02-04 Yellow Yin cat m 1994-03-17 Red Richard dog f 1989-05-13

/* Note that if you created the file on Windows with an editor that uses \r\n as a line terminator, you should use:

• /

LOAD DATA LOCAL INFILE "/path/Bird.txt" INTO TABLE Bird LINES TERMINATED BY "\r\n";

      </source>
   
  

load text data into table

   <source lang="sql">

LOAD DATA INFILE "/textFileName.txt" INTO TABLE quackers FIELDS TERMINATED BY ";" LINES TERMINATED BY "\r\n" IGNORE 1 LINES; /*

     Colons, by using ":"
     Semicolons, by using ";"
     Spaces, by using " "

• /

      </source>