[B! æ–‡å—ã‚³ãƒ¼ãƒ‰] roogh5eeSha6ã®ãƒ

roogh5eeSha6 id:roogh5eeSha6

æ–‡å—ã‚³ãƒ¼ãƒ‰ã«é–¢ã™ã‚‹roogh5eeSha6ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

MySQL ç•°ãªã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³é–“ã§ã®mysqldumpãŠã‚ˆã³ãƒªã‚¹ãƒˆã‚¢ã«ã¤ã„ã¦ - Database JUNKY
ç•°ãªã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã€ã‚‚ã—ãã¯ã€ç•°ãªã‚‹ ã‚µãƒ¼ãƒé–“ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®dump (mysqldump) ãŠã‚ˆã³ restore ãƒªã‚¹ãƒˆã‚¢ã‚’å®Ÿæ–½ã—ãŸæ™‚ã«ã€ãƒªã‚¹ãƒˆã‚¢å…ˆã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚ãƒ†ãƒ¼ãƒ–ãƒ«ã‚‚ãªã„ã¯ãšãªã®ã«ã€ã‚ãƒ¼é‡è¤‡ï¼ˆDuplicate entry)ãŒèµ·ããŸã‚Šã—ãŸã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿ ãˆï¼Ÿã€ãªã«ã‚‚ãªã„ã¯ãšãªã®ã«ã€‚ã€‚ã€‚ã£ã¦ã€‚ã‚ªã‚«ãƒ«ãƒˆã§ã™ã‚ˆãã€‚ ã“ã®åŽŸå› ã£ã¦ã€dumpæ™‚ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒåŽŸå› ã—ã¦ã„ã‚‹å ´åˆãŒå¤šã„ã§ã™ã£ã¦è©±ã§ã™ã€‚ã€‚ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®æ–‡å—ã‚³ãƒ¼ãƒ‰æŠ€è¡“å…¥é–€ (WEB+DB PRESS plus) (WEB+DB PRESS plusã‚·ãƒªãƒ¼ã‚º) ä½œè€…: çŸ¢é‡Žå•“ä»‹å‡ºç‰ˆç¤¾/ãƒ¡ãƒ¼ã‚«ãƒ¼: æŠ€è¡“è©•è«–ç¤¾ç™ºå£²æ—¥: 2010/02/18ãƒ¡ãƒ‡ã‚£ã‚¢: å˜è¡Œæœ¬ï¼ˆã‚½ãƒ•ãƒˆã‚«ãƒãƒ¼ï¼‰è³¼å…¥: 34äºº ã‚¯ãƒªãƒƒã‚¯: 578å›žã“ã®å•†å“ã‚’å«ã‚€ãƒ–ãƒã‚° (129ä»¶) ã‚’è¦‹ã‚‹ ä»Šå›žã¯ã€MySQL5.7ã®dumpã‚’MySQL8.0ã«ãƒªã‚¹ãƒˆã‚¢ã—ã¦ã„ã‚‹
roogh5eeSha6 2021/09/13
MySQL

dump

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
ã€å›³è§£ã€‘ã€3åˆ†è§£èª¬ã€‘Unicodeã¨UTF-8ã®é•ã„ï¼ã€ä»Šã•ã‚‰èžã‘ãªã„ã€‘ - Qiita
UTF-16ã®ã“ã¨ã‚’Unicodeã¨è¨˜ã—ã¦ã„ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢(Windowsã®ãƒ¡ãƒ¢å¸³ãªã©)ã‚‚ã‚ã‚Šã¾ã™ã®ã§Unicodeã¨ã‚ã£ãŸã‚‰ãã‚Œã¯UTF-16ã‚’ä½¿ã£ã¦å¤‰æ›ã—ãŸã‚‚ã®ãªã®ã ãªã€ã¨ã„ã†ãµã†ã«ç†è§£ã—ã¦ãã ã•ã„ã€‚ ãã†ãªã£ã¦ã—ã¾ã£ã¦ã„ã‚‹ç†ç”±ã¯ã“ã¡ã‚‰ã§è§£èª¬ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ ã“ã‚Œã§Unicodeã¨UTF-8ã®é•ã„ã¯ãƒãƒƒãƒãƒªã§ã™ãï¼ãŠã‚ã‚Šã€‚ èªã‚“ã§åˆ†ã‹ã‚Šã‚„ã™ã‹ã£ãŸã‚Šå°‘ã—ã§ã‚‚ä½•ã‹å¦ã¹ãŸã¨æ€ãˆãŸã‚‰ ã„ã„ã ã‚„ ã‚³ãƒ¡ãƒ³ãƒˆ ã‚’ã‚‚ã‚‰ãˆã‚‹ã¨ã“ã‚Œã‹ã‚‰ã®åŠ±ã¿ã«ãªã‚Šã¾ã™ï¼ ã‚‚ã†å°‘ã—æ™‚é–“ãŒã‚ã‚‹æ–¹ã¸ æ‰‹è¨ˆç®—ã§æ–‡å—ã‚’UTF-8ã§ã®ç¬¦å·ã¾ã§è¨ˆç®—ã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ç†è§£ãŒä¸€æ°—ã«æ·±ã¾ã‚Šã¾ã™ã€‚æ‰‹é †ã¯ä»¥ä¸‹ã€‚ 1. æ–‡å—ã®ã‚³ãƒ¼ãƒ‰ãƒã‚¤ãƒ³ãƒˆã‚’Unicodeã‹ã‚‰è¦‹ã¤ã‘ã¦ãã‚‹ã€‚ 2. ã‚³ãƒ¼ãƒ‰ãƒã‚¤ãƒ³ãƒˆã‚’UTF-8ã®æ–¹å¼ã§å¤‰æ›ã—ã¦ã¿ã‚‹ã€‚ Omiitaã®ã€ŒãŠã€ã‚’UTF-8ã«ã‚ˆã‚‹ç¬¦å·ã¾ã§å¤‰æ›ã—ã¦ã¿ã¾ã™ã€‚ æ–‡å—ã€ŒãŠã€ã®ã‚³ãƒ¼ãƒ‰ãƒã‚¤ãƒ³ãƒˆã‚’Unicodeã‹ã‚‰è¦‹ã¤ã‘
roogh5eeSha6 2021/07/26
UTF-8

æ–‡å—ã‚³ãƒ¼ãƒ‰

Unicode
ãƒªãƒ³ã‚¯
BOMã‚„Blobã‚’ç†è§£ã—ã¦JavaScriptã§CSVã‚’å‡ºåŠ›ã™ã‚‹ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
roogh5eeSha6 2021/05/17
ã‚ã¨ã§èªã‚€

node.js

CSV

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
ã€Pythonã€‘æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒé•ã£ã¦ã„ã¦èªã¿å–ã‚Œãªã„æ–‡å—ã‚’ç„¡è¦–ã™ã‚‹ - LIGHT11
Pythonã§æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒé•ã£ã¦ã„ã¦èªã¿å–ã‚Œãªã„æ–‡å—ã‚’ç„¡è¦–ã™ã‚‹æ–¹æ³•ã§ã™ã€‚ Python 3.7.2 å•é¡Œç‚¹ ã¾ãšpathlibã‚’ä½¿ã£ã¦ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã‚“ã§ã¿ã¾ã™ã€‚ #coding:utf-8 import pathlib file_path = r"C:\Users\UserName\Desktop\example.txt"; file = pathlib.Path(file_path) with file.open(encoding = "utf-8") as f: lines = f.readlines() for line in lines: print(line) ã“ã“ã§ã€example.txtãŒShift-JISã§ä¿å˜ã•ã‚Œã¦ã„ãŸã¨ã—ã¾ã™ã€‚ è‹±æ•°å—ã ã‘ãªã‚‰å•é¡Œãªãèªã‚ã¾ã™ãŒã€ãƒžãƒ«ãƒãƒã‚¤ãƒˆæ–‡å—ãŒå…¥ã£ã¦ã„ã‚‹ã¨ã€ UnicodeDecodeError: 'utf-8' codec can't
roogh5eeSha6 2020/01/27
python

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
1