Poetry


	287114	9446
	236957	4439
	90089	8872
	49195	2736
	37375	1209
	28419	790
	28219	177
	17700	176
	15736	79
	15367	99
	12464	48
	12058	41
	4586	434
	3426	23
	3020	251
	3019	17
	2741	253
	1948	9
	1170	84
	1118	44
	570	8
	472	40
	363	83
	234	9
	22	7
	2	2
	1	1
	853385	29377

CSV `````` ``

utf8mb4 ?

CSV

python scripts/merge.py

poetry.csv

MySQL 8

CREATE DATABASE poetry CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

use poetry;
CREATE TABLE `poetry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` char(200) DEFAULT NULL,
  `dynasty` char(50) DEFAULT NULL,
  `author` char(100) DEFAULT NULL,
  `content` text,
  PRIMARY KEY (`id`)
);

secure_file_priv

SHOW variables like '%secure_file_priv%';

+------------------+------------------------------------------------+
| Variable_name    | Value                                          |
+------------------+------------------------------------------------+
| secure_file_priv | C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\ |
+------------------+------------------------------------------------+
1 row in set, 1 warning (0.0014 sec)

secure_file_priv Value

poetry.csv secure_file_priv Windows

copy poetry.csv "C:\ProgramData\MySQL\MySQL Server 8.0\Uploads"

CSV

LOAD DATA INFILE 'C:\\ProgramData\\MySQL\\MySQL Server 8.0\\Uploads\\poetry.csv'
INTO TABLE `poetry`
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n' (title, dynasty, author, content);