SQL/MySQL/Backup Load/Save To Text File — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
Admin (обсуждение | вклад) м (1 версия) |
(нет различий)
|
Текущая версия на 13:15, 26 мая 2010
Backup records into txt file
<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";
</source>
Backup table records into txt file: indicate terminator
<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="Classical";
</source>