teratail
回答率
85.47%
質問するログイン新規登録
トップに関する質問【Mysql】CSVファイルをDBにインポートしたい

編集履歴

質問編集履歴

4

書式の改善

2020/08/16 02:59

投稿

yastinbieber
yastinbieber

スコア49

test CHANGED
File without changes
test CHANGED
@@ -106,7 +106,7 @@
106
106
 
107
107
  yasuhiroMacBook:Desktop yastinbieber$ ls
108
108
 
109
- foods_date.csv
109
+ foods_date.csv other files
110
110
 
111
111
  ```
112
112
 

3

追記

2020/08/16 02:59

投稿

yastinbieber
yastinbieber

スコア49

test CHANGED
File without changes
test CHANGED
@@ -109,3 +109,5 @@
109
109
  foods_date.csv
110
110
 
111
111
  ```
112
+
113
+ ![CSVファイル](35918e10a25eff5925cab63cb611e742.png)

2

追記

2020/08/16 02:58

投稿

yastinbieber
yastinbieber

スコア49

test CHANGED
File without changes
test CHANGED
@@ -88,7 +88,7 @@
88
88
 
89
89
  mysql> load data local
90
90
 
91
- -> infile "/Users/yastinbieber/Dropbox/foods_date.csv"
91
+ -> infile "/Users/yastinbieber/Desktop/foods_date.csv"
92
92
 
93
93
  -> into table fooddates
94
94
 
@@ -96,6 +96,16 @@
96
96
 
97
97
 
98
98
 
99
- ERROR 2 (HY000): File '/Users/yastinbieber/Dropbox/foods_date.csv' not found (Errcode: 2)
99
+ ERROR 2 (HY000): File '/Users/yastinbieber/Desktop/foods_date.csv' not found (Errcode: 2)
100
100
 
101
101
  ```
102
+
103
+ ```tarninal
104
+
105
+ yasuhiroMacBook:~ yastinbieber$ cd Desktop
106
+
107
+ yasuhiroMacBook:Desktop yastinbieber$ ls
108
+
109
+ foods_date.csv
110
+
111
+ ```

1

追記

2020/08/16 02:43

投稿

yastinbieber
yastinbieber

スコア49

test CHANGED
File without changes
test CHANGED
@@ -79,3 +79,23 @@
79
79
  Rails 5.2.4.3
80
80
 
81
81
  ruby 2.5.1
82
+
83
+
84
+
85
+ ### 追記
86
+
87
+ ```Mysql
88
+
89
+ mysql> load data local
90
+
91
+ -> infile "/Users/yastinbieber/Dropbox/foods_date.csv"
92
+
93
+ -> into table fooddates
94
+
95
+ -> fields terminated by ',';
96
+
97
+
98
+
99
+ ERROR 2 (HY000): File '/Users/yastinbieber/Dropbox/foods_date.csv' not found (Errcode: 2)
100
+
101
+ ```