[B! csv][tips] kathewã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kathew id:kathew

csvã¨tipsã«é–¢ã™ã‚‹kathewã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

${{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}}

HeidiSQLã§ã®csvã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã€ã‚¤ãƒ³ãƒãƒ¼ãƒˆ - Qiita
åˆ©ç”¨ã‚·ãƒ¼ãƒ³ MySQL(UTF8ã®DB)ã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«å˜ä½ã§CSVå‡ºåŠ›ã—ã¦ã€Excelã§ç·¨é›†ã—å†åº¦å–ã‚Šè¾¼ã‚€ã€‚ ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’é¸æŠžã™ã‚‹ã€‚ ã€Œãƒ¡ãƒ‹ãƒ¥ãƒ¼ï¼žToolsï¼žExport grid rows ..ã€ã‚’é¸æŠžã™ã‚‹ã€‚ Encodingã‚’ã€ŒANSIã€ã¨ã™ã‚‹ã€‚ Row selectionã‚’ã€ŒCompleteã€ã¨ã™ã‚‹ã€‚ ã€ŒOKã€ã‚’æŠ¼ã—ã¦ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹ã€‚ ï½ž Excelç‰ã§CSVã‚’ç·¨é›† ã‚¤ãƒ³ãƒãƒ¼ãƒˆ å–ã‚Šè¾¼ã‚€CSVã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’UTF-8ã¨ã™ã‚‹ã€‚â€»ä»»æ„ã®ã‚¨ãƒ‡ã‚£ã‚¿ã‚„ãƒ„ãƒ¼ãƒ«ã§ ã€Œãƒ¡ãƒ‹ãƒ¥ãƒ¼ï¼žToolsï¼žImport CSV file ..ã€ã‚’é¸æŠžã™ã‚‹ã€‚ Control charactersã®Fields terminated byã‚’ã€Œ,ã€ã«ã™ã‚‹ã€‚ Methodã‚’ã€ŒClient parses file contentsã€ã«ã™ã‚‹ã€‚ ã€ŒImport!ã€ã‚’æŠ¼ã—ã¦ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã€‚ ###ã€€è£œè¶³ Handlin
kathew 2019/10/17
mysql

sql

tips

csv
ãƒªãƒ³ã‚¯
MySQLã¸ãƒ€ãƒŸãƒ¼ãƒ‡ãƒ¼ã‚¿ã‚’ä½œæˆã™ã‚‹ - togatttiã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ¡ãƒ¢
ã¯ã˜ã‚ã« MySQLã«å¯¾ã—ã¦ãƒãƒ¼ãƒ‰ã®æ¤œè¨¼ã‚’è¡Œã†ãŸã‚ã«ãƒ€ãƒŸãƒ¼ãƒ‡ãƒ¼ã‚¿ã‚’ç”¨æ„ã™ã‚‹å¿…è¦ãŒ ã‚ã£ãŸã®ã§ã€ãƒ€ãƒŸãƒ¼ãƒ‡ãƒ¼ã‚¿ã®å–å¾—ã‹ã‚‰MySQLã¸ã®æŒ¿å…¥ã¾ã§ã®æµã‚Œã‚’ãƒ¡ãƒ¢ã—ã¦ãŠãã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ï¼•ç³»ã€‚ ãƒ€ãƒŸãƒ¼ãƒ‡ãƒ¼ã‚¿ã¯ã“ã“ã§æ‰‹ã«å…¥ã‚ŒãŸã€‚ (æ—¥æœ¬èªžã®ãƒ‡ãƒ¼ã‚¿(ã€œ5000ä»¶)) ç–‘ä¼¼å€‹äººæƒ…å ±ãƒ‡ãƒ¼ã‚¿ç”Ÿæˆã‚µãƒ¼ãƒ“ã‚¹ (è‹±èªžã®ãƒ‡ãƒ¼ã‚¿) generatedata.com ä»Šå›žã¯ç–‘ä¼¼å€‹äººæƒ…å ±ãƒ‡ãƒ¼ã‚¿ç”Ÿæˆã‚µãƒ¼ãƒ“ã‚¹ã‹ã‚‰csvå½¢å¼ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã€ ãã‚Œã‚’MySQLã¸æŒ¿å…¥ã™ã‚‹ã“ã¨ã«ã—ãŸã€‚ ãƒ€ãƒŸãƒ¼ãƒ‡ãƒ¼ã‚¿ã®ä½œæˆ ä½¿ã„æ–¹ã¯ç°¡å˜ã§ã¯ã˜ã‚ã«ä¸‹è¨˜ã®ã‚ˆã†ãªæ¡ä»¶ãŒé¸ã¹ã‚‹ã®ã§ã€å¿…è¦ãªã‚‚ã®ã‚’é¸ã³ ç”Ÿæˆé–‹å§‹ã‚’æŠ¼ã™ã ã‘ã€‚ æ¬¡ã«ã“ã®ã‚ˆã†ãªç”»é¢ãŒå‡ºã¦ãã‚‹ã®ã§ã€CSVå½¢å¼ã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã€‚ ã¨ã‚Šã‚ãˆãšhogehoge.csvã¨ã—ã¦ãŠãã€‚ MySQLã¸æŒ¿å…¥ mysqlã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’é–‹ã„ã¦ã€ä¸‹è¨˜ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã§ãƒ†ã‚¹ãƒˆç”¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã€‚ mysql> CREATE TABLE
kathew 2017/06/06
CSVã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ãŸã‚ã®TIPS

MySQL

csv

DB

tips
ãƒªãƒ³ã‚¯
MySQLã§æ”¹è¡Œã‚„ã‚«ãƒ³ãƒžã‚’ç½®æ›ã™ã‚‹ - æ°—ã¾ã¾Note
å•é¡Œ MySQLã‹ã‚‰CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡ºåŠ›ã—ã‚ˆã†ã¨ã—ãŸã‚‰ã€DBã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã«æ”¹è¡ŒãŒå«ã¾ã‚Œã¦ã„ã‚‹ãŸã‚é…åˆ—ãŒã‚ºãƒ¬ã¦ã—ã¾ã†ã“ã¨ãŒèµ·ããŸã€‚CSVã‚’å‡ºåŠ›ã™ã‚‹å‰ã«MySQLä¸Šã§æ”¹è¡Œã‚’å‡¦ç†ã—ãŸã„ã€‚ è§£æ±º æ”¹è¡Œ REPLACEã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ã§ç½®æ›ã™ã‚‹ã“ã¨ãŒã§ããŸã€‚ SELECT REPLACE(xxxx ,'\r\n','') FROM test; ã‚«ãƒ³ãƒž(,) ã‚«ãƒ³ãƒž(,)ã®æ™‚ã‚‚åŒæ§˜ã€‚ SELECT REPLACE(xxxx, ',', '') FROM test; ã‚«ãƒ³ãƒžã¨æ”¹è¡Œã‚’åŒæ™‚ã«ç½®æ›ã—ãŸã„ã€‚ å…¥ã‚Œåã«ã™ã‚Œã°åŒæ™‚ã«å¯¾å‡¦ã™ã‚‹ã“ã¨ãŒã§ããŸã€‚ SELECT REPLACE(REPLACE(xxxx,'\r\n',''), ',', '') FROM test; å‚è€ƒURL Removing carriage returns in Mysql DB - Stack Overflow
kathew 2017/01/04
MySQL

CSV

tips
ãƒªãƒ³ã‚¯
PHPã§CSVã‚’ç”Ÿæˆã™ã‚‹ ï¼ˆãŸã ã—ãƒ¡ãƒ¢ãƒªãƒ»CPUã‚’æŠ‘ãˆã¦ï¼‰
2017/6 è¿½è¨˜ï¼š ã“ã®è¨˜äº‹ãŒæ„å›³ã«é•ã£ãŸç´¹ä»‹ã®ã•ã‚Œæ–¹ã‚’ã—ã¦ã—ã¾ã£ã¦ã„ã‚‹ã‚ˆã†ãªã®ã§ã€å¿µã®ãŸã‚æ³¨æ„å–šèµ·ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚
kathew 2015/03/31
CSV

PHP

development

tips

web
ãƒªãƒ³ã‚¯
CakePHPã§å†…éƒ¨çµåˆã—ãŸé…åˆ—ã®CSVãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ - åŒ—æµ·é“è‹«å°ç‰§å¸‚ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸åˆ¶ä½œã€€STUDIO KEY
kathew 2015/03/12
cakePHP

development

tips

CSV
ãƒªãƒ³ã‚¯
CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’DBã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆ | Sunvisor Lab.
ã‚µãƒ¼ãƒã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ï¼ŒCakePHPçµŒç”±ã§ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ãŸCSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã—ãŸã®ã§ï¼Œãã®å‡¦ç†ã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚µãƒ¼ãƒã«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ï¼Œãã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’DBã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ã¨ã„ã†æ‰‹é †ã«ãªã‚ã†ã‹ã¨æ€ã„ã¾ã™ã€‚ ãƒ“ãƒ¥ãƒ¼ <div class="options form"> <div class="actions"> <ul> <li><?php echo $html->link('ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã«æˆ»ã‚‹', array('action'=>'index'));?></li> </ul> </div> <?php echo $form->create('Options', array('action'=>'upload', 'type' => 'file'));?> <fieldset> <legend>ãƒ‡ãƒ¼ã‚¿ã®ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰</legend> <?php echo $f
kathew 2014/11/11
CakePHP

CSV

development

tips

php
ãƒªãƒ³ã‚¯
éšæ‹“ HeidiSQLã§mysqlã«csvãƒ‡ãƒ¼ã‚¿ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹
kathew 2014/08/21
CSV

DB

development

tips
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 13.2.7 LOAD DATA ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ
SAVEPOINTã€ROLLBACK TO SAVEPOINT ãŠã‚ˆã³ RELEASE SAVEPOINT ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ
kathew 2014/02/11
CSV

reference

development

MySQL

db

tips
ãƒªãƒ³ã‚¯
layer8.sh
This domain may be for sale!
kathew 2014/02/10
MySQL

db

csv

development

tips
ãƒªãƒ³ã‚¯
[PHP]æ–‡å—åŒ–ã‘ã›ãšã«CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã¿ã€é…åˆ—ã«å¤‰æ›ã™ã‚‹ | PHP Archive
CSV ãƒ•ã‚¡ã‚¤ãƒ«ã‚’èªã¿è¾¼ã‚€ã¨ãã€æœ€ã‚‚ã‚·ãƒ³ãƒ—ãƒ«ãªæ–¹æ³•ã¯æ¬¡ã®ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ <?php $csv = array(); $file = 'test.csv'; $fp = fopen($file, "r"); while (($data = fgetcsv($fp, 0, ",")) !== FALSE) { $csv[] = $data; } fclose($fp); var_dump($csv); fgetcsv() ã‚’ç”¨ã„ã¦å˜ç´”ã«ä¸€è¡Œãšã¤å‡¦ç†ã—ã¦ã„ã¾ã™ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒ å´ã¨ CSV ãƒ•ã‚¡ã‚¤ãƒ«ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒåŒã˜ã§ã‚ã‚Œã°ã“ã®æ–¹æ³•ã§ã‚‚ã„ã„ã®ã§ã™ãŒã€ã‚¨ã‚¯ã‚»ãƒ«ãªã©ã§ä½œã‚‰ã‚ŒãŸ CSV ã‚ã‚‹ã„ã¯ TSVï¼ˆã‚¿ãƒ–åŒºåˆ‡ã‚Šï¼‰ãªã©ã¯ã€Shift-JIS ã§ä¿å˜ã•ã‚Œã¦ã„ã‚‹å ´åˆãŒå¤šã„ãŸã‚ã€PHPå´ãŒ UTF-8 ã§è¨˜è¿°ã•ã‚Œã¦ã„ã‚‹æ™‚ã€ä¸Šã®æ–¹æ³•ã§æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’å¤‰æ›ã™ã‚‹ã«ã¯ã€mb_convert_variables() ã‚’ä½¿
kathew 2014/01/30
PHP

csv

encode

development

web

file

tips

reference
ãƒªãƒ³ã‚¯
CakePHPã§ãƒ†ãƒ¼ãƒ–ãƒ«ã®æƒ…å ±ã‚’CSVã«åã„ãŸã‚Šèªã‚“ã ã‚Šã—ã¦ã¿ã‚‹
æ¦‚è¦ CsvExportBehaviorã¨CsvImportBehaviorã‚’ä½¿ã£ã¦CSVã®æƒ…å ±ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã«å…¥ã‚ŒãŸã‚Šåã„ãŸã‚Šã—ã¦ã¿ã‚‹ã€‚ PHP5.4ã€CakePHP2.2.5ã‚’åˆ©ç”¨ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æƒ…å ±ã‚’CSVãƒ•ã‚¡ã‚¤ãƒ«ã§å‡ºåŠ›ã™ã‚‹ DBã®æƒ…å ±ã‚’å‡ºåŠ›ã™ã‚‹æ™‚ã¯CsvExportBehaviorã¨ã„ã†åã‚’è½ã¨ã—ã¦ãã¦ä½¿ãˆã°æ¥½ãã†ã€‚ ä¸‹è¨˜ã®URLã‹ã‚‰è½ã¨ã—ã¦ãã¦ã€app/Model/Behaviorã®ä¸‹ã«å…¥ã‚Œã‚‹ã€‚MITãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã€‚ https://github.com/pronique/CakePHP-ProUtils-Plugin/blob/master/Model/Behavior/CsvExportBehavior.php Modelã®actAsã«CsvExportã‚’è¿½åŠ ã™ã‚‹ã€‚
kathew 2013/11/11
CakePHP

csv

PHP

development

web

tips

reference
ãƒªãƒ³ã‚¯
CakePHPã§CSVã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ãªã‚‰CakeDCã®CsvImport BehaviorãŒä¸€ç•ªè‰¯ã•ãã† | Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ©ã‚¤ãƒ•
CSVã®ã‚¤ãƒ³ãƒãƒ¼ãƒˆã‚’ã—ãŸã„ã¨ã„ã†ã“ã¨ã§ã€æŽ¢ã—ã¦ã¿ã‚‹ã¨ã„ã„ã‚‚ã®ãŒã‚ã‚Šã¾ã—ãŸã€‚ https://github.com/CakeDC/utilsã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹Utils Pluginã®ä¸€éƒ¨ã€‚CsvImport Behaviorã§ã™ã€‚ ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã¯PHP5.2ä»¥ä¸Šã¨æ›¸ã‹ã‚Œã¦ã„ã¾ã™ãŒã€CsvImport Behaviorã«ã¤ã„ã¦ã¯ã€PHP5.1.6ã§ã‚‚å‹•ã„ã¦ã„ã¾ã™ã€‚ ä½¿ã„æ–¹ ã“ã‚“ãªæ„Ÿã˜ã€‚usersãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®è¿½åŠ ã®å ´åˆã€‚ Controllerã®æº–å‚™ function import() { $filename = TMP . 'user.csv'; if(file_exists($filename)) { $db = $this->User->getDataSource(); $db->begin($this->User); $this->User->deleteAll('1 = 1'); $t
kathew 2013/11/11
CakePHP

csv

reference

tips

web

development
ãƒªãƒ³ã‚¯
Windowsä¸Šã§ä½œæˆã—ãŸCSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’MySQLã¸ã‚¤ãƒ³ãƒãƒ¼ãƒˆ - mir the developer
MySQLã¯Windowsãƒã‚¤ãƒŠãƒªã§ã‚ã£ã¦ã‚‚ï¼Œ"LOAD DATA INFILE..."ã§ã®æ”¹è¡Œã‚³ãƒ¼ãƒ‰åˆ¤å®šã«"LR"ã‚’ä½¿ç”¨ã™ã‚‹ã¿ãŸã„ã§ã™ï¼Ž Windowsä¸Šã§ä½œæˆã—ãŸCSVãƒ•ã‚¡ã‚¤ãƒ«ã®æ”¹è¡Œã‚³ãƒ¼ãƒ‰ã¯"CR+LF"ã§ã™ã‹ã‚‰ï¼Œã“ã®ã¾ã¾ã ã¨å…¥åŠ›ãƒ‡ãƒ¼ã‚¿ã«CRãŒä»˜ä¸Žã•ã‚Œã¦ã—ã¾ã„ã¾ã™ï¼Ž å¾“ã£ã¦"LINES TERMINATED BY"ã‚’"CR+LF"ã¨ã™ã¹ãï¼Œä»¥ä¸‹ã®ã‚ˆã†ã«æŒ‡å®šã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ï¼Ž LOAD DATA INFILE 'D:\\test.csv' INTO TABLE t1 FIELDS TERMINATED BY ',' LINES TERMINATED BY x'0D0A';è©³ç´°ã‚¹ãƒˆãƒ¼ãƒªãƒ¼ä»˜ãã¯ã“ã¡ã‚‰ã‹ã‚‰ï¼Ž http://ikda.net/fswiki/wiki.cgi?page=MySQL#p18 â€¦ã£ã¦ã¾ãŸæ›¸ã„ã¦ã‚‹ã—ï½—ã€€æœ€è¿‘å¥½ãã‚‰ã—ã„ã€ã“ã†ã„ã†ã®ãŒï½—
kathew 2012/11/09
mysql

windows

development

csv

tips
ãƒªãƒ³ã‚¯
1