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

sylph01 id:sylph01

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

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

Hughes Technologies : The home of mSQL and Network Knowledge
mSQL - The Original Freely Available SQL Implementation Mini SQL (mSQL) is our light-weight SQL Database engine techno logy. First released in 1994, our database techno logy has been incorporated into products from companies such as HP, Cisco, Tandem, Cray, EDS, TRW, General Electric, and Real Networks. The release of mSQL 4 marks the fourth generation of the software. While mSQL is now a very matur
sylph01 2017/08/01
sql
ãƒªãƒ³ã‚¯
Page not found
404 Sorry! that page can not be found... The URL was either incorrect, you took a wrong guess or there is a technical probl em.
sylph01 2015/01/13
sql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
sylph01 2014/11/27
sql

tips

performance
ãƒªãƒ³ã‚¯
SQL Indexing and Tuning e-Book for developers: Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ...
A site explaining SQL indexing to developersâ€”no crap about administration. SQL indexing is the most effective tuning methodâ€”yet it is often neglected during development. Use The Index, Luke explains SQL indexing from grounds up and doesnâ€™t stop at ORM tools like Hibernate. Use The Index, Luke is the free web-edition of my book SQL Performance Explained (from Ð„9.95). Be sure to subscribe my free ne
sylph01 2014/09/15
sql
ãƒªãƒ³ã‚¯
MySQLã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°
æ£®å·ã§ã™ã€‚ å‰å›žã¯ãƒžãƒ«ãƒãƒã‚¤ãƒˆé–¢é€£ã§ã—ãŸãŒã€ä»Šå›žã‚‚ãƒžãƒ«ãƒãƒã‚¤ãƒˆã§ã™ã€‚å‰å›žã‚½ãƒ¼ã‚¹ã‚’è§£æžã™ã‚‹ãªã©ã¨è¨€ã£ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€ä¸ã€…é›£ã—ãã¾ã é€”ä¸ã§ã™ã€‚æ±ºã—ã¦ã‚ãã‚‰ã‚ãŸã‚ã‘ã§ã¯ãªã„ã®ã§ã€ã‚‚ã†å°‘ã—ã™ã‚Œã°ã“ã“ã«æ›¸ã‘ã‚‹ã‚ˆã†ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ ã•ã¦ã€ä»Šå›žã¯MySQLã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã«ã¤ã„ã¦ã§ã™ã€‚4.1ã‹ã‚‰æ–‡å—ã‚³ãƒ¼ãƒ‰ã®è¨å®šãŒè‰²ã€…ã¨å¢—ãˆãŸã®ã§ã€è¨å®šã‚’ãã¡ã‚“ã¨ã—ã¦ã„ãªãã¦å•é¡ŒãŒèµ·ãã‚‹ã“ã¨ã‚‚å¤šã‹ã£ãŸã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ã¾ãšã¯ç°¡å˜ã«ãŠã•ã‚‰ã„ã§ã™ã€‚ CentOS4.4ã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ mysql>Â showÂ variablesÂ likeÂ 'character%'; +--------------------------+----------------------------+ |Â Variable_nameÂ Â Â Â Â Â Â Â Â Â Â Â |Â ValueÂ Â Â Â Â Â Â Â
sylph01 2011/06/22
php

sql
ãƒªãƒ³ã‚¯
Javaã¨MySQLã®çµ„ã¿åˆã‚ã›ã§Unicodeã®U+00A5ã‚’ç”¨ã„ãŸSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®å¯èƒ½æ€§
è£œè¶³ ã“ã®è¨˜äº‹ã¯æ—§å¾³ä¸¸æµ©ã®æ—¥è¨˜ã‹ã‚‰ã®è»¢è¼‰ã§ã™ï¼ˆå…ƒURLã€ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯1ã€ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯2ï¼‰ã€‚ å‚™å¿˜ã®ãŸã‚è»¢è¼‰ã„ãŸã—ã¾ã™ãŒã€ã“ã®è¨˜äº‹ã¯2008å¹´12æœˆ22æ—¥ã«å…¬é–‹ã•ã‚ŒãŸã‚‚ã®ã§ã€å½“æ™‚ã®å¾³ä¸¸ã®è€ƒãˆã‚’ç¤ºã™ã‚‚ã®ã‚’ã€åŸºæœ¬çš„ã«å†…å®¹ã‚’å¤‰æ›´ã›ãšã«ãã®ã¾ã¾è»¢è¼‰ã™ã‚‹ã‚‚ã®ã§ã™ã€‚ è£œè¶³çµ‚ã‚ã‚Š ä»Šå¹´ã®Black Hat Japanã«ã¯ã€ã¯ã›ãŒã‚ã‚ˆã†ã™ã‘æ°ãŒã€Œè¶£å‘³ã¨å®Ÿç›Šã®æ–‡å—ã‚³ãƒ¼ãƒ‰æ”»æ’ƒã€ã¨é¡Œã—ã¦è¬›æ¼”ã•ã‚Œè©±é¡Œã¨ãªã£ãŸã€‚ãã®è¬›æ¼”è³‡æ–™ãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã®ã§ã€ç§ã¯è¬›æ¼”ã¯èžãé€ƒã—ãŸãŒã€è³‡æ–™ã¯èˆˆå‘³æ·±ãæ‹è¦‹ã—ãŸã€‚ãã®è¬›æ¼”è³‡æ–™ã®P20ä»¥é™ã«ã¯ã€ã€Œå¤šå¯¾ä¸€ã®å¤‰æ›ã€ã¨é¡Œã—ã¦ã€Unicodeã®U+00A5ï¼ˆé€šè²¨è¨˜å·ã¨ã—ã¦ã®ï¿¥ï¼‰ãŒã€ä»–ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã«å¤‰æ›ã•ã‚Œã‚‹éš›ã«ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã€Œ\ã€ï¼ˆæ—¥æœ¬èªžç’°å¢ƒã§ã¯é€šè²¨è¨˜å·ï¼‰ã®0x5Cã«å¤‰æ›ã•ã‚Œã‚‹ã“ã¨ã‹ã‚‰ã€ãƒ‘ã‚¹ãƒˆãƒ©ãƒãƒ¼ã‚µãƒ«ãŒç™ºç”Ÿã™ã‚‹ä¾‹ãŒç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã€‚ ã—ã‹ã—ã€ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã¨è¨€ãˆã°SQL
sylph01 2011/06/22
sql
ãƒªãƒ³ã‚¯
SET NAMESã¯ç¦æ¢
Last Updated on: 2018å¹´8æœˆ13æ—¥MySQLã«ã¯æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å¤‰æ›´ã™ã‚‹ã€ŒSET NAMESã€SQLæ–‡ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ï¼ˆPostgreSQLã‚‚åŒæ§˜ã®SQLæ–‡ã€SET CLIENT_ENCODINGãŒã‚ã‚Šã¾ã™ï¼‰ã“ã®æ©Ÿèƒ½ã¯SQLã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‹ã‚‰ã¯ä½¿ã£ã¦ã‚ˆã„æ©Ÿèƒ½ã§ã™ãŒã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã¯ä½¿ã£ã¦ã¯ãªã‚‰ãªã„æ©Ÿèƒ½ã§ã™ã€‚SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã«è„†å¼±ã«ãªã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ Ruby on Railsã®æœ¬ã‚’èªã‚“ã§ã„ã¦ã€ActiveRecordã‚’èª¬æ˜Žã—ã¦ã„ã‚‹éƒ¨åˆ†ã«MySQLã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’å¤‰æ›´ã™ã‚‹å ´åˆã®ä¾‹ã¨ã—ã¦SET NAMESãŒåˆ©ç”¨ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰ã¯SET NAMESã¯ä½¿ã£ã¦ã¯ãªã‚‰ãªã„äº‹ã‚’å‘¨çŸ¥ã•ã›ã‚‹ã®ã¯çµæ§‹æ™‚é–“ãŒå¿…è¦ã‹ãªã¨æ€ã„ã¾ã—ãŸã€‚ PHPã‚‚5.2ã®é€”ä¸ã‹ã‚‰MySQLãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«libmysqlã®æ–‡å—ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°è¨å®šAPIã®ãƒ©ãƒƒãƒ‘ãƒ¼é–¢æ•°ãŒè¿½åŠ
sylph01 2011/06/22
sql

security
ãƒªãƒ³ã‚¯
Mac OS X ã§ PostgreSQL ã‚’ä½¿ã£ã¦ã¿ã‚ˆã† | Let's POSTGRES
ç¬¬å››ä¼ç”»Â å‚äº• æ½” ã¯ã˜ã‚ã« ã“ã®è¨˜äº‹ã§ã¯ã€Mac OS X ã®ç¾æ™‚ç‚¹ï¼ˆ2009-05-16ï¼‰ã§ã®æœ€æ–°ç‰ˆã§ã‚ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 10.5.7 (Leopard) ã«ã€ä»Šå›žã¯ EnterpriseDB ç¤¾ãŒæä¾›ã™ã‚‹ã€Œãƒ¯ãƒ³ãƒ»ã‚¯ãƒªãƒƒã‚¯ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã‚’ä½¿ã£ã¦ç°¡å˜ã« PostgreSQL ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã€å‹•ã‹ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ 1. ç”¨æ„ã™ã‚‹ã‚‚ã® 1.1 Mac ç†è€…ãŒä½¿ç”¨ã—ãŸ Macintosh ã¯ã€ä¸€ä¸–ä»£å‰ã® MacBook White ã§ã™ã€‚ ãƒ—ãƒã‚»ãƒƒã‚µ
sylph01 2010/01/28
mac

sql
ãƒªãƒ³ã‚¯
HTMLã®è¦ç´ ã‚’SQLã®ã‚ˆã†ã«å–ã‚Šå‡ºã›ã‚‹PHPã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã€ŽhtmlSQLã€ | IDEA*IDEA
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å¦ç¿’ã‚µãƒ¼ãƒ“ã‚¹ã®é‹å–¶ã€GTDã®ç›£è¨³ã€å°ç²‹ãªiOSã‚¢ãƒ—ãƒªã®é–‹ç™ºã€‚ã¨ãã©ããƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ã€‚æ–‡ç« ã¯AIã§æ›¸ã„ã¦ã¾ã›ã‚“ï¼ˆè©³ã—ã„ãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ«ï¼‰ã€‚
sylph01 2007/11/12
html

php

sql

programming

web
ãƒªãƒ³ã‚¯
SQL Injection Cheat Sheet
Examples; (MS) means : MySQL and SQL Server etc. (M*S) means : Only in some versions of MySQL or special conditions see related note and SQL Server Table Of Contents About SQL Injection Cheat Sheet Syntax Reference, Sample Attacks and Dirty SQL Injection Tricks Line Comments SQL Injection Attack Samples Inline Comments Classical Inline Comment SQL Injection Attack Samples MySQL Vers
sylph01 2007/05/03
hack

security

sql
ãƒªãƒ³ã‚¯
1