в 13:46, 26 мая 2010

2010-05-26T13:46:00Z

Admin: 1 версия

2010-05-26T10:15:50Z

1 версия

Новая страница

==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>

← Предыдущая	Версия 13:46, 26 мая 2010
(нет различий)

SQL/MySQL/Backup Load/Load Data Into Table - История изменений

в 13:46, 26 мая 2010

Admin: 1 версия