[B! sql] rekramkoobã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

rekramkoob id:rekramkoob

sqlã«é–¢ã™ã‚‹rekramkoobã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (167)

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

ï¼–ï¼Žï¼‘ï¼‘ã€€ã‚ã„ã¾ã„æ¤œç´¢
ï¼–ï¼Žï¼‘ï¼‘ã€€ã‚ã„ã¾ã„æ¤œç´¢ â– LIKEæ¼”ç®—åã¨ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰æ–‡å—ã€Œ%ã€ WHEREå¥ã§ã€æ–‡å—åˆ—ã®éƒ¨åˆ†ä¸€è‡´æ¡ä»¶ã‚’ä½¿ã†å ´åˆã¯ã€LIKEæ¼”ç®—åã¨ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰æ–‡å—ã€Œ%ã€ï¼ˆåŠè§’ï¼‰ã‚’ä½¿ã„ã¾ã™ã€‚ãƒ¯ã‚¤ãƒ«ãƒ‰ã‚«ãƒ¼ãƒ‰æ–‡å—ã€Œ%ã€ã¯ï¼æ–‡å—ä»¥ä¸Šã®ä»»æ„ã®æ–‡å—åˆ—ã‚’æ„å‘³ã—ã¾ã™ã€‚ æœ«å°¾ãŒã€Œå®šé£Ÿã€ã¨ãªã‚‹å•†å“åã‚’å«ã‚€ã„ã‚ã‚†ã‚‹å¾Œæ–¹ä¸€è‡´æ¤œç´¢ã®å ´åˆã¯ã€ã€ŒLIKEã€€'%å®šé£Ÿã€ã®ã‚ˆã†ã«ã—ã¾ã™'ã€‚ WHEREã€€ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã€€LIKEã€€'%æ–‡å—åˆ—' å‰æ–¹ä¸€è‡´æ¤œç´¢ã®å ´åˆã¯ã€ã€ŒLIKEã€€'å±±%'ã€ã®ã‚ˆã†ã«ã—ã¾ã™ã€‚ WHEREã€€ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã€€LIKEã€€'æ–‡å—åˆ—%' éƒ¨åˆ†ä¸€è‡´æ¤œç´¢ã®å ´åˆã¯ã€ã€ŒLIKEã€€'%å¹¸%'ã€ã®ã‚ˆã†ã«ã—ã¾ã™ã€‚ WHEREã€€ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰åã€€LIKEã€€'%æ–‡å—åˆ—%' æ–‡å—åˆ—ã«å¤‰æ•°ã€Œ$strã€ã‚’ä½¿ã†å ´åˆã¯ã€å¤‰æ•°ã‚’ç¤ºã™ç‰¹æ®Šæ–‡å—ã€Œ$ã€ã‚’å†è©•ä¾¡ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã®ã§ã€ã€Œ'ã€ï¼ˆã‚·ãƒ³ã‚°ãƒ«ã‚¯ã‚©ãƒ¼ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰ã®ä»£ã‚ã‚Šã«ã€Œ"ã€ï¼ˆãƒ€ãƒ–ãƒ«ã‚¯ã‚©ãƒ¼ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ï¼‰ã§å›²ã¿
rekramkoob 2009/03/06
*tips

sql

search
ãƒªãƒ³ã‚¯
SQL æ–‡å—é–¢æ•° - é€£çµã€ç©ºç™½å‰Šé™¤ã€ç½®æ›ã€åˆ‡å‡ºã€æ¤œç´¢ã€é•·ã•ã€æ•°å€¤å¤‰æ›ä»– - SAK Streets
SQL æ–‡å—é–¢æ•° - é€£çµã€ç©ºç™½å‰Šé™¤ã€ç½®æ›ã€åˆ‡å‡ºã€æ¤œç´¢ã€é•·ã•ã€æ•°å€¤å¤‰æ›ä»– åŸºæœ¬çš„ã« Oracleã€SQL-Serverã€MDB ã§å…±é€šã§ã™ã€‚ â– æ–‡å—åˆ—é€£çµ ãƒ»concat() é–¢æ•°ã¯ã€æ–‡å—åˆ—ã‚’çµåˆã™ã‚‹ã—ãŸçµæžœã‚’è¿”ã™ã€‚ ã€Œ||ã€æ¼”ç®—åã®æ–¹ãŒç°¡å˜ã¨æ€ã†ãŒã©ã†ã§ã—ã‚‡ã†ã€‚ (Access ã§ã¯ ã€Œ&ã€ã‚’ä½¿ç”¨ã™ã‚‹ã€‚) select å“ç•ª, concat('part-', å“ç•ª), 'part-' || å“ç•ª from sak.å—æ³¨m order by å“ç•ª ; â– chr æ–‡å—å¤‰æ› ãƒ»chr() é–¢æ•°ã¯ã€ã‚³ãƒ¼ãƒ‰ã«è©²å½“ã™ã‚‹ ASCII æ–‡å—ã‚’è¿”ã™ã€‚ ã“ã®ä¾‹ã§ã¯ã€ã€Œ1ã€ã¨è¨€ã†æ–‡å—ãŒè¿”ã‚‹ã€‚ select å“ç•ª, chr(49) from sak.å—æ³¨m order by å“ç•ª ; â– ascii ã‚³ãƒ¼ãƒ‰å¤‰æ› ãƒ»ascii() é–¢æ•°ã¯ã€æ–‡å—ã«è©²å½“ã™ã‚‹ ASCII ã‚³ãƒ¼ãƒ‰ã‚’è¿”ã™ã€‚ ã“ã®ä¾‹ã§ã¯ã€ã€Œ49ã€ã¨è¨€ã†æ•°å—ãŒ
rekramkoob 2009/02/26
*programming

db

sql
ãƒªãƒ³ã‚¯
ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸
SQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œè¨€èªžSQLã«ã¤ã„ã¦ã€ã¾ãŸRDBMSã®æŒã¤æ©Ÿèƒ½ã«ã¤ã„ã¦è©³ã—ãè§£èª¬ã—ã¾ã™ã€‚ DBæ¦‚è¦ã€SQLã€ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œã€ãƒ‡ãƒ¼ã‚¿æ“ä½œ ... ç‰¹é›†ï¼šreplication PostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã‚’ç´¹ä»‹ã—ã€ãã‚Œã‚‰ã®æ©Ÿèƒ½ã‚’æ¯”è¼ƒã—ã¦ã„ãã¾ã™ã€‚ ç‰¹é›†ï¼špgbench PostgreSQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã«ç”¨ã„ã‚‰ã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã‚‹ pgbench ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLæ¼”ç¿’å•é¡Œ å„ç« ã«ç”¨æ„ã•ã‚ŒãŸæ¼”ç¿’å•é¡Œã‚’é›†ã‚ã¾ã—ãŸã€‚
rekramkoob 2009/02/19
*programming

sql
ãƒªãƒ³ã‚¯
SQLite - Wikipedia
SQLiteï¼ˆã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ãƒ©ã‚¤ãƒˆ[2][3]ã€ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ©ã‚¤ãƒˆ[4][5]ã€ãªãŠã€ä½œè€…ã®Hippã¯ã‚¨ã‚¹ã‚ãƒ¥ãƒ¼ã‚¨ãƒ«ã‚¢ã‚¤ãƒˆ(/ËŒÉ›sËŒkjuËËŒÉ›lËˆaÉªt/[6][7][8])ã¨ç™ºéŸ³ã—ã¦ã„ã‚‹ï¼‰ã¯ã€ãƒ‘ãƒ–ãƒªãƒƒã‚¯ãƒ‰ãƒ¡ã‚¤ãƒ³ã®è»½é‡ãªé–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ (RDBMS) ã§ã‚ã‚‹ã€‚ ã‚µãƒ¼ãƒã¨ã—ã¦ã§ã¯ãªãã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«çµ„ã¿è¾¼ã‚“ã§åˆ©ç”¨ã•ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹[9]ã€‚ ä¸€èˆ¬çš„ãªRDBMSã¨é•ã„ã€APIã¯å˜ç´”ã«ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’å‘¼ã³å‡ºã™ã ã‘ã§ã‚ã‚Šã€ãƒ‡ãƒ¼ã‚¿ã®ä¿å˜ã«å˜ä¸€ã®ãƒ•ã‚¡ã‚¤ãƒ«ã®ã¿ã‚’ä½¿ç”¨ã™ã‚‹ã“ã¨ãŒç‰¹å¾´ã§ã‚ã‚‹ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³3.3.8ã‹ã‚‰ã¯å…¨æ–‡æ¤œç´¢ã®FTS1ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒã‚µãƒãƒ¼ãƒˆã•ã‚ŒãŸã€‚ãã®å¾Œ FTS2 - FTS3 ã¨å¼·åŒ–ã‚’ç¶šã‘ãƒãƒ¼ã‚¸ãƒ§ãƒ³3.7.4ã‹ã‚‰ã¯FTS4ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã„ã‚‹ã€‚ SQL92ã®æ©Ÿèƒ½ã®å¤šãã‚’å®Ÿè£… è‘—ä½œæ¨©ã‚’æ”¾æ£„ã—ãƒ‘ãƒ–ãƒªãƒƒã‚¯ãƒ‰ãƒ¡ã‚¤ãƒ³ã«å¸°ã—ã¦ã„ã‚‹ ã‚µãƒ¼ãƒã§ã¯ãªããƒ©ã‚¤ãƒ–ãƒ©ãƒª ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯æ•°ç™¾KB
rekramkoob 2009/02/06
*wikipedia

sql

db
ãƒªãƒ³ã‚¯
Service unavailable
Our services aren't available right now We're working to restore all services as soon as possible. Please check back soon.
rekramkoob 2009/01/21
*software

microsoft

windows

db

sql
ãƒªãƒ³ã‚¯
å¤§é‡ä»¶æ•°ã®INSERT or UPDATE ã‚’ç¹°ã‚Šè¿”ã™ãƒãƒƒãƒã§ã®æ³¨æ„ç‚¹
ï¼‘ï¼Žå‡¦ç†é€Ÿåº¦ å˜ç´”ã«INSERTã§æ¸ˆã‚€å ´åˆã¯COPYæ–‡ã‚„psqlã«ã‚ˆã‚‹æ‰‹ç¶šããŒä¾¿åˆ©ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ã€‚ UPDATEã¨INSERTãŒã©ã¡ã‚‰ã‚‚å«ã¾ã‚Œã‚‹å ´åˆã€æœ€åˆã«INSERTã¨UPDATEã®äºŒã¤ã«åˆ†ã‘ã¦ã—ã¾ã£ãŸæ–¹ãŒæ—©ã„ã‹ã‚‚çŸ¥ã‚Œã¾ã›ã‚“ã€‚ SELECT primary_column FROM table_name WHERE primary_column IN (ãƒ—ãƒ©ã‚¤ãƒžãƒªãƒ¼ã‚ãƒ¼ã®é…åˆ—ï¼“ä¸‡å‰å¾Œï¼‰; ã¨ã‹ã§ã€‚ PRIMARYã‚ãƒ¼ãŒ40ãƒã‚¤ãƒˆã ã£ãŸã¨ã—ã¦ã‚‚ã€1MBç¨‹åº¦ã®ãƒ¡ãƒ¢ãƒªé‡ã§æ¸ˆã¿ãã†ã§ã™ã€‚ ï¼’ï¼Žãƒ¡ãƒ¢ãƒªä½¿ç”¨æ–™ã«ã¤ã„ã¦ ï¼“ä¸‡ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã¯ãƒ•ã‚¡ã‚¤ãƒ«ã«å…¥ã£ã¦ã„ã‚‹ã¨æ€ã†ã®ã§ã€å˜ç´”ã«fopen+fgetsã«ã—ã¦ã‚„ã‚Œã°ãã‚Œã»ã©ãƒ¡ãƒ¢ãƒªã¯ä½¿ã‚ãªã„ã‚“ã˜ã‚ƒãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ memory_get_usage()é–¢æ•°ã‚’ä½¿ãˆã‚Œã°ã€å®Ÿéš›ã«ãƒ¡ãƒ¢ãƒªé‡ã‚’è¦‹ã¦ã‚„ã‚‹ã¨è‰¯ã„æ°—ãŒã—ã¾ã™ã€‚ ãƒ¡ãƒ¢ãƒªã‚„PHPã®å‡¦ç†ã‚ˆã‚Šã‚‚ã€Postgreå´ã‚„CPUã€
rekramkoob 2008/05/26
*programming

php

postgresql

sql

hatena

search
ãƒªãƒ³ã‚¯
Belajar Pemrograman Komputer dengan Yang Terbaik
rekramkoob 2008/05/22
*programming

postgresql

sql
ãƒªãƒ³ã‚¯
Oracle ã® MERGE ã«ç›¸å½“ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚’ PostgreSQL ã§è¡Œã†ã«ã¯ï¼Ÿ
Oracle ã® MERGE ã«ç›¸å½“ã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚’ PostgreSQL ã§è¡Œã†ã«ã¯ï¼Ÿ
rekramkoob 2008/05/22
*hatena

search

postgresql

sql
ãƒªãƒ³ã‚¯
SQL æ•°å€¤é–¢æ•° - ä½™ã‚Šã€å››æ¨äº”å…¥ã€åˆ‡ã‚Šæ¨ã¦ã€åˆ‡ã‚Šä¸Šã’ã€æ•°å€¤ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆä»– - SAK Streets
SQL æ•°å€¤é–¢æ•° - ä½™ã‚Šã€å››æ¨äº”å…¥ã€åˆ‡ã‚Šæ¨ã¦ã€åˆ‡ã‚Šä¸Šã’ã€æ•°å€¤ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆä»– åŸºæœ¬çš„ã« Oracleã€SQL-Serverã€MDB ã§å…±é€šã§ã™ã€‚ â– ãƒ“ãƒƒãƒˆè«–ç†ç© (Oracle8i ä»¥é™) ãƒ»bitand() é–¢æ•°ã¯ã€ãƒ“ãƒƒãƒˆè«–ç†ç©ã‚’è¿”ã™ã€‚ ãƒ“ãƒƒãƒˆãƒžã‚¹ã‚¯ã«ä½¿ç”¨ã§ãã‚‹ã®ã§ä¾¿åˆ©ã§ã‚ã‚‹ã€‚ select bitand(255, 4) from dual; select decode(bitand(255, 4), 1, '1', 'not 1') from dual; â– çµ¶å¯¾å€¤ ãƒ»abs() é–¢æ•°ã¯ã€çµ¶å¯¾å€¤ã‚’è¿”ã™ã€‚ ã“ã®ä¾‹ã§ã¯ã€å—æ³¨æ•°ã«ãƒžã‚¤ãƒŠã‚¹ãŒã‚ã£ã¦ã‚‚æ£æ•°ã¨ã—ã¦å•ã„åˆã‚ã•ã‚Œã‚‹ã€‚ select å“ç•ª, abs(å—æ³¨æ•°) from sak.å—æ³¨m order by å“ç•ª ; â– ä½™ã‚Š ãƒ»mod() é–¢æ•°ã¯ã€ä½™ã‚Šã‚’è¿”ã™ã€‚ ã“ã®ä¾‹ã§ã¯ã€å—æ³¨æ•°ã‚’ 1000 ã§å‰²ã£ãŸã‚ã¾ã‚ŠãŒå•ã„åˆã‚ã•ã‚Œã‚‹ã€‚ select å“ç•ª
rekramkoob 2008/05/20
*tips

sql

db
ãƒªãƒ³ã‚¯
0ã®é™¤ç®— - OKWAVE
PostgreSQLã®SQLæ–‡ã§0ã®å‰²ã‚Šç®—ã ã¨è¨ˆç®—ã‚’ã—ãªã„ã§ï¼Œ 0ã‚„Nullã‚’è¿”ã™ã‚ˆã†ãªSQLæ–‡ã‚’ä½œã‚ŠãŸã„ã®ã§ã™ãŒï¼Œ åˆ†ã‹ã‚Šã¾ã™ã‹ï¼Ÿ ä¾‹ãˆã° select field0, ( field1 / field2 ) as result; ã ã¨ã€Œfield2ã€ãŒ0ã®å ´åˆã‚¨ãƒ©ãƒ¼ãŒã§ã¦ã—ã¾ã„ã¾ã™ã€‚ field0ã¯å‡ºåŠ›ã—ãŸã„ã®ã§Whereæ–‡ã§ Where field2 <> 0 ã¯ä½¿ãˆã¾ã›ã‚“ã€‚ ã‚ªãƒ©ã‚¯ãƒ«ã§ã¯decodeã¨ã„ã†é–¢æ•°ãŒä½¿ãˆã‚‹ã‚ˆã†ã§ã™ãŒã€‚
rekramkoob 2008/05/20
*programming

sql

postgresql

db
ãƒªãƒ³ã‚¯
IPAã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒæ¤œçŸ¥ãƒ„ãƒ¼ãƒ«ã‚’ç„¡å„Ÿå…¬é–‹
ç‹¬ç«‹è¡Œæ”¿æ³•äººæƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼ˆIPAï¼‰ã¯4æœˆ18æ—¥ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã®ç—•è·¡ã‚’æ¤œå‡ºã™ã‚‹ãƒ„ãƒ¼ãƒ«ã€ŒiLogScannerã€ã‚’æä¾›ã™ã‚‹ã¨ç™ºè¡¨ã—ãŸã€‚ã“ã‚Œã‚’åˆ©ç”¨ã™ã‚‹ã¨ã€Webã‚µãƒ¼ãƒãƒ¼ã®ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ã®ä¸ã‹ã‚‰Webã‚µã‚¤ãƒˆã¸ã®æ”»æ’ƒã‚’è§£æžã—ã¦ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã‚’å—ã‘ãŸç—•è·¡ã‚’æ¤œå‡ºã§ãã‚‹ã¨ã„ã†ã€‚ã“ã®ãƒ„ãƒ¼ãƒ«ã¯ã€åŒå›£ä½“ã®Webã‚µã‚¤ãƒˆã‹ã‚‰ç„¡å„Ÿã§ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã‚‹ã€‚ ã“ã®ãƒ„ãƒ¼ãƒ«ã¯Javaã‚¢ãƒ—ãƒ¬ãƒƒãƒˆå½¢å¼ã§ã€Webãƒ–ãƒ©ã‚¦ã‚¶ã‹ã‚‰åˆ©ç”¨å¯èƒ½ã€‚åˆ©ç”¨è€…ãŒç”¨æ„ã—ãŸWebã‚µãƒ¼ãƒãƒ¼ã®ã‚¢ã‚¯ã‚»ã‚¹ãƒã‚°ã‚’è§£æžã—ã¦ã€Webã‚µã‚¤ãƒˆã®æ”»æ’ƒã«ã‚ˆãç”¨ã„ã‚‰ã‚Œã‚‹æ–‡å—åˆ—ã‚’æŠ½å‡ºã—ã€ãã®Webã‚µã‚¤ãƒˆãŒã©ã‚Œã ã‘ã®æ”»æ’ƒã‚’å—ã‘ã¦ã„ã‚‹ã‹ã‚’åˆ†æžã§ãã‚‹ã€‚ã•ã‚‰ã«ã€è„†å¼±æ€§ã‚’çªã‹ã‚Œã¦æ”»æ’ƒãŒæˆåŠŸã—ãŸå¯èƒ½æ€§ãŒã‚ã‚‹ã‹ã€ã¨ã„ã†ç‚¹ã«ã¤ã„ã¦ã‚‚æ¤œå‡ºå¯èƒ½ã¨ã„ã†ã€‚ æ¤œçŸ¥ã‚’è¡Œãˆã‚‹ã®ã¯ç¾åœ¨SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®ã¿ã§ã‚ã‚‹ã‚‚ã®ã®ã€ä»Šå¾Œã¯ã‚¯ãƒã‚¹ã‚µã‚¤ãƒˆã‚¹ã‚¯ãƒªãƒ—ãƒ†ã‚£ãƒ³ã‚°ï¼ˆXSSï¼‰ã‚„ã€OSã‚³ãƒžãƒ³ãƒ‰
rekramkoob 2008/04/22
sql

db

security

*software
ãƒªãƒ³ã‚¯
æ”¾ç½®ã•ã‚Œã‚‹ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã®è„†å¼±æ€§ã€100ä»¶ä»¥ä¸ŠãŒæœªå¯¾ç–
æƒ…å ±å‡¦ç†æŽ¨é€²æ©Ÿæ§‹ï¼ˆIPAï¼‰ã¨JPCERTã‚³ãƒ¼ãƒ‡ã‚£ãƒãƒ¼ã‚·ãƒ§ãƒ³ã‚»ãƒ³ã‚¿ãƒ¼ï¼ˆJPCERT/CCï¼‰ã¯2008å¹´4æœˆ16æ—¥ã€2008å¹´ç¬¬1å››åŠæœŸï¼ˆ2008å¹´1æœˆã‹ã‚‰åŒ3æœˆï¼‰ã«ãŠã‘ã‚‹ã€ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã¨Webã‚µã‚¤ãƒˆã®è„†å¼±ï¼ˆãœã„ã˜ã‚ƒãï¼‰æ€§ã«é–¢ã™ã‚‹å±Šã‘å‡ºçŠ¶æ³ã‚’å…¬è¡¨ã—ãŸã€‚ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã¨Webã‚µã‚¤ãƒˆã«é–¢ã™ã‚‹å±Šã‘å‡ºã¯ã€ãã‚Œãžã‚Œ53ä»¶ã¨244ä»¶ã€‚è„†å¼±æ€§ã®å ±å‘Šã‚’å—ã‘ã¦ã„ãªãŒã‚‰ã€90æ—¥ä»¥ä¸Šæœªä¿®æ£ã®Webã‚µã‚¤ãƒˆã¯108ä»¶ã€‚ã“ã‚Œã‚‰ã®ã‚µã‚¤ãƒˆã§ã¯ã€ã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã€ã‚„ã€Œã‚¯ãƒã‚¹ã‚µã‚¤ãƒˆã‚¹ã‚¯ãƒªãƒ—ãƒ†ã‚£ãƒ³ã‚°ã€ãªã©ã®æ”»æ’ƒã‚’å—ã‘ã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ IPAã¨JPCERT/CCã¯2004å¹´7æœˆä»¥é™ã€çµŒæ¸ˆç”£æ¥çœå‘Šç¤ºã«åŸºã¥ã„ã¦ã€ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã‚„Webã‚µã‚¤ãƒˆã«é–¢ã™ã‚‹è„†å¼±æ€§æƒ…å ±ã‚’ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰å—ã‘ä»˜ã‘ã€ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã®é–‹ç™ºè€…ã‚„Webã‚µã‚¤ãƒˆã®é‹å–¶è€…ãªã©ã«å ±å‘Šã—ã€ä¿®æ£ã®ãŸã‚ã«å¿…è¦ãªèª¿æ•´ã‚’è¡Œã£ã¦ã„ã‚‹ã€‚åŠ ãˆã¦å››åŠæœŸã”ã¨ã«ã¯ã€å±Šã‘å‡ºçŠ¶æ³ã‚„å–ã‚Šæ‰±ã„çŠ¶æ³ã‚’é›†è¨ˆã—ã¦å…¬è¡¨ã—
rekramkoob 2008/04/17
sql

*security
ãƒªãƒ³ã‚¯
SQLè¬›åº§ INNER JOINã‚’ä½¿ã£ãŸè¡¨ã®çµåˆ
ã€Œ1æ—¥1å•ã€ä»•äº‹ã‚„å‹‰å¼·ã«å½¹ç«‹ã¤ITçŸ¥è˜ã‚’å……é›»ï¼ ãƒªã‚¯ãƒ«ãƒ¼ãƒˆãŒé‹å–¶ã™ã‚‹ã€ŒITã‚ãƒ£ãƒ‘ãƒãƒ£ãƒ¼ã‚¸ã€ã¯ã€æœ€åˆã«ä¼šå“¡ç™»éŒ²ãŒå¿…è¦ã§ã™ãŒã€ç„¡æ–™ã§ä»•äº‹ã‹ã‚‰æƒ…å ±å‡¦ç†æŠ€è¡“è€…è©¦é¨“ã¾ã§å¹…åºƒãæ´»ç”¨ã§ãã‚‹Webã‚µã‚¤ãƒˆã§ã™ã€‚ITæ‹…å½“è€…ã®ã‚¹ã‚ãƒ«ã‚¢ãƒƒãƒ—ã«å½¹ç«‹ã¤æƒ…å ±å‡¦ç†ã«é–¢ã™ã‚‹å•é¡Œã‚’ã€æ¯Žæ—¥ï¼‘å•ãšã¤ã€ãƒ¡ãƒ¼ãƒ«ã‚„ã‚µã‚¤ãƒˆä¸Šã§æä¾›ã™ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚è§£ç”ãƒšãƒ¼ã‚¸ã¯ITåˆå¿ƒè€…ã§ã‚‚åˆ†ã‹ã‚‹ä¸å¯§ãªè§£èª¬ã¤ãã§ã€ã‚µã‚¤ãƒˆä¸Šã§ã¯éŽåŽ»ã®å•é¡Œã«ã‚‚æŒ‘æˆ¦ã§ãã¾ã™ã€‚ ã¾ãŸã€ITç”¨èªžãŒèª¿ã¹ã‚‰ã‚Œã‚‹ITå˜èªžå¸³ã¯ã€èª¬æ˜Žã‚‚è©³ã—ãç°¡å˜ã«èª¿ã¹ã‚‰ã‚Œã€ãŸã„ã¸ã‚“ä¾¿åˆ©ã§ã™ã€‚ãœã²ã€ä¼šå“¡ç™»éŒ²ã—ã¦æ´»ç”¨ã—ãŸã„ã‚µã‚¤ãƒˆã§ã™ã€‚ INNER JOINã‚’ä½¿ã£ã¦è¡¨ã‚’çµåˆã™ã‚‹ SELECTæ–‡ã«ãŠã„ã¦è¤‡æ•°ã®è¡¨ã‚’çµåˆã™ã‚‹ã¨ãã¯WHEREå¥ã§çµåˆæ¡ä»¶ã‚’æŒ‡å®šã™ã‚‹ã»ã‹ã«FROMå¥ã§INNER JOINã‚’æŒ‡å®šã—ã¦è¡¨ã‚’çµåˆã™ã‚‹ã“ã¨ã‚‚ã§ãã‚‹ã€‚ INNER JOINã®è¨˜è¿°å½¢å¼ SELECT åˆ—å1,åˆ—å2,ï½žåˆ—ån â† ã©ã®åˆ—
rekramkoob 2008/04/10
db

sql

*programming
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å…¥é–€ A è³‡æ–™ 7 æ¼”ç®—åãƒ»é–¢æ•°ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚°ãƒ«ãƒ¼ãƒ—åŒ–
rekramkoob 2008/04/10
db

sql

*programming
ãƒªãƒ³ã‚¯
SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžè³‡æ–™ - SAK Streets
SQL é–‹ç™ºè¨€èªžè³‡æ–™ SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžè³‡æ–™ SQL åŸºç¤Žç·¨ SQL åŸºç¤Žå®Ÿåœ°ç·¨ SQL ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ç·¨ Oracle PL/SQL ç·¨ PostgreSQL ç·¨ã€JAVA Servletã€JSP ç·¨ MySQL ç·¨ SQL ãã®ä»–å¿œç”¨ç·¨ VB ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžè³‡æ–™ VB RDO + SQL å¿œç”¨ç·¨ VB ADO + SQL å¿œç”¨ç·¨ VB oo4o + SQL å¿œç”¨ç·¨ ASP VB Script ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžè³‡æ–™ ASP VB Script ADO + SQL å¿œç”¨ç·¨ ASP VB Script oo4o + SQL å¿œç”¨ç·¨ SQL åŸºç¤Žç·¨ 2000.10.14 SQL åŸºç¤Žç·¨ (ãã®ä¸€) ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œ create tableã€alter tableã€drop table SQL åŸºç¤Žç·¨ - ã€è£œè¶³ã€‘è¤‡åˆã‚ãƒ¼ alter tableã€primary key 2000.10
rekramkoob 2008/03/20
sql
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŸºæœ¬ã¨SQL*PLUS
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®åŸºæœ¬ã¨SQL*PLUSï¼šé–“é•ã„ã‚„ã™ã„ãƒã‚¤ãƒ³ãƒˆã‚’è¿½ãˆï¼ Bronze SQLåŸºç¤ŽIï¼ˆ1ï¼‰ï¼ˆ1/2 ãƒšãƒ¼ã‚¸ï¼‰ Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ã®åŸºç¤ŽåŠ›ã‚’è¨¼æ˜Žã™ã‚‹ORACLE MASTER Bronzeã®å–å¾—ã‚’ç›®æŒ‡ã™IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯å¤šã„ã€‚æœ¬é€£è¼‰ã§é–“é•ã„ã‚„ã™ã„ãƒã‚¤ãƒ³ãƒˆã‚’ç¢ºèªã—ã€åˆæ ¼ã«è¿‘ã¥ã“ã†ï¼
rekramkoob 2008/03/16
sql

db
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã®æ³¢ãŒå†æ¥ â€• ï¼ IT
2008/03/12 ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ä¼æ¥ã®ãƒ©ãƒƒã‚¯ã¯3æœˆ12æ—¥ã€æ—¥æœ¬ã‚’ã‚¿ãƒ¼ã‚²ãƒƒãƒˆã¨ã—ãŸSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒãŒæ€¥å¢—ã—ã¦ã„ã‚‹ã¨ã—ã€æ³¨æ„ã‚’å–šèµ·ã—ãŸã€‚ä¼æ¥ã‚„çµ„ç¹”ãªã©ãŒå…¬é–‹ã—ã¦ã„ã‚‹æ£è¦ã®ãƒšãƒ¼ã‚¸ãŒæ”¹ã–ã‚“ã•ã‚Œã¦æ‚ªæ„ã‚ã‚‹Webã‚µã‚¤ãƒˆã¸ã®ãƒªãƒ³ã‚¯ãŒåŸ‹ã‚è¾¼ã¾ã‚Œã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒãƒžãƒ«ã‚¦ã‚§ã‚¢æ„ŸæŸ“ãªã©ã®è¢«å®³ã‚’è¢«ã‚‹æã‚ŒãŒã‚ã‚‹ã€‚ åŒç¤¾ã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç›£è¦–ã‚»ãƒ³ã‚¿ãƒ¼ã€JSOCï¼ˆJapan Security Operation Centerï¼‰ã«ã‚ˆã‚‹ã¨ã€ä¸€é€£ã®æ”»æ’ƒã¯3æœˆ11æ—¥ã®å¤œã‹ã‚‰12æ—¥ã«ã‹ã‘ã¦ç¶™ç¶šã—ã¦ãŠã‚Šã€é€šå¸¸ã®70ï½ž100å€ã®ä»¶æ•°ã«ä¸Šã£ã¦ã„ã‚‹ã€‚æ”»æ’ƒã®çµæžœæ”¹ã–ã‚“ã•ã‚ŒãŸãƒšãƒ¼ã‚¸ã‚‚ã€æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ãªã©ã§ç¢ºèªã§ãã‚‹ç¯„å›²ã ã‘ã§ã‚‚1ä¸‡3000ãƒšãƒ¼ã‚¸ä»¥ä¸Šã«é”ã™ã‚‹ãªã©ã€å¤§è¦æ¨¡ãªæ”»æ’ƒã«ç™ºå±•ã—ã¦ã„ã‚‹ã¨ã„ã†ã€‚ã“ã®ã“ã¨ã‚’è¸ã¾ãˆã‚‹ã¨ã€ä½•ã‚‰ã‹ã®è‡ªå‹•åŒ–ãƒ„ãƒ¼ãƒ«ã€ã‚ã‚‹ã„ã¯ãƒœãƒƒãƒˆã«ã‚ˆã‚‹æ”»æ’ƒãŒè¡Œã‚ã‚Œã¦ã„ã‚‹å¯èƒ½æ€§ã¯å¦å®šã§ããªã„ã€‚ ã“ã®æ”»æ’ƒã¯ã€Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å˜åœ¨ã™
rekramkoob 2008/03/13
sql

*security
ãƒªãƒ³ã‚¯
æ¼”ç®—å - 2éƒ¨ Perlè¨€èªžä»•æ§˜ - [SMART]
1.æ¼”ç®—åã®æ¦‚è¦ æ¼”ç®—åã¯ã€ç®—è¡“æ¼”ç®—åã«ä»£è¡¨ã•ã‚Œã‚‹ã‚ˆã†ã«ã€å¤‰æ•°ã‚„ãƒªãƒ†ãƒ©ãƒ«ãªã©ã®å€¤ã«å¯¾ã—ã¦æ¼”ç®—ã‚’è¡Œã†ãŸã‚ã®è¨˜å·ã§ã™ã€‚ æ¼”ç®—åã®ä¸ã§ã‚‚æœ‰åãªã®ãŒã€åŠ ç®—æ¼”ç®—åã‚„æ¸›ç®—æ¼”ç®—åãªã©ã®ç®—è¡“æ¼”ç®—åã§ã™ã€‚ Perl ã®çµ„ã¿è¾¼ã¿æ¼”ç®—åã¯ã€æ¼”ç®—ã®å¯¾è±¡ã¨ãªã‚‹å€¤ã€ã€Žã‚ªãƒšãƒ©ãƒ³ãƒ‰ã€ã®å€‹æ•°ã«ã‚ˆã£ã¦å˜æ•°æ¼”ç®—åã€äºŒé …æ¼”ç®—åã€ä¸‰é …æ¼”ç®—åã«åˆ†é¡žã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã¾ãŸã€é–“å€¤æ¼”ç®—åã‹å‰ç½®æ¼”ç®—åã‹ã€æ•°å€¤ã€æ–‡å—åˆ—ã€ãƒ•ã‚¡ã‚¤ãƒ«ãªã©æœæŸ»å¯¾è±¡ã«ã‚ˆã£ã¦ã‚‚åˆ†é¡žã§ãã¾ã™ã€‚ãŸã ã—ã€ã“ã‚Œã‚‰ã®åˆ†é¡žã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã™ã‚‹ä¸Šã§ã‚ã¾ã‚Šé‡è¦ã§ã¯ãªãã€ä¸€ã¤ä¸€ã¤ã®æ¼”ç®—åã‚’ç†è§£ã™ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ ç”¨èªž ã‚ªãƒšãƒ©ãƒ³ãƒ‰ æ¼”ç®—ã®å¯¾è±¡ã¨ãªã‚‹å€¤ã€‚æ¼”ç®—å†…å®¹ã‚’ã‚ã‚‰ã‚ã™è¨˜å·ã¯æ¼”ç®—åã¨å‘¼ã³ã¾ã™ã€‚ä¾‹ãˆã° 10+X ã¨ã„ã†å¼ã§ã¯ã€10 ã¨ X ãŒã‚ªãƒšãƒ©ãƒ³ãƒ‰ã§ã€+ ãŒã‚ªãƒšãƒ¬ãƒ¼ã‚¿ã§ã™ã€‚ æ¼”ç®—åã®å„ªå…ˆé †ä½ æ¼”ç®—åã«ã¯çµåˆæ€§ã¨å„ªå…ˆé †ä½ãŒã‚ã‚Šã¾ã™ã€‚ æ¼”ç®—åã®ä¸€è¦§ æ¼”ç®—å çµåˆæ€§ è§£èª¬
rekramkoob 2008/03/08
sql
ãƒªãƒ³ã‚¯
ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã¨ã¯ SQL -TECHSCORE-
SQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹æ“ä½œè¨€èªžSQLã«ã¤ã„ã¦ã€ã¾ãŸRDBMSã®æŒã¤æ©Ÿèƒ½ã«ã¤ã„ã¦è©³ã—ãè§£èª¬ã—ã¾ã™ã€‚ DBæ¦‚è¦ã€SQLã€ãƒ†ãƒ¼ãƒ–ãƒ«æ“ä½œã€ãƒ‡ãƒ¼ã‚¿æ“ä½œ ... ç‰¹é›†ï¼šreplication PostgreSQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚·ã‚¹ãƒ†ãƒ ã‚’ç´¹ä»‹ã—ã€ãã‚Œã‚‰ã®æ©Ÿèƒ½ã‚’æ¯”è¼ƒã—ã¦ã„ãã¾ã™ã€‚ ç‰¹é›†ï¼špgbench PostgreSQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ†ã‚¹ãƒˆã«ç”¨ã„ã‚‰ã‚Œã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã‚‹ pgbench ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ SQLæ¼”ç¿’å•é¡Œ å„ç« ã«ç”¨æ„ã•ã‚ŒãŸæ¼”ç¿’å•é¡Œã‚’é›†ã‚ã¾ã—ãŸã€‚
rekramkoob 2008/03/08
postgresql

sql
ãƒªãƒ³ã‚¯
éšœå®³å¯¾å¿œã¨ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®å±ã†ã„é–¢ä¿‚
é–‹ç™ºç¾å ´ã¯æ—¥ã€…ã®ä»•äº‹ã®å ´ã§ã‚ã‚‹ã¨ã¨ã‚‚ã«ã€å¦ã³ã®å ´ã§ã‚‚ã‚ã‚‹ã€‚å…ˆè¼©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒéŽåŽ»ã«ç›´é¢ã—ãŸå›°é›£ã®æ•°ã€…ã€ãã“ã‹ã‚‰å¦ã‚“ã ã‚¹ã‚ãƒ«ã‚„è€ƒãˆæ–¹ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒãƒ¼ãƒ ã®ãƒªãƒ¼ãƒ€ãƒ¼ã« å‰å›žã€Œã‚ªãƒ•ã‚·ãƒ§ã‚¢ãªã‚“ã¦ã€æ€–ããªã„ã€ã§ã¯ã€ã‚ªãƒ•ã‚·ãƒ§ã‚¢ã§ã®é–‹ç™ºã‚’å«ã‚€å¤§è¦æ¨¡åŸºå¹¹ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®çµŒé¨“ã‚’åŸºã«ã€ç§ãŒã‚ªãƒ•ã‚·ãƒ§ã‚¢é–‹ç™ºã«æ€ã†ã“ã¨ã‚’ãŠè©±ã—ã—ã¾ã—ãŸã€‚ä»Šå›žã¯ãã®ç¶šãã§ã€åŒã˜ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã§ã™ã€‚ ã‚ªãƒ•ã‚·ãƒ§ã‚¢ã§ã®é–‹ç™ºãƒ»çµåˆãƒ†ã‚¹ãƒˆã‚‚çµ‚äº†ã—ã€ã‚·ã‚¹ãƒ†ãƒ ãƒ†ã‚¹ãƒˆãŒé–‹å§‹ã•ã‚Œã¾ã—ãŸã€‚ç§»è¡Œã®ãƒªãƒãƒ¼ã‚µãƒ«ã‚‚ç„¡äº‹å®Œäº†ã—ã€æ•°ç™¾ä¸‡ä»¶ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒæŠ•å…¥ã•ã‚Œã¾ã—ãŸâ€¦â€¦ã€‚ã¨ã€ã“ã“ã¾ã§ã¯é †èª¿ã«è¦‹ãˆã¾ã—ãŸãŒã€ç§»è¡Œãƒ‡ãƒ¼ã‚¿ã§ã®ãƒ†ã‚¹ãƒˆã‚’é–‹å§‹ã—ã¦ã™ãã«ã€æ€§èƒ½ã«é–¢ã™ã‚‹å•é¡ŒãŒè¡¨é¢åŒ–ã—ã¾ã—ãŸã€‚ æ•°ç™¾ä»¶ã€æ•°åƒä»¶ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã§ã¯å•é¡Œãªãå‹•ã„ã¦ã„ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒã€ãƒœã‚¿ãƒ³ã‚’æŠ¼ã—ã¦ã‚‚æ•°åˆ†é–“å¿œç”ã—ãªããªã£ãŸã‚Š
rekramkoob 2008/03/05
sql

development
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 æ¬¡ã®ãƒšãƒ¼ã‚¸