Library-Management-System/insertAuthortext.sql at main · LauWyeRock/Library-Management-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/LibBooks.txt'
REPLACE INTO TABLE Author
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
(accessionNo, @dummy, author, @dummya2, @dummya3, @dummy2, @dummy3, @dummy4);

LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/LibBooks.txt'
REPLACE INTO TABLE Author
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
(accessionNo, @dummy, @dummya1, author, @dummya3, @dummy2, @dummy3, @dummy4);

LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/LibBooks.txt'
REPLACE INTO TABLE Author
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
(accessionNo, @dummy, @dummya1, @dummya2, author, @dummy2, @dummy3, @dummy4);