ホーム > その他 > mysql 日本語load

mysql 日本語load

2012 年 3 月 8 日 コメントをどうぞ コメント

でCSVロードをしたときに少し引っかかった。

 

ロードコマンド

load data infile “ファイルパス” into table テーブル名 fields terminated by ‘,’ enclosed by ‘”‘;

CSVなのでカンマ区切り(fields terminated by ‘,’) 文字囲み(enclosed by ‘”‘)指定。

 

エラーになった。

ERROR 1045 (28000): Access denied for user ‘ユーザ名’

なんて言われました。

追加したユーザで実行したのですが、特定のDB以外の権限をつけてませんでした。

マニュアル;

ロードにはFile権限が必要です。

はい。すみません。

 

次はエラーにはならなかったが、warningが大量。

テーブルを見るとまともに入ってませんね。

これは文字コードが問題だったらしい。当然といえば当然か・・・。

windowsローカル環境にmysqlを置いているが、mysqlの文字コードはutf8にしている。

なので、ローカルで作成したsjisをロードしてエラーになった。

さくらエディタでファイルの文字コードを指定して保存。この時改行コードも指定する。

これでうまくいった。

他にも文字コード設定を変える方法もあるだろうけど、繰り返し実行しないなら開いて保存だけの方が速い。

関連する記事

Then there’s the domestic violence issue, epitomised by the likes of Rice and Adrian Peterson, the Minnesota Vikings running back charged with abuse of his four year old son, and the casual gun culture that ensnared Plaxico Burress, of the New York Giants, who in 2008 contrived to shoot himself in a Manhattan nightclub with an unlicenced pistol.Subscribe to USA TODAYAlready a print edition subscriber, but don’t have a login?Activate your digital access.Manage your account settings. ET Oct. ET Oct. 25, 2016Denver Broncos head coach Gary Kubiak leaves the field after greeting Houston Texans quarterback Brock Osweiler after after an NFL football game, Monday, Oct. 24, 2016, in Denver. Both the major and minor leagues have created camps and clinics MLB launched theirs back in 2006 to focus Authentic NFL Jerseys on recruiting umpires. Dellinger said such efforts were made, in part, to work toward diversifying the pool. However, even this past year, none of MLB’s scholarships for umpire school went to a woman.To be sure, those three have accumulated better numbers (Brady on a per game basis because he was suspended for four cheap china jerseys games). But Stafford who has been widely criticized in the past for errant, untimely turnovers and inconsistent play has become a model of consistency in his own right.Now before I turn the http://www.cheapnfljerseyssu.com call over to Bruce and Pat for a more detailed review of our Latin American financials, I’d like to offer just a few observations. On the top line, we’re continuing to see solid growth from Advanced Services in premium channels, as well as double digit growth in our commercial sales, although pay per view revenues were a little soft in the quarter, mostly due to the timing Oakley Sunglasses Outlet of events. In terms of our net additions, the lackluster economy and a tough competitive landscape drove our churn slightly higher than we initially forecast. The wholesale jerseys china pickup in competitive intensity that we saw coming out of the first quarter is yet to abate, I would say, when I look at the marketplace in general. Triple play offers, without contractual cheap jordans commitments, and higher cashback incentives by both the cable operators and telco providers, along with the consumers who are wholesale nfl jerseys increasingly under stress from an ongoing weak economy have resulted in more price conscious consumers shopping for better deals.MARTIN: Nate Jackson is a former NFL wide receiver. His memoir “Slow Getting Up” was a New York Times best seller. His latest book is “Fantasy Man: A Former NFL Player’s Descent Into The Brutality Of Fantasy Football.” He was with us from NPR West in Culver City, Calif. Nate Jackson, thanks so much for speaking with us.

関連する記事

カテゴリー: その他 タグ: ,
  1. コメントはまだありません。
  1. トラックバックはまだありません。