Answer the question
In order to leave comments, you need to log in
MySQL. How to upload data in Linux (Mint)?
I could not solve the problem with encodings in Windows, I switched to Linux, hoping that I would forget this hemorrhoid and finish the course, but no ...
Cyrillic even in UTF-8 and the bash shell managed to be saved like this:
+------------+----------------------------------------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+----------------------------------------------------+------+-----+---------+-------+
| id_station | smallint(2) unsigned zerofill | NO | PRI | 00 | |
| name | varchar(30) | NO | | NULL | |
| type | enum('?????????','?????????????','??????????????') | NO | | NULL | |
+------------+----------------------------------------------------+------+-----+---------+-------+
mysql> load data local infile '/home/egor/desktop/CityNetwork' into table CityNetwork
-> fields terminated by '\t' lines terminated by '\n';
ERROR 1148 (42000): The used command is not allowed with this MySQL version
mysql> select version();
+-------------------------+
| version() |
+-------------------------+
| 5.5.49-0ubuntu0.14.04.1 |
+-------------------------+
1 row in set (0.02 sec)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question