[B! MySQL] ryskosnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ryskosn id:ryskosn

MySQLã«é–¢ã™ã‚‹ryskosnã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (40)

${{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ã®åˆ©ç‚¹ã‚’æŒ™ã’ã‚‹ã¨ã™ã‚Œã°ä½•ã§ã™ã‹ï¼Ÿ
å›žç” (4ä»¶ä¸ã®1ä»¶ç›®) æ¯”ã¹ã‚‹ç›¸æ‰‹ãŒæ˜Žç¤ºã•ã‚Œã¦ã„ã¾ã›ã‚“ãŒã€ãƒ•ãƒªãƒ¼ã§ä½¿ãˆã‚‹ç«¶åˆã¨ã—ã¦ãŠãã‚‰ãPostgreSQLã‚’æƒ³å®šã•ã‚Œã¦ã„ã‚‹ã‚‚ã®ã¨æ€ã„ã¾ã™ã€‚ PostgreSQLã¨MySQL (InnoDB) ã®è¦æ—¨ãƒ¬ãƒ™ãƒ«ã§ã®é•ã„ã¯ã€å¤§è¦æ¨¡ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯å‘ã‘ãªã‚‰MySQLã€ãã‚Œä»¥å¤–ãªã‚‰PostgreSQLã¨ã„ã†ä½ã¿åˆ†ã‘ã«ãªã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ * PostgreSQLã¯ã€ã¤ã„æœ€è¿‘ã¾ã§è«–ç†ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚ã¤ã¾ã‚Šã€èªã¿è¾¼ã¿ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã•ã›ã‚‹éš›ã«WALã‚’è»¢é€ã™ã‚‹ã¨ã„ã†ç‰©ç†ãƒ¬ãƒ™ãƒ«ã®ãƒ¬ãƒ—ãƒªã‚«ã—ã‹ä½œã‚Œãšã€é€æ¬¡ãƒªãƒ—ãƒ¬ã‚¤ã™ã‚‹ä»¥å¤–ã®æ§‹æˆã®è‡ªç”±åº¦ãŒã‚ã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ã—ã‹ã—ã“ã®å¼±...
ryskosn 2020/07/28
DB

PostgreSQL

MySQL
ãƒªãƒ³ã‚¯
MySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒPostgreSQLã‚’è§¦ã£ã¦ã¿ãŸãƒ¡ãƒ¢ - tmtms ã®ãƒ¡ãƒ¢
æœ€è¿‘ãªãœã‹ MySQL ã‚’ä½¿ã† Ruby ã‚¢ãƒ—ãƒªã‚’ PostgreSQL ã«å¯¾å¿œã™ã‚‹ç¾½ç›®ã«ãªã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€ä»Šã¾ã§ã»ã¨ã‚“ã© MySQL ä»¥å¤–ã® RDBMS ã‚’è§¦ã£ã¦ãªã‹ã£ãŸã®ã§ã€è‰²ã€…ãƒãƒžã£ãŸã‚Šã—ãŸã®ã§ãƒ¡ãƒ¢ã£ã¨ãã¾ã™ã€‚ ãªãŠ PostgreSQL æ´ãŒæµ…ã„ã®ã§é–“é•ã£ã¦ã‚‹ã“ã¨æ›¸ã„ã¦ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ API ãƒ—ãƒã‚°ãƒ©ãƒ ã‹ã‚‰ MySQL ã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã«ã¯ Ruby/MySQL ã‚’ä½¿ã£ã¦ã„ãŸã®ã§ã™ãŒã€PostgreSQL ç”¨ã® API ã‚’æ–°ãŸã«è¦šãˆã‚‹ã®ã¯é¢å€’ã ã£ãŸã®ã§ã€Sequel ã‚’ä½¿ã£ã¦æ›¸ãç›´ã—ã¾ã—ãŸã€‚ mysql.query("select col1, col2 from table where col3='xxx'") â†“ db[:table].where(col3: 'xxx').select(:col1, :col2) â€¦ã¿ãŸã„ãªæ„Ÿã˜ã§ã™ã€‚ ä»Šã¾ã§ãƒ—ãƒã‚°ãƒ©ãƒ ä¸ã«çªç„¶ SQL ãŒç¾ã‚Œ
ryskosn 2015/04/05
MySQL

PostgreSQL
ãƒªãƒ³ã‚¯
Kazuho's Weblog: ã•ã‚‰ã°ã€æ„›ã—ãè«–ç†å‰Šé™¤ã€‚MySQLã§å¤§ç¦å¸³åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®Ÿç¾ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã€Œdaifukuã€ã‚’ä½œã£ã¦ã¿ãŸ
ã•ã‚‰ã°ã€æ„›ã—ãè«–ç†å‰Šé™¤ã€‚MySQLã§å¤§ç¦å¸³åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å®Ÿç¾ã™ã‚‹ãƒ„ãƒ¼ãƒ«ã€Œdaifukuã€ã‚’ä½œã£ã¦ã¿ãŸ å…ˆã®ã‚¨ãƒ³ãƒˆãƒªã€Œè«–ç†å‰Šé™¤ã¯ãªãœã€Œç‹ãŒæ‚ªã„ã€ã‹ã€ã§æ›¸ã„ãŸã¨ãŠã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦è¡Œã‚ã‚ŒãŸæ“ä½œã‚’è¨˜éŒ²ã—ã€å¿…è¦ã«å¿œã˜ã¦å‚ç…§ã—ãŸã‚Šå–ã‚Šæ¶ˆã—ãŸã‚Šã—ãŸã„ã¨ã„ã†è¦æ±‚ã¯è‡³æ¥µå¦¥å½“ãªã‚‚ã®ã§ã™ãŒã€å¤šãã®RDBã¯ã€ãã®ãŸã‚ã«ç°¡å˜ã«ä½¿ãˆã‚‹ä»•çµ„ã¿ã‚’æä¾›ã—ã¦ã„ã¾ã›ã‚“ã€‚ daifukuã¯ã€RDBã«å¯¾ã—ã¦åŠ ãˆã‚‰ã‚ŒãŸå¤‰æ›´ã‚’ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å˜ä½ã§RDBå†…ã«JSONã¨ã—ã¦è¨˜éŒ²ã™ã‚‹ãŸã‚ã®ã‚¹ãƒˆã‚¢ãƒ‰ã‚„ãƒˆãƒªã‚¬ã‚’ç”Ÿæˆã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã§ã™ã€‚ % daifuku dbname tbl1 tbl2 > setup.sql ã®ã‚ˆã†ã«å®Ÿè¡Œã™ã‚‹ã¨ã€æŒ‡å®šã•ã‚ŒãŸãƒ†ãƒ¼ãƒ–ãƒ«ï¼ˆã“ã“ã§ã¯tbl1ã¨tbl2ï¼‰ã«ã‚»ãƒƒãƒˆã™ã¹ããƒˆãƒªã‚¬ã‚„ã€æ›´æ–°ãƒã‚°ã‚’è¨˜éŒ²ã™ã‚‹ãŸã‚ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã€Œdaifuku_logã€ã‚’ç”Ÿæˆã™ã‚‹CREATE TABLEã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆãªã©ã€å¿…è¦ãªSQLæ–‡ã‚’set
ryskosn 2015/03/31
DB

MySQL
ãƒªãƒ³ã‚¯
ã„ã‚ã„ã‚è€ƒãˆã‚‹ã¨æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢ã‚‚MySQLãŒã„ã„ãï¼ - Kouhei Sutou - Rabbit Slide Show
Description MySQLã¯åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹RDBMSã§ã™ã€‚é€Ÿã„ã—ã€ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒŽã‚¦ãƒã‚¦ã‚‚ã‚ã‚‹ã—ã€Webä¸Šã«ãŸãã•ã‚“ã®æƒ…å ±ã‚‚ã‚ã‚‹ã‹ã‚‰ã„ã–ã¨ã„ã†ã¨ãã‚‚å®‰å¿ƒã€ã¨ã„ã†ã®ãŒãã®ç†ç”±ã§ã—ã‚‡ã†ã€‚ ãã‚“ãªMySQLã®å¼±ç‚¹ã®1ã¤ãŒãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯æ—¥æœ¬èªžã§å…¨æ–‡æ¤œç´¢ã§ããªã„ã“ã¨ã§ã™ã€‚ã§ã‚‚ã€æ—¥æœ¬èªžã§å…¨æ–‡æ¤œç´¢ã—ãŸã„ã—ã€‚ã€‚ã€‚ã©ã†ã—ã‚ˆã†ã€‚ ãã‚“ãªã‚ãªãŸã«æœ€è¿‘ã®æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢äº‹æƒ…ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚Solrï¼ŸElasticsearchï¼ŸGroongaï¼ŸPostgreSQLã¯ã©ã†ã‚„ã£ã¦ã„ã‚‹ã®ï¼ŸMroongaï¼ŸSphinxï¼Ÿ ã„ã‚ã„ã‚è€ƒãˆã‚‹ã¨æ—¥æœ¬èªžã§å…¨æ–‡æ¤œç´¢ã™ã‚‹ã¨ãã‚‚MySQLã‚’ä½¿ã†ã®ãŒã„ã„ãï¼ã¨æ€ãˆã¦ãã‚‹ã‹ã‚‰ä¸æ€è°ã§ã™ã€‚æœ€è¿‘ã®æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢äº‹æƒ…ã‚’èžã„ã¦ä¸€ç·’ã«è€ƒãˆã¦ã¿ã¾ã›ã‚“ã‹ï¼Ÿ Page: 1 ã„ã‚ã„ã‚è€ƒãˆã‚‹ã¨ æ—¥æœ¬èªžã®å…¨æ–‡æ¤œç´¢ã‚‚ MySQLãŒã„ã„ãï¼ é ˆè—¤åŠŸå¹³ æ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼š OSC2014 Tokyo
ryskosn 2015/03/19
Mroonga MariaDB ã«æè¼‰

DB

MySQL
ãƒªãƒ³ã‚¯
ï¼’ï¼Œï¼“åˆ†ã§ã€MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã‹ã‚‰ã€å¤–éƒ¨ã®ç«¯æœ«ã‹ã‚‰æŽ¥ç¶šã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ | Divide et impera
Nettbutikk divide-et-impera.org Â«divide-et-impera.orgÂ» er en nettbutikk som tar sikte pÃ¥ Ã¥ forbedre helsen til menn og kvinner! Nettbutikken har vÃ¦rt aktiv pÃ¥ markedet i mer enn 3 Ã¥r. I vÃ¥r butikk vil du bli presentert for mer enn 200 stillinger av et hÃ¸ykvalitets produkt tilberedt i henhold til klassiske Ã¸stlige oppskrifter fra pÃ¥litelige produsenter. Butikken vÃ¥r organiserer regelmessig kampanje
ryskosn 2014/09/07
MySQL
ãƒªãƒ³ã‚¯
MySQLite: SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’èªã¿æ›¸ãã™ã‚‹MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³
ryskosn 2014/03/24
SQLite

MySQL
ãƒªãƒ³ã‚¯
CitrusDB - The Open Source Customer Service and Billing Software
Overview Customer Records General information and history about each customer is linked to their records. New customers can be imported from an online form or entered by a customer service representative. Service Records Unlimited services can be assigned to one customer. Services can have as many custom fields as needed to store all the information and attributes for that service. Each service ca
ryskosn 2013/10/31
MySQL

PHP
ãƒªãƒ³ã‚¯
Devsã®å¸¸è˜ã€DBAã¯éžå¸¸è˜
1. MySQL Admin ãŒè¦‹ãŸ Devs ã®å¸¸è˜ã€ DBA ã¯éžå¸¸è˜ 2013/09/14 yoku0825@MyNA PHP Conference 2013 2. ï¼¼ã“ã‚“ã«ã¡ã¯ï¼ï¼ â— yoku0825 â— ã¨ã‚ã‚‹ä¼æ¥ã® DBA â— MySQL æ´ 5 å¹´ãã‚‰ã„ â— ã‚ªãƒ©ã‚¯ã‚Œãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ â— æ—¥æœ¬ MySQL ãƒ¦ãƒ¼ã‚¶ä¼š (MyNA) ã®ã‚¹ãƒ™ã‚Šæ‹…å½“ 3. ï¼¼ã—ã‚ƒã¹ã‚‹ã“ã¨ï¼ï¼ â— æ—¥å¸¸çš„ã« MySQL ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã«è§¦ã‚Œã‚‹å¤‰æ…‹ DBA ãŒãƒ•ãƒ„ãƒ¼ã® Devs ã«æŠ•ã’ãŸæ„›ã®ãƒžã‚µã‚«ãƒªé›† ( ã®ã¤ã‚‚ã‚Š ) â— ã‚¦ãƒã®é–‹ç™ºè¨€èªžã¯ PHP > Java >> Ruby ã‚‰ã—ã„ã§ã™ â— ã‚¦ãƒã§ã¯ DBA ãŒã‚µãƒ¼ãƒãƒ¼ã®æ§‹ç¯‰ã€ Devs ãŒè¨è¨ˆãƒ» ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹ç¯‰ãƒ»é‹å–¶ã€ DBA ã¯ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒˆã‚„æ”¹ å–„ææ¡ˆ ( é‹ç”¨ ) ã€ã¨ã„ã†ã‚µã‚¤ã‚¯ãƒ«ã§å›žã—ã¦ã„ã¾ã™ã€‚
ryskosn 2013/09/15
MySQL
ãƒªãƒ³ã‚¯
MySQL Indexå‹‰å¼·ä¼šå¤–éƒ¨å…¬é–‹ç”¨
12. Â© CROOZ,Inc. 12 ï¼‘ï¼ŽINDEXã¨ã¯ãªã«ã‹ ä½•æžšç›®ãŒãªã«ã‹ã‚’äº‹å‰ã«ãƒ¡ãƒ¢ã£ã¦ãŠã‘ã°è‰¯ã„ï¼ ã‚¹ãƒ¼ãƒˆ ãƒ©ãƒ³ã‚¯ ä½ç½® ãƒãƒ¼ãƒˆ Q 1 ã‚¹ãƒšãƒ¼ãƒ‰ 9 2 : : : ãƒ€ã‚¤ãƒ¤ 1 40 : : : ã‚¹ãƒšãƒ¼ãƒ‰ 6 45 ãªãœãªã‚‰ã€è¦æ±‚ã¯ã€Œã‚«ãƒ¼ãƒ‰ã‚’å¼•ãå›žæ•°ã‚’æœ€ã‚‚å°‘ãªã ã—ã¦ã‚¹ãƒšãƒ¼ãƒ‰6ã‚’æŽ¢ã™ã“ã¨ã€ ã‚»ã‚³ã„ã¨ã‹ãŠã‚‚ã†ãƒ’ãƒˆã¯ã„ã‚‹ã‹ ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒä½•ã‚‚ã‚»ã‚³ã„ã“ ã¯ã—ã¦ã„ãªã„ã§ã™ã€‚ å‰ææ¡ä»¶ãªã©ä¸€åˆ‡ãªã„ã‹ã‚‰ ã“ã®ãƒ¡ãƒ¢ã•ãˆã‚ã‚Œã°ä½ç½®ã‚’æŒ‡å®šã—ã¦1å›žå¼•ã‘ã°æ¸ˆã‚€
ryskosn 2013/09/13
MySQL
ãƒªãƒ³ã‚¯
MySQLã‹ã‚‰csvã§å‡ºåŠ›ã™ã‚‹æ–¹æ³•
MySQLã‹ã‚‰Dumpã—ã¦å¤‰æ›ã§ã¯ãªãã€ç›´æŽ¥CSVã§å‡ºåŠ›ã™ã‚‹æ–¹æ³•ã‚’æŽ¢ã—ã¦ã„ã‚‹ã¨ã€ã“ã‚“ãªã‚„ã‚Šæ–¹ãŒç´¹ä»‹ã•ã‚Œã¦ã„ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ã‚’CSVã§å…¥å‡ºåŠ›ã™ã‚‹æ–¹æ³• CSVã«å‡ºåŠ›ï¼ˆã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆï¼‰ã™ã‚‹æ–¹æ³• ä»¥ä¸‹ã®ã‚ˆã†ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨å‡ºåŠ›ãƒ•ã‚¡ã‚¤ãƒ«ã‚’æŒ‡å®šã™ã‚Œã°å‡ºåŠ›ã•ã‚Œã¾ã™ã€‚ mysql> select * from database into outfile "/tmp/dump.csv" fields terminated by ','; CSVã‹ã‚‰å…¥åŠ›ï¼ˆã‚¤ãƒ³ãƒãƒ¼ãƒˆï¼‰ã™ã‚‹æ–¹æ³• ä»¥ä¸‹ã®ã‚ˆã†ã«ã€å…¥åŠ›ãƒ•ã‚¡ã‚¤ãƒ«ã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æŒ‡å®šã™ã‚Œã°å…¥åŠ›ã§ãã¾ã™ã€‚ mysql> load data local infile "/tmp/dump.csv" into table tablename fields terminated by ','; åŒºåˆ‡ã‚Šã®æ”¹è¡Œã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã™ã‚‹ã«ã¯ã€â€LINES TERMINATED BYâ€ã§
ryskosn 2013/07/08
MySQL

csv
ãƒªãƒ³ã‚¯
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action ã‚’ä¸€åº¦ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”åˆ©ç”¨ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„å›žç”ã‚’ã€Žå…±æœ‰ã€ã—ã€Žç·¨é›†ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’ç¶šã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—ãƒˆã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„å›žç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”æ”¯æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’æ¤œè¨Žã—ãŸçµæžœã€2020å¹´2æœˆ28æ—¥ï¼ˆé‡‘ï¼‰15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚ä½•ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
ryskosn 2013/05/15
Ruby

MySQL
ãƒªãƒ³ã‚¯
MySQL Cheat Sheet 1.0
5 ã‚³ãƒ¡ãƒ³ãƒˆ: hika69 ã•ã‚“ã®ã‚³ãƒ¡ãƒ³ãƒˆ... MySQL Cheat Sheetã®ãƒªãƒ³ã‚¯ãŒåˆ‡ã‚Œã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ã»ã—ã„ã§ã™ï¼ 2011/04/02 12:54:00 Mikiya Okuno ã•ã‚“ã®ã‚³ãƒ¡ãƒ³ãƒˆ... Hikariã•ã‚“ã€ ä»Šå¼•è¶Šã—ã‚’ã—ãŸã¨ã“ã‚ã§ã€ã¾ã é¯–ã‚’é…å‚™ã—çµ‚ãˆã¦ãªã„ã®ã§ã™ã€‚ä»Šã—ã°ã‚‰ããŠå¾…ã¡ã‚’ï¼ 2011/04/04 14:43:00 Mikiya Okuno ã•ã‚“ã®ã‚³ãƒ¡ãƒ³ãƒˆ... Hikariã•ã‚“ã€ ãŠã¾ãŸã›ã—ã¾ã—ãŸã€‚ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å¯èƒ½ã«ãªã‚Šã¾ã—ãŸã€‚ 2011/04/09 0:05:00 Unknown ã•ã‚“ã®ã‚³ãƒ¡ãƒ³ãƒˆ... ã“ã®ã‚³ãƒ¡ãƒ³ãƒˆã¯æŠ•ç¨¿è€…ã«ã‚ˆã£ã¦å‰Šé™¤ã•ã‚Œã¾ã—ãŸã€‚ 2016/07/21 17:48:00 Mikiya Okuno ã•ã‚“ã®ã‚³ãƒ¡ãƒ³ãƒˆ... ã™ã¿ã¾ã›ã‚“ã€‚æœ¬æ–‡ä¸ã§ãƒªãƒ³ã‚¯ã—ã¦ã„ã‚‹ã‚µã‚¤ãƒˆã¯ã€ãƒ‰ãƒ¡ã‚¤ãƒ³åˆ‡ã‚Œã®ãŸã‚æ¶ˆå¤±ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ä¸‹è¨˜ã®ãƒªãƒ³ã‚¯ã‚’ã”åˆ©ç”¨ãã ã•ã„ã€‚
ryskosn 2013/01/17
MySQL
ãƒªãƒ³ã‚¯
MySQLç®¡ç†è€…æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼
å··ã§ã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã®æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼ãŒæµè¡Œã£ã¦ã‚‹ã®ã§ã€MySQLã‚‚å‚æˆ¦ã€‚ãŸã ã—ç®¡ç†è€…å‘ã‘ã€‚ ã¾ãšã¯ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¨ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚µã‚¤ãƒˆ http://dev.mysql.com/downloads/ ãƒã‚¤ãƒŠãƒªã«ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ï¼ˆWindows=MSIã€Mac=DMGã€Linux=RPMã¨ã‹ï¼‰ã¨ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ï¼ˆ*NIX=tar.gz/Windows=zipï¼‰ãŒã‚ã‚‹ã‘ã©ã€åˆå¿ƒè€…ã¯é»™ã£ã¦ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ãƒãƒ§ã‚¤ã‚¹ã€‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ã‚¦ã‚£ã‚¶ãƒ¼ãƒ‰ã«å¾“ã†ã ã‘ã€‚è‹±èªžã ã‘ã©ãã“ã¯ã‚¬ãƒžãƒ³ï¼ ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãƒªãƒã‚¸ãƒˆãƒªãŒã‚ã‚‹OSã‚’ä½¿ã£ã¦ã‚‹ãªã‚‰ã€ãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã®ã‚‚ã‚ã‚Šã ã€‚ä¾‹ãˆã°ã€ shell> sudo yum install mysqlã¨ã‹ shell$gt; sudo apt-get install mysqlã¨ã‹ã€‚ã“ã‚Œã¯æ¥½ãƒãƒ³ã ã‘ã©MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒã¡ã‚‡ã£ã¨å¤ããªã‚‹ã®ã§æ³¨æ„ã€‚ ã‚‚ã¡ã‚ã‚“
ryskosn 2013/01/17
MySQL
ãƒªãƒ³ã‚¯
MySQLã€€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’å¾Œã‹ã‚‰å¤‰æ›ã™ã‚‹:æŠ€è¡“ï¼é–‹ç™ºã€€ãƒ¡ãƒ¢
MySQLã€€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’å¾Œã‹ã‚‰å¤‰æ›ã™ã‚‹ ï¼œå¤‰æ›´å‰ã®æ–‡å—ã‚³ãƒ¼ãƒ‰è¨å®šï¼ž dbuser1@localhost[appdb]> status; Server characterset: utf8 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 dbuser1@localhost[appdb]> show variables like "chara%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client | u
ryskosn 2013/01/15
MySQL
ãƒªãƒ³ã‚¯
ãƒ‰ãƒ¡ã‚¤ãƒ³ãƒ‘ãƒ¼ã‚ãƒ³ã‚°
ryskosn 2013/01/15
3.5 ã‚’ä½¿ã†ã®ãŒã‚ˆã•ãã†

MySQL

ODBC
ãƒªãƒ³ã‚¯
MyODBC æ—¥æœ¬èªžã‚µãƒ¼ãƒãƒ¼å¯¾å¿œç‰ˆ ã‚’æŽ¢ã—ã¦ã„ã¾ã™ - OKWAVE
Excel ã‹ã‚‰ MySQL ( Server 5.0 ) ã‚’åˆ©ç”¨ã—ã‚ˆã†ã¨ã—ã¦ã„ã¾ã™ã€‚ MySQL ã‹ã‚‰ Excel ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’èªã¿è¾¼ã‚€ã¨ãï¼Œ æ—¥æœ¬èªžãŒæ–‡å—åŒ–ã‘ã‚’èµ·ã“ã—ã¦å›°ã£ã¦ã„ã¾ã™ã€‚ ãƒãƒƒãƒˆã§æ–‡å—åŒ–ã‘ã®åŽŸå› ã‚’èª¿ã¹ã¦ã¿ãŸï¼ˆï¼Šï¼‰ã¨ã“ã‚ï¼Œ MyODBC æ—¥æœ¬èªžã‚µãƒ¼ãƒãƒ¼å¯¾å¿œç‰ˆ ã¨ã„ã†ã®ã‚’å…¥æ‰‹ã™ã‚‹ã¨è§£æ±ºã—ãã†ãªã“ã¨ãŒåˆ†ã‹ã‚Šã¾ã—ãŸã€‚ ã¨ã“ã‚ãŒ MyODBC æ—¥æœ¬èªžã‚µãƒ¼ãƒãƒ¼å¯¾å¿œç‰ˆ ã‚’ç½®ã„ã¦ã‚ã‚‹ã¨æ€ã‚ã‚Œã‚‹ã‚µã‚¤ãƒˆï¼š http://www.softagency.co.jp/mysql/pro/win_myodbc.html ã‚’è¨ªå•ã™ã‚‹ã¨ï¼Œã™ã§ã«ãƒšãƒ¼ã‚¸ãŒå˜åœ¨ã—ã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚ åˆæ©çš„ã§ã‚ã„ã¾ã„ãªè³ªå•ã§æç¸®ã§ã™ãŒ MyODBC æ—¥æœ¬èªžã‚µãƒ¼ãƒãƒ¼å¯¾å¿œç‰ˆ ã‚’ã©ã“ã‹ã§å…¥æ‰‹ã§ãã‚‹æ–¹æ³•ãŒã‚ã£ãŸã‚‰æ•™ãˆã¦ã„ãŸã ããŸã„ã§ã™ã€‚ ã©ã†ãžã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚ ï¼ˆï¼Šï¼‰ä»¥ä¸‹ã®é¡žä¼¼è³ªå•ã‚‚èªã¿ã¾ã—ãŸã€‚ http://oshiete1.g
ryskosn 2013/01/15
MySQL
ãƒªãƒ³ã‚¯
orangebox
Debian11 ç„¡ç·šLANåæ©Ÿã‚’å›ºå®šIPã«ã™ã‚‹ ã¾ãšã€ç„¡ç·šLANåæ©Ÿã®ãƒ‡ãƒã‚¤ã‚¹åã‚’ç¢ºèªã™ã‚‹ã€‚ $ ip addr 4: wlxe84e069f6dd6: mtu 1500 qdisc mq state UP group default qlen 1000 link/ether e8:4e:06:9f:6d:d6 brd ff:ff:ff:ff:ff:ff inet 192.168.0.19/24 brd 192.168.0.255 scope global dynamic noprefixroute ã€Œwlxe84e069f6dd6ã€ãŒãƒ‡ãƒã‚¤ã‚¹IDã«ãªã‚‹ã€‚ ï¼ˆwlx[12æ¡]ã®å›ºæœ‰ã®ãƒ‡ãƒã‚¤ã‚¹IDãŒå‰²ã‚Šå½“ã¦ã‚‰ã‚Œã‚‹ä»•æ§˜ï¼‰ WiFiã‚’å›ºå®šIPã«ã™ã‚‹ã«ã¯ã€dhcpcdã‚’åˆ©ç”¨ã™ã‚‹ã®ãŒæœ€ã‚‚ç°¡å˜ãªæ–¹æ³•ã€‚ dhcpcdã¯æ¨™æº–ã§ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ãªã„ãŸã‚ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã€‚ $ sudo apt in
ryskosn 2013/01/15
Debian

MySQL
ãƒªãƒ³ã‚¯
ãƒˆãƒ¤ãƒ².ãƒãƒƒãƒˆ
ã“ã®ã‚¨ãƒªã‚¢ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã¯ã€ãƒã‚°ã‚¤ãƒ³è‹¥ã—ãã¯è¨±å¯ã•ã‚ŒãŸæ¨©é™ãŒå¿…è¦ã§ã™ã€‚ ãƒšãƒ¼ã‚¸ãŒè‡ªå‹•çš„ã«æ›´æ–°ã•ã‚Œãªã„å ´åˆã¯ã“ã“ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„
ryskosn 2013/01/15
MySQL
ãƒªãƒ³ã‚¯
ã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒã‚°ï¼šã‚µãƒ¼ãƒ“ã‚¹ã¯çµ‚äº†ã—ã¾ã—ãŸã€‚
ã€Œã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒã‚°ã€ã¯ 2023å¹´1æœˆ31æ—¥ ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹æä¾›ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ 2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‚ˆã‚Š19å¹´è¿‘ãã‚‚ã®é–“ã€æ²¢å±±ã®çš†ã•ã¾ã«ã”æ„›ç”¨ã„ãŸã ãã¾ã—ãŸã“ã¨ã‚’å¿ƒã‚ˆã‚ŠãŠç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ä»Šå¾Œã¨ã‚‚ã€BIGLOBEã‚’ã”æ„›é¡§è³œã‚Šã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚ â€»å¼•ã£è¶Šã—å…ˆãƒ–ãƒã‚°ã¸ã®ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã‚µãƒ¼ãƒ“ã‚¹ã¯2024å¹´1æœˆ31æ—¥ã§çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ BIGLOBEã®ã‚µãƒ¼ãƒ“ã‚¹ä¸€è¦§
ryskosn 2013/01/15
MySQL

Debian
ãƒªãƒ³ã‚¯
qmailã«å±Šã„ãŸãƒ¡ãƒ¼ãƒ«ã‚’ã€PHPã‚’ã¤ã‹ã£ã¦MySQLã«æ ¼ç´ã—ãŸã„ã¨æ€ã£ã¦ã„ã¾ã™ã€‚â€¦
qmailã«å±Šã„ãŸãƒ¡ãƒ¼ãƒ«ã‚’ã€PHPã‚’ã¤ã‹ã£ã¦MySQLã«æ ¼ç´ã—ãŸã„ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ã“ã†ã„ã£ãŸã‚„ã‚Šæ–¹ã‚’è§£èª¬ã—ã¦ã„ã‚‹ãƒšãƒ¼ã‚¸ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ ã¡ãªã¿ã«OSã¯linuxã§ã™ã€‚
ryskosn 2013/01/15
DB

MySQL
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸