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

kulamochi id:kulamochi

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

${{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ã®æ–‡å—åŒ–ã‘ã«"SET NAMES"ã‚’ä½¿ã£ãŸã‚‰ãƒ€ãƒ¡ã‚‰ã—ã„ã€‚ã€‚ - åŒ»è€…ã‚’å¿—ã™å¦»ã‚’å¿œæ´ã™ã‚‹å¤«ã®æ—¥è¨˜
MySQLã®ãƒ‡ãƒ¼ã‚¿ãŒæ–‡å—åŒ–ã‘ã—ã¾ã™ã€‚é€šå¸¸ã¯ã€my.confã‚’ä¿®æ£ã—ã¦è§£æ±ºã—ã¾ã™ã€‚ PHPã§MySQLã‹ã‚‰å–ã‚Šå‡ºã—ãŸãƒ‡ãƒ¼ã‚¿ãŒæ–‡å—åŒ–ã‘ã™ã‚‹æ™‚ã®è§£æ±ºæ–¹æ³• - ã“ã®ãƒ–ãƒã‚°ã¯è¨¼æ˜Žã§ããªã„ã€‚ ã¨ã“ã‚ãŒã€å…±ç”¨ã‚µãƒ¼ãƒãƒ¼ã®å ´åˆã€my.confã‚’è§¦ã‚Œã¾ã›ã‚“ã€‚ãã“ã§ã€SET NAMESã‚’ä½¿ã„ã¾ã™ã€‚PHPã ã¨ã€ã“ã‚“ãªã‚«ãƒ³ã‚¸ã€‚ mysql_query('SET NAMES utf8'); ã¨ã“ã‚ãŒã€ã¨ã“ã‚ãŒã€SET NAMESã¯ä½¿ã£ã¦ã¯ã„ã‘ãªã„ã‚‰ã—ã„ã§ã™ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®è„†å¼±æ€§ãŒã‚ã‚‹ã®ã ã¨ã‹ã€‚ no title ãã®å¯¾å¿œç–ã§ã™ã€‚PHPã ã¨ã€ã“ã‚“ãªã‚«ãƒ³ã‚¸ã€‚ mysql_set_charset('utf8'); æ³¨æ„: æ–‡å—ã‚»ãƒƒãƒˆã‚’å¤‰æ›´ã™ã‚‹ã«ã¯ã“ã®æ–¹æ³•ã‚’ä½¿ã†ã“ã¨ã‚’æŽ¨å¥¨ã—ã¾ã™ã€‚ mysql_query() ã§ SET NAMES .. ã‚’å®Ÿè¡Œã™ã‚‹æ–¹æ³•ã¯ãŠå‹§ã‚ã§ãã¾ã›ã‚“ã€‚ PHP: mysql_set_charse
kulamochi 2018/07/03
MySQL

PHP

tips
ãƒªãƒ³ã‚¯
MySQLã§group byãªã—ã§countã¨order byã‚’åŒæ™‚ã«ä½¿ã†ã¨ã‚¨ãƒ©ãƒ¼ - ã¼ã£ã¡å‹‰å¼·ä¼š
MySQLã¨Laravelã®è©±ã§ã™ã€‚ MySQLã®SQL_MODEã«ONLY_FULL_GROUP_BYãŒæŒ‡å®šã•ã‚Œã¦ã„ã‚‹ã¨ã€group byç„¡ã—ã§countã¨order byã‚’åŒæ™‚ã«ä½¿ã†ã¨ä»¥ä¸‹ã®ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã¾ã™ã€‚ ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ Server version: 5.6.36 MySQL Community Server (GPL) 5.6.36ä»¥å‰ã¯ç¢ºèªã—ã¦ã„ã¾ã›ã‚“ 5.7.17ã§ã¯ç™ºç”Ÿã—ã¾ã›ã‚“ã§ã—ãŸ å†ç¾ -- ã‚µãƒ³ãƒ—ãƒ«ã®ãƒ†ãƒ¼ãƒ–ãƒ« mysql> desc foo; +-------+---------+------
kulamochi 2018/07/03
mysql_query("set session sql_mode='ã€œã€œ'") ã§ã‚»ãƒƒã‚·ãƒ§ãƒ³ã”ã¨ã«è¨å®šã‚’ä¸Šæ›¸ã

MySQL

PHP

tips
ãƒªãƒ³ã‚¯
http://blog.inouetakuya.info/entry/20130320/1363776504
kulamochi 2016/02/05
MySQL

server

tips
ãƒªãƒ³ã‚¯
ãƒ‹ã‚³ãƒ‹ã‚³ãƒ‹ãƒ¥ãƒ¼ã‚¹ã§ã‚‚ä½¿ã‚ã‚Œã¦ã„ã‚‹å…¨æ–‡æ¤œç´¢ãƒ‘ãƒ¼ã‚µãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€ŒMySQL-ftppcã€ã®MySQL-5.6å¯¾å¿œç‰ˆã‚’ä½œã‚Šã¾ã—ãŸ - Y-Ken Studio
MySQL-ftppc (MySQL full-text parser plugin collection) ã¨ã„ã†ã€å…¨æ–‡æ¤œç´¢ãƒ‘ãƒ¼ã‚µãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã¯ã”å˜ã˜ã§ã—ã‚‡ã†ã‹ã€‚ ã“ã‚Œã¯MySQLæ¨™æº–ã® Full Text Parser ã‚’ç½®ãæ›ãˆã‚‹ã‚‚ã®ã§ã€hiroaki-kawaiæ°ã«ã‚ˆã£ã¦ã“ã®ä¸–ã«ç”Ÿã¾ã‚Œã¾ã—ãŸã€‚ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¯MyISAMã‚’åˆ©ç”¨ã—ã¾ã™ã®ã§ã€ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆãªã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ãŒç‰¹å¾´ã§ã™ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¨ã—ã¦ã¯400ä¸‡è¡Œã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãƒ•ã‚¡ã‚¤ãƒ«.MYIã®ã‚µã‚¤ã‚ºãŒ2GBã‚’å¯¾è±¡ã®æ¤œç´¢ã§0.8ç§’ç¨‹ã¨ã€æ±ºã—ã¦é€Ÿãã¯ç„¡ã„ã®ã§ã€100ä¸‡è¡Œãã‚‰ã„ã¾ã§ã®ãƒ‡ãƒ¼ã‚¿å‘ãã§ã™ã€‚ Tritonn (MySQL-5.0 + Senna)ã‚’åˆ©ç”¨ã—ã¦ãŠã‚Šã€InnoDBã®æ€§èƒ½å‘ä¸Šã‚’ä¸»ãªç›®çš„ã¨ã—ã¦MySQL-5.5ã‚„5.6ã¸ã®ç§»è¡Œã‚’æœ›ã‚“ã§ã„ã‚‹ãŒã€å…¨æ–‡æ¤œç´¢ã®æ‰±ã„ã«å›°ã£ã¦ã„ã‚‹æ–¹ ã«ã‚ªã‚¹ã‚¹ãƒ¡ã§ã™ã€‚ ãƒ‹ã‚³ãƒ‹ã‚³ãƒ‹ãƒ¥ãƒ¼ã‚¹ãªã©ã§æŽ¡ç”¨ã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†å®Ÿ
kulamochi 2014/09/29
MySQL

plugin

tips
ãƒªãƒ³ã‚¯
API Documentation
SQLLikeValueCallback() SQLLikeValueCallback(string $value) : string A sample SQL-value callback function suitable for SQL LIKE operator Escapes meta characters for LIKE operator and replaces '*' to '%'. Also prepends and appends '%'. Parameters
kulamochi 2014/09/19
PHP

library

MySQL
ãƒªãƒ³ã‚¯
jpn.ph
This domain may be for sale!
kulamochi 2014/09/03
php

library

MySQL
ãƒªãƒ³ã‚¯
MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ - Archiva
Make a note of it: Web tech, montaineering, and so on. ã€Žå®Ÿè·µãƒã‚¤ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQLã€4ç« ã®ã¾ã¨ã‚ã€‚ä¸ã‹ã‚‰7ç‚¹ã‚’ãƒ”ãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€‚ è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã‚ˆã‚‰ãªã„ã‚½ãƒ¼ãƒˆ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã‚ˆã‚‹åˆ¶ç´„æ¡ä»¶ ãƒ•ãƒ«ãƒ†ã‚ã‚¹ãƒˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰ã¯é‡ã„ éžå¸¸ã«å¤šæ•°ã®è¡Œã«ä¸€è‡´ã™ã‚‹å ´åˆ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æƒ…å ±ã®è¡¨ç¤º èªã‚“ã ã®ã¯4ç« ã¨5ç« ã€‚ä»–ã¯ã‚µãƒ¼ãƒè¨å®šã¨ã‹ãƒ‡ãƒ¼ã‚¿åˆ†æ•£ã¨ã‹ã€ç’°å¢ƒæ§‹ç¯‰ã«è¿‘ã„ãƒ‡ã‚£ãƒ¼ãƒ—ãªè©±ã€‚SQLãƒ¬ãƒ™ãƒ«ã ã¨ã“ã®è¾ºã§ååˆ†ã§ã—ã‚‡ã€‚é•·ã„ã®ã§ã€5ç« ã®ã¾ã¨ã‚ã¯ã¾ãŸå¾Œã§ã€‚ ãƒžãƒ«ãƒã‚«ãƒ©ãƒ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã¨ã“ã‚ã§ã€å˜ã«2ã¤ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œæˆã—ãŸã®ã§ã¯ã€ã ã‚ãªã®ã ã‚ã†ã‹ã€‚ãã†ã—ã¦ã‚‚ã‹ã¾ã‚ãªã„ãŒã€MySQLã¯ã€ä¸¡æ–¹ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’åŒæ™‚ã«ä½¿ç”¨ã™ã‚‹ã“ã¨ã¯ã§ããªã„ã€‚ã“ã®äº‹å®Ÿã¯ã€ç¹°ã‚Šè¿”ã—è¿°ã¹ã‚‹ã«å€¤ã™ã‚‹ã»ã©é‡è¦ã§ã‚ã‚‹ã€‚ã€ŒMySQLã§ã¯ã€1ã¤ã®ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã¨ãã€
kulamochi 2014/08/13
MySQL

é–‹ç™º

tips
ãƒªãƒ³ã‚¯
MySQLã§auto_incrementã‚’ä½¿ã‚ãšè‡ªåŠ›ã§æŽ¡ç•ªã™ã‚‹ - æ–‡ç³»ãƒ—ãƒã‚°ãƒ©ãƒžã«ã‚ˆã‚‹TIPSãƒ–ãƒã‚°
ã§ãã¾ã™ã‚ˆã€œ MySQLã«ã¯auto-increment-incrementã¨auto-increment-offsetã¨ã„ã†è¨å®šãŒã‚ã£ã¦ã€auto_incrementã®å€¤ã‚’å¶æ•°ãƒ»å¥‡æ•°ã«å›ºå®šã™ã‚‹äº‹ãŒã§ãã¾ã™ã€‚ [server01] auto-increment-increment = 2 auto-increment-offset = 1 [server02] auto-increment-increment = 2 auto-increment-offset = 2server01ã¯1å§‹ã¾ã‚Šã§+2ã¥ã¤ã•ã‚Œã‚‹ã®ã§ã€å¥‡æ•°ã«ãªã‚‹ã€‚1,3,5,7.... server02ã¯2å§‹ã¾ã‚Šã§+2ã¥ã¤ã•ã‚Œã‚‹ã®ã§ã€å¶æ•°ã«ãªã‚‹ã€‚2,4,6,8.... ã“ã®ç’°å¢ƒã ã¨auto_incrementã®å€¤ãŒæ¯æŠœã‘ã«ãªã£ã¦ã—ã¾ã†ã—ã€insertã™ã‚‹éš›ã«DBã‚µãƒ¼ãƒã«ã‚ˆã£ã¦æŽ¡ç•ªå€¤ãŒå¶æ•°ã‹å¥‡æ•°ã‹ä¸å®šãªã®ã§ã€è‡ªåŠ›ã§æŽ¡ç•ªã™ã‚‹æ–¹æ³•ã‚’
kulamochi 2014/04/28
MySQL

tips
ãƒªãƒ³ã‚¯
å¤§å®¹é‡ã®SQLãƒ•ã‚¡ã‚¤ãƒ«ã‚’MySQLã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ - Javaãªæ—¥ã€…
ã¨ã‚ã‚‹ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§100MBï¼ˆè‡ªåˆ†çš„ã«å‰²ã¨å¤§å®¹é‡ï¼‰ã®SQLãƒ•ã‚¡ã‚¤ãƒ«ã‚’å¼•ãç¶™ã„ã ã®ã§ï¼Œãã‚Œã‚’ã•ãã‚‰ã®ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã¦ã¿ã¾ã™ï¼Ž ç’°å¢ƒ ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ï¼ˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ï¼‰ MySQL Server 5.5.15 PuTTY ã”ã£ãŸç…®ç‰ˆ 0.60 æ‰‹é † phpMyAdminã§ã‚ã‚‰ã‹ã˜ã‚ã‚¤ãƒ³ãƒãƒ¼ãƒˆå…ˆã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã—ã¦ãŠãï¼Ž ï¼ˆmysqlã‚³ãƒžãƒ³ãƒ‰ã‚’å©ã„ã¦ã‚‚ã„ã„ã¨æ€ã„ã¾ã™ï¼Žï¼‰ PuTTYã§è‡ªåˆ†ã®ã‚µãƒ¼ãƒãƒ¼ã«æŽ¥ç¶šï¼Ž % ssh [è‡ªåˆ†ã®ãƒ‰ãƒ¡ã‚¤ãƒ³].sakura.ne.jpä½œæ¥ã—ã‚„ã™ã„ã‚ˆã†ã«ï¼Œã‚«ãƒ¬ãƒ³ãƒˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹SQLãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ãŠãã¾ã™ï¼Ž mysqlã‚³ãƒžãƒ³ãƒ‰ã‚’å©ã„ã¦ãƒã‚°ã‚¤ãƒ³ï¼Ž % mysql --host=mysql[è‡ªåˆ†ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ã®ç•ªå·].db.sakura.ne.jp --user=[ãƒ¦ãƒ¼ã‚¶ãƒ¼å] --password
kulamochi 2013/09/12
MySQL

sakura

tips
ãƒªãƒ³ã‚¯
WordPress â€º WP-DBManager Â« WordPress Plugins
This plugin hasnâ€™t been tested with the latest 3 major releases of WordPress. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress. Description Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic schedulin
kulamochi 2013/09/02
wordpress

plugin

MySQL
ãƒªãƒ³ã‚¯
MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®åŸºæœ¬
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—å‹‰å¼·ä¼š#2 (#bkstudy) ã§ã®ç™ºè¡¨è³‡æ–™ã§ã™ã€‚ http://atnd.org/event/bkstudy02 MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®åŸºæœ¬çš„ãªå†…å®¹ã«ã¤ã„ã¦ã¾ã¨ã‚ã¦ã„ã¾ã™ã€‚Read less
kulamochi 2013/04/12
database

MySQL

tips
ãƒªãƒ³ã‚¯
MySQL ç”¨ root ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã™ã‚‹ã«ã¯ | XpressOne Knowledge Base ã€Œã‚µãƒãƒ¼ãƒˆæŠ€è¡“æƒ…å ±ã€
ã“ã®æ–‡æ›¸ã«ã¯ã”åˆ©ç”¨Linuxã‚µãƒ¼ãƒãƒ¼ã«ãŠã„ã¦ã€Mï½™SQLç®¡ç†è€…ã‚¢ã‚«ã‚¦ãƒ³ãƒˆï¼ˆrootï¼‰ã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã™ã‚‹æ–¹æ³•ã‚’è¨˜è¼‰ã—ã¾ã™ã€‚ MySQL ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç›´å¾Œã¯ MySQL ã®ç®¡ç†è€…ã‚¢ã‚«ã‚¦ãƒ³ãƒˆ root ã«ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒè¨å®šã•ã‚Œã¦ã„ãªã„ã®ã§ã€ã§ãã‚‹ã ã‘æ—©ããƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¨å®šã™ã‚‹ã“ã¨ã‚’ãŠå¥¨ã‚ã—ã¾ã™ã€‚ 1ï¼Žåˆ©ç”¨ç’°å¢ƒ ãƒ»MySQL-4.XåŠã³5.X 1ï¼ŽMysqlAdminã«ã‚ˆã‚‹ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰è¨å®š MySQL ãŒç¨¼å‹•ã—ã¦ã„ã‚‹çŠ¶æ³ã§ã€ã‚·ã‚¹ãƒ†ãƒ ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã® root ã¨ã—ã¦ä»¥ä¸‹ã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ # mysqladmin -u root password æ–°ã—ã„ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ â€»ã“ã®éš›ã€ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã« # ã‚„ & ç‰è¨˜å·ãŒå«ã¾ã‚Œã‚‹å ´åˆã¯ã‚·ãƒ³ã‚°ãƒ«ã‚¯ã‚©ãƒ¼ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’å›²ã‚“ã§å…¥åŠ›ã—ã¾ã™ã€‚ ã‚‚ã— mysqladmin ã‚³ãƒžãƒ³ãƒ‰ãŒä½¿ãˆãªã„å ´åˆã¯ä»¥ä¸‹æ–¹æ³•ã§è¨å®šã—ã¾ã™ã€‚ 2.MySQLã«ãƒã‚°ã‚¤ãƒ³ã—ã¦ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰è¨å®š MySQ
kulamochi 2013/02/28
MySQL

security

tips
ãƒªãƒ³ã‚¯
DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦éžå¸¸ã«é‡è¦ã¨ãªã‚‹ãƒ¡ãƒ¢ãƒª(ãƒãƒƒãƒ•ã‚¡)é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ DSASã®ã¨ã‚ã‚‹DBã‚µãƒ¼ãƒ(å®Ÿãƒ¡ãƒ¢ãƒª4GB)ã®å®Ÿéš›ã®è¨å®šå€¤ ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãŸã€å¿…è¦ãƒ¡ãƒ¢ãƒªã®ç·é‡ã®è¨ˆç®—ã‚„é™ç•Œå€¤ã‚’è¶Šãˆã¦ãªã„ã‹ãƒã‚§ãƒƒã‚¯ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚‚ç´¹ä»‹ã—ã¾ã™ã€‚ æ˜¯éžã€å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ï¼ ã¾ãšæœ€åˆã«æ³¨æ„ç‚¹ã‚’ã€‚ ãƒãƒƒãƒ•ã‚¡ã«ã¯2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¯mysqldå…¨ä½“ã§ãã®ãƒãƒƒãƒ•ã‚¡ãŒ1ã¤ã ã‘ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã€ ã“ã‚Œã«å¯¾ã—ã€ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã¯ã‚¹ãƒ¬ãƒƒãƒ‰(ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³)ã”ã¨ã«ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®éš›ã«ã¯ã‚°ãƒãƒ¼ãƒãƒ«/ã‚¹ãƒ¬ãƒƒãƒ‰ã®é•ã„ã‚’æ„è˜ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ ãªãœãªã‚‰ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã«å¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¢—ãˆãŸã¨ãŸã‚“ã«ã‚¢ãƒƒã¨ã„ã†é–“ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã£ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ in
kulamochi 2012/07/08
MySQL

tips
ãƒªãƒ³ã‚¯
1å°ã‹ã‚‰500å°ã¾ã§ã®MySQLé‹ç”¨ MySQL Beginners
5. On-Demand WorkforceWorkforce On-Demand On-Demand Workforce On-Demand Workforce On-Demand Workforce Our Service (livedoor) Amazon MechanicalAmazon Mechanical Turk Mechanical Turk Amazon Mechanical Turk Mechanical Turk Turk Amazon Amazon t/ Workers Workers Requester Requester On-Demand WorkforceWorkforce On-Demand On-Demand Workforce On-Demand Workforce On-Demand Workforce Amazon MechanicalAmazon
kulamochi 2012/05/30
CloudForecastã¨ã„ã†ãƒ¡ãƒˆãƒªã‚¯ã‚¹ãƒ»ãƒªã‚½ãƒ¼ã‚¹ç›£è¦–ã®ä»•çµ„ã¿ãŒã‚ã‚‹ã¿ãŸã„ã€‚

MySQL

tips
ãƒªãƒ³ã‚¯
åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹
1. åˆå¿ƒè€…å‘ã‘ MySQLã®å§‹ã‚æ–¹ MySQL Beginners Talk ã¨ã¿ãŸã¾ã•ã²ã‚ 2012-05-29 åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹ - MySQL Beginners Talk Powered by Rabbit 1.0.6 2. è‡ªå·±ç´¹ä»‹ âœ“ ã¨ã¿ãŸã¾ã•ã²ã‚ âœ“ MySQLãƒ¦ãƒ¼ã‚¶ä¼š(ä»£è¡¨) âœ“ id:tmtms âœ“ @tmtms âœ“ Rubyã‹ã‚‰MySQLã‚’ä½¿ã†ãƒ©ã‚¤ãƒ–ãƒ©ãƒªæ›¸ã„ãŸã‚Š 1/80 åˆå¿ƒè€…å‘ã‘MySQLã®å§‹ã‚æ–¹ - MySQL Beginners Talk Powered by Rabbit 1.0.6
kulamochi 2012/05/30
MySQL

tips

æ›¸ç±
ãƒªãƒ³ã‚¯
MySQLãŒãŠã‹ã—ã„ï¼ã‚ãªãŸãªã‚‰ã©ã†ã—ã¾ã™ã‹ï¼Ÿ â€“ MySQL Casual Advent Calendar 2011 - As a Futurist...
ã—ã‚ã£ã™ï¼DBA å…¼ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å…¼ã‚¿ã‚¹ã‚¯ãƒžãƒãƒ¼ã‚¸ãƒ£ã‚„ã£ã¦ã‚‹ riywo ã§ã™ã€‚ä½•ã®ãƒã‚¿ã‚’æ›¸ã“ã†ã‹ãªãã¨è€ƒãˆãŸã®ã§ã™ãŒã€æ£ç›´ãƒã‚¿ã‚’ä»•è¾¼ã‚€æ™‚é–“ã‚‚ãªã‹ã£ãŸã®ã§åƒ•ãŒã„ã¤ã‚‚ã‚„ã£ã¦ã‚‹ã“ã¨ã‚’ã•ã‚‰ã£ã¨ç´¹ä»‹ã™ã‚‹ã¨ã„ã†ã“ã¨ã§å‹˜å¼ã—ã¦ä¸‹ã•ã„ï¼žï¼œ MySQL ãŒãŠã‹ã—ã„ï¼ 03:14 hidek: ãªã‚“ã‹ã‚¨ãƒ©ãƒ¼å‡ºã¾ãã£ã¦ã‚‹ã‚“ã ã‘ã©ï¼ 03:14 zigorou: MySQL ã¨é€šä¿¡ã—ã¦ã‚‹ã¨ã“ã£ã½ã„ 03:15 riywo: è¦‹ã¾ã™ ã“ã‚“ãªã‚„ã‚Šã¨ã‚Šã¯çš†ã•ã‚“æ—¥å¸¸èŒ¶é£¯äº‹ã§ã™ã‚ˆãï¼Ÿãï¼Ÿãï¼Ÿã“ã‚“ãªæ™‚ã«ã€DB ã«è²¬ä»»ã‚’æŒã¤ã‚‚ã®ã¨ã—ã¦çœŸã£å…ˆã«å¯¾å¿œã™ã‚‹ã®ãŒåƒ•ã‚‰ã®ä»•äº‹ã§ã™ã€‚ã§ã‚‚ã€ã˜ã‚ƒã‚å…·ä½“çš„ã«ã“ã®ã‚ã¨ä½•ã‚’ã—ã¾ã—ã‚‡ã†ï¼Ÿæ—¢ã«ã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¨ãƒ©ãƒ¼ã ã‚‰ã‘ã§ä¸€åˆ»ã‚’äº‰ã†çŠ¶æ…‹ã§ã™ã€‚ (å¯¾å¿œé–‹å§‹) ã¾ãšã¯ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ ä»Šå›žã®æ§˜ãªå ´åˆã¯ã‚¢ãƒ—ãƒªã®ã‚¨ãƒ©ãƒ¼ãƒã‚°ã«ã©ã°ã£ã¨ MySQL ã«é–¢ã™ã‚‹ã‚¨ãƒ©ãƒ¼ãŒå‡ºã¦ã„ã‚‹ã§ã—ã‚‡ã†ã€‚ã¾ãšã¯ãã‚Œã‚’è¦‹ã‚‹ã“ã¨ãŒå§‹ã¾
kulamochi 2011/12/02
MySQL

tips
ãƒªãƒ³ã‚¯
iOS5ã®çµµæ–‡å—ã¨ã‚¬ãƒ©ã‚±ãƒ¼ã‚¹ãƒžãƒ›ä¸¡å¯¾å¿œã‚µãƒ¼ãƒ“ã‚¹ã§ã©ã†mysqlã«ä¿å˜ã™ã‚‹ã‹ : maaash.jp
Posted on 10æœˆ 20, 2011 Filed Under emoji, perl | iOS5ã‹ã‚‰çµµæ–‡å—ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã§å…¥åŠ›ã—ãŸçµµæ–‡å—ãŒUnicode6ã«ãªã£ãŸã¨ã„ã†ã“ã¨ã§ã€ çµµæ–‡å—ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã§çµµæ–‡å—ã‚’å…¥åŠ›ã™ã‚‹ã¨ã©ã‚“ãªã‚³ãƒ¼ãƒ‰ã«ãªã‚‹ã®ã‹ã€ãƒ€ãƒ³ãƒ—ã—ã¦ã¿ã¾ã—ãŸã€‚ ã“ã®è¨˜äº‹ã®æœ€å¾Œã«ã®ã£ã‘ã¦ãŠãã¾ã™ã€‚ ã•ã¦ * MySQL5.5ä»¥ä¸Šã˜ã‚ƒãªã„ã¨4ãƒã‚¤ãƒˆã®utf8ã¯ä¿å˜ã§ããªã„ * iPhoneã§å…¥åŠ›ã—ãŸçµµæ–‡å—ã‚’ã‚¬ãƒ©ã‚±ãƒ¼ã§è¡¨ç¤ºã—ãŸã„ ã¨ã„ã†æ™‚ã«ã€ã©ã†ã™ã‚‹ã®ãŒã‚ˆã„ã®ã§ã—ã‚‡ã†ï¼Ÿ MySQL5.5ã§ãªã„MySQLã«ä½•ã‚’ä¿å˜ã™ã‚‹ã‹ã€ã¨ã„ã†ã¨ã“ã‚ã§è€ƒãˆã‚‹ã¨ã‚ˆã„ã®ã ã‚ã†ã‹ æ¡ˆ1) DBã«ã¯ Encode::JP::Emoji ã® x-utf8-e4u-mixed ã‚’ä¿å˜ã™ã‚‹å ´åˆ å…¨éƒ¨ã®å…¥åŠ› -> decode(â€™x-utf8-e4u-mixedâ€™, $input) -> mysql(mysq
kulamochi 2011/10/24
iOS5

MySQL

Perl
ãƒªãƒ³ã‚¯
Senna çµ„ã¿è¾¼ã¿åž‹å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ - Senna çµ„ã¿è¾¼ã¿åž‹å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³
This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.
kulamochi 2011/06/02
MySQL

database

free
ãƒªãƒ³ã‚¯
mysqlã§CASEæ–‡ã‚’ä½¿ã£ã¦ã¿ã‚‹ - (ï¾Ÿâˆ€ï¾Ÿ)oå½¡ sasata299's blog
2008å¹´06æœˆ15æ—¥00:02 MySQL mysqlã§CASEæ–‡ã‚’ä½¿ã£ã¦ã¿ã‚‹ åƒ•ã¯ã„ã¤ã‚‚DBMSã¨ã—ã¦ã€MySQLã‚’ä½¿ã£ã¦ã„ã¾ã™ã€‚ä»Šæ—¥ã¯å‹‰å¼·ã¨ã—ã¦ã€CASEæ–‡ã¨ã„ã†ã‚‚ã®ã‚’ä½¿ã£ã¦ã¿ã¾ã™ã€‚æ—©é€Ÿã§ã™ãŒã€ä½¿ã„æ–¹ã¯ã“ã‚“ãªæ„Ÿã˜ã§ã™ã€‚ CASE WHEN æ¡ä»¶ THEN å€¤1 ELSE å€¤2 END ã“ã‚Œã¯ä¾¿åˆ©ï¼( ï¾Ÿâˆ€ï¾Ÿ)ï½±ï¾Šï¾Šå…«å…«ï¾‰ãƒ½ï¾‰ãƒ½ï¾‰ãƒ½ï¾‰ ï¼¼ / ï¼¼/ ï¼¼ æ¡ä»¶ãŒçœŸã ã£ãŸã‚‰ã€å€¤1ãŒã€å½ã ã£ãŸã‚‰å€¤2ãŒä½¿ã‚ã‚Œã¾ã™ã€‚ ã“ã‚“ãªãƒ†ãƒ¼ãƒ–ãƒ« (hogehoge) ãŒã‚ã£ãŸã¨ã—ã¦ã€ ----------------- | id | name | ----------------- | 1 | sasaki | | 2 | tanaka | | 3 | satou | | 4 | yamada | | 5 | sasaki | | 6 | nakamura | ----------------- ã“ã‚“ãªæ„Ÿã˜
kulamochi 2011/05/30
MySQL

tips
ãƒªãƒ³ã‚¯
MySQL ã§ NULL ã‚’ä¸€ç•ªæœ€å¾Œã«ã—ã¦æ˜‡é †ã«ã‚½ãƒ¼ãƒˆã™ã‚‹ | Sun Limited Mt.
2008.2.27 è¿½è¨˜ ã‚³ãƒ¡ãƒ³ãƒˆã§æ•™ãˆã¦ã„ãŸã ãã¾ã—ãŸä¸‹è¨˜æ–¹æ³•ã§ç°¡å˜ã«ã§ãã¾ã—ãŸã€‚ is null asc ã®æŒ‡å®šã¨ é€šå¸¸ã® asc ã®æŒ‡å®šã‚’ã™ã‚‹ã®ãŒãƒã‚¤ãƒ³ãƒˆã§ã™ãã€‚ SELECT id, comment FROM table ORDER BY comment IS NULL ASC, comment ASC; â€”â€“è¿½è¨˜ã“ã“ã¾ã§â€”â€“ MySQL ã§æ˜‡é †ã«ã‚½ãƒ¼ãƒˆã™ã‚‹ã¨ NULL ã¯ä¸€ç•ªæœ€åˆã«æ¥ã¾ã™ã€‚ ãã‚Œã‚’æœ€å¾Œã«ã§ããªã„ã‹ã¨ã„ã†ã“ã¨ã§ä¸‹è¨˜ã®ã‚ˆã†ãªSQL ã‚’è€ƒãˆã¦ã¿ã¾ã—ãŸã€‚ SELECT id, comment, CASE WHEN comment IS NULL THEN 10000 ELSE ASCII(LEFT(comment,1)) END AS dummy FROM table ORDER BY dummy ASC, COMMENT ASC comment ã‚«ãƒ©ãƒ ã‚’æ˜‡é †ã§ã‚½ãƒ¼ãƒˆã—ã¦
kulamochi 2011/05/19
MySQL

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