-
Notifications
You must be signed in to change notification settings - Fork 1
Open
Description
--------------
load data local infile '/tmp/text_memo_cd.tsv' into table text_memo_cd fields terminated by '\t' lines terminated by '\r\n' ignore 1 lines
--------------
Query OK, 1426044 rows affected, 36 warnings (1 min 19.48 sec)
Records: 1426044 Deleted: 0 Skipped: 0 Warnings: 36
--------------
show warnings
--------------
+---------+------+--------------------------------------------------+
| Level | Code | Message |
+---------+------+--------------------------------------------------+
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
+---------+------+--------------------------------------------------+
Metadata
Metadata
Assignees
Labels
No labels