в 13:46, 26 мая 2010

2010-05-26T13:46:00Z

Admin: 1 версия

2010-05-26T10:15:52Z

1 версия

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

==Load backup file into new table==



<source lang="sql">
Drop table CDs;
CREATE TABLE CDs (
CDID SMALLINT NOT NULL PRIMARY KEY,
CDName VARCHAR(50) NOT NULL,
InStock SMALLINT UNSIGNED NOT NULL,
Category VARCHAR(20)
);

INSERT INTO CDs
VALUES (101, "Blood", 10, "Rock"),
(102, "Jazz", 17, "Jazz"),
(103, "Class", 9, "Classical"),
(104, "Violin", 24, NULL),
(105, "Blues", 2, "Blues"),
(106, "Tires", 12, "Country"),
(107, "Essence", 5, "New Age"),
(108, "Magic", 42, "Classical"),
(109, "Name", 20, "Opera"),
(110, "Fire", 23, "Country"),
(111, "Live", 18, "Jazz"),
(112, "Blues", 22, "Blues"),
(113, "Stages", 42, "Blues");

SELECT CDName, InStock, Category INTO OUTFILE "Backup.sql"
FIELDS
TERMINATED BY ","
ENCLOSED BY """
FROM CDs WHERE Category="Country";
CREATE TABLE CDs3 (
CDID SMALLINT NOT NULL PRIMARY KEY,
CDName VARCHAR(50) NOT NULL,
InStock SMALLINT UNSIGNED NOT NULL,
Category VARCHAR(20)
);

LOAD DATA INFILE "Backup.sql"
INTO TABLE CDs3
FIELDS
TERMINATED BY ","
ENCLOSED BY """;

mysqlimport --user=root --password=pw1 --fields-terminated-by="," --fields-enclosed-by="*" test "c:\CDs3.sql"

</source>

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

SQL/MySQL/Backup Load/Load Text File - История изменений

в 13:46, 26 мая 2010

Admin: 1 версия