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

quodius id:quodius

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

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

H2ã§ãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°/ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’è©¦ã—ã¦ã¿ã‚‹2 - H2Databaseã‚’è¿½ã£ã‹ã‘ã¦ã„ãŸã‚Šã—ãŸãƒ–ãƒã‚°
ãƒ¦ãƒ¼ã‚¶ãƒ¼å®šç¾©é–¢æ•°ã®è¿”ã‚Šã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ä»£ã‚ã‚Šã«ä½¿ã£ã¦ã¿ã¾ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ä»£ã‚ã‚Šã«ä½¿ã†å ´åˆã«ã¯ã€ãƒ¡ã‚½ãƒƒãƒ‰ã¯ResultSetã‚’è¿”ã™ã‚‚ã®ã§ã‚ã‚‹äº‹ãŒå¿…è¦ã§ã™ã€‚ ãã‚Œä»¥å¤–ã€å®Ÿè£…ã§ç‰¹ã«é›£ã—ã„ã¨ã“ã‚ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€ãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°ã‚’ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã—ã¦æ‰±ã†ã¨ãã«ã¯ã€å°‘ãªãã¨ã‚‚2å›žã®ãƒ¡ã‚½ãƒƒãƒ‰ã®å®Ÿè¡ŒãŒç™ºç”Ÿã™ã‚‹ã€ã¨ã„ã†ã“ã¨ã«æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚å…·ä½“çš„ã«ã¯ã€SQLã‚’ãƒ‘ãƒ¼ã‚¹ã—ã¦ã€ã‚«ãƒ©ãƒ æƒ…å ±ã‚’å–å¾—ã™ã‚‹ã¨ãã€ãã‚Œã¨å®Ÿæ–½ã™ã‚‹ã¨ãã§ã™ã€‚ã‚µãƒ³ãƒ—ãƒ«ã«ã‚‚ã‚ã‚‹ã‚ˆã†ã«ã€ã‚«ãƒ©ãƒ æƒ…å ±ã‚’å–å¾—ã™ã‚‹ã¨ãã«ã¯conn.getMetaData().getURL()ã§ã€è¿”ã£ã¦ãã‚‹å€¤ãŒ"jdbc:columnlist:connection"ã«ãªã‚‹ã®ã§ã€ãã‚Œã‚’ç¢ºèªã—ãŸã‚‰ã€ã¨ã‚Šã‚ãˆãšã‚«ãƒ©ãƒ æƒ…å ±ã ã‘ä½œæˆã—ã¦ã€ã•ã£ã•ã¨ResultSetã‚’è¿”ã—ã¦ã—ã¾ã„ã¾ã™ã€‚ package com.karatebancho; import java.sql.Connection; import
quodius 2014/09/26
h2

ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£

java

sql
ãƒªãƒ³ã‚¯
H2:ãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°ã¨ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ä½œæˆæ–¹æ³•
quodius 2014/09/26
h2

procedure

java

sql
ãƒªãƒ³ã‚¯
ORãƒžãƒƒãƒ‘ãƒ¼ãªã‚‰DomaãŒä¸€ç•ªã€‚ - newta(ã«ã‚…ãƒ¼ãŸ)ã®æ—¥è¨˜
ã™ã£ã‹ã‚Šæ˜Žã‘ã¦ã¾ã™ãã€‚ ã¾ã‚ã€å¤ãã‚‰ã„ã‹ã‚‰æ›´æ–°ã—ã¦ãªã„ã§ã™ãŒã€‚ã€‚ ã¨ã‚‚ã‹ãã€ä»Šå¹´ã‚‚ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚ ã§ã€Domaãªã‚“ã§ã™ã‘ã©ã€ å®Ÿè·µæŠ•å…¥ã™ã”ãã—ã¦ã¾ã™ã€‚ã„ã£ã±ã„ä½¿ã£ã¦ã¾ã™ã€‚æ„Ÿè¬ã€‚ ä»Šã®ã¨ã“ã‚ã€ORãƒžãƒƒãƒ‘ãƒ¼ã‚’ä½¿ã†ãªã‚‰DomaãŒä¸€ç•ªã®é¸æŠžè‚¢ã§ã™ã€‚ ç†ç”± å°è±¡ã¯S2Daoã®ã‚ˆã†ã§ã€ S2Daoã‚ˆã‚Šã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹éƒ¨åˆ†ã§ã‹ã‚†ã„ã¨ã“ã‚ã«æ‰‹ãŒå±Šã„ã¦ã‚‹æ„Ÿã˜ã€‚ selectã¯å¤–ã ã—SQLã®ã¿ã«ã™ã‚‹ã“ã¨ã§å®Ÿè¡Œã•ã‚Œã‚‹SQLãŒåˆ†ã‹ã‚Šã‚„ã™ã å®šç¾©ç®‡æ‰€ãŒsqlãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã®ã¿ãªã®ã§ç®¡ç†ã—ã‚„ã™ã„ã€‚ SQLãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã¯SQLã‚³ãƒ¡ãƒ³ãƒˆå†…ã«è¨å®šæ§‹æ–‡ã‚’æ›¸ãã®ã§ SQLã‚’ãã®ã¾ã¾å®Ÿè¡Œã—ã¦è©¦ã™ã“ã¨ãŒå‡ºæ¥ã‚‹ã€‚ aptã«ã‚ˆã‚‹ãƒã‚§ãƒƒã‚¯ã§ã€sqlãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã¨æ¡ä»¶ã‚„valueã®å®šç¾©ã« é–“é•ã„ãŒã‚ã‚‹å ´åˆã€ã™ãã«åˆ†ã‹ã‚‹ã€‚ã“ã‚Œã¨ã£ã¦ã‚‚é‡è¦ã€‚ S2Daoä½¿ã£ã¦ãŸã‚‰å®Ÿè¡Œã—ãªã„ã¨åˆ†ã‹ã‚‰ãªã„äº‹ãŒã™ãåˆ†ã‹ã‚‹ã€‚ æ¡ä»¶ã®ãƒ—ãƒãƒ‘ãƒ†ã‚£ã®å®šç¾©å¿˜ã‚Œ
quodius 2011/12/27
Doma++

Doma

sql

ORM
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
quodius 2011/07/14
sql
ãƒªãƒ³ã‚¯
æœ€é€Ÿä¸¦ã³æ›¿ãˆç ”ç©¶ä¼š - Yappo::ã‚¿ãƒ¯ã‚·
1000ä¸‡è¡Œã¨ã‹10å„„è¡Œã§ã‚‚ä½•ã§ã‚‚ã„ã„ã‘ã©ã€ã„ã£ã±ã„ãƒ‡ãƒ¼ã‚¿ãŒå…¥ã£ã¦ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã®sortã‚«ãƒ©ãƒ ã®å€¤ã‚’ä¸¦ã³æ›¿ãˆãŸã„ã€‚ ä¾‹ãˆã°ä»¥ä¸‹ã®ã‚ˆã†ã«sort_testãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ use strict; use warnings; use DBI; my $dbi = DBI->connect('DBI:mysql:database=test'); $dbi->do('DROP TABLE IF EXISTS sort_test'); $dbi->do(<<SQL); CREATE TABLE sort_test ( id INT, sort INT, index(id), index(sort) ) ENGINE=InnoDB SQL my $sth = $dbi->prepare('INSERT INTO sort_test VALUES' . join(', ', ('(?,?)')x10_000
quodius 2009/11/09
programming

Algorithm

sql
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (8)

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

ãŠçŸ¥ã‚‰ã›

ã€Œã‚ã¨ã§èªã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èªã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (8)

sqlã«é–¢ã™ã‚‹quodiusã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

H2ã§ãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°/ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒ­ã‚·ãƒ¼ã‚¸ãƒ£ã‚’è©¦ã—ã¦ã¿ã‚‹2 - H2Databaseã‚’è¿½ã£ã‹ã‘ã¦ã„ãŸã‚Šã—ãŸãƒ–ãƒ­ã‚°

H2:ãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°ã¨ãƒ—ãƒ­ã‚·ãƒ¼ã‚¸ãƒ£ä½œæˆæ–¹æ³•

ORãƒžãƒƒãƒ‘ãƒ¼ãªã‚‰DomaãŒä¸€ç•ªã€‚ - newta(ã«ã‚…ãƒ¼ãŸ)ã®æ—¥è¨˜

ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ

æœ€é€Ÿä¸¦ã³æ›¿ãˆç ”ç©¶ä¼š - Yappo::ã‚¿ãƒ¯ã‚·

ãŠçŸ¥ã‚‰ã›

ã€Œã‚ã¨ã§èª­ã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èª­ã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (8)

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

H2ã§ãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°/ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’è©¦ã—ã¦ã¿ã‚‹2 - H2Databaseã‚’è¿½ã£ã‹ã‘ã¦ã„ãŸã‚Šã—ãŸãƒ–ãƒã‚°

H2:ãƒ¦ãƒ¼ã‚¶å®šç¾©é–¢æ•°ã¨ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ä½œæˆæ–¹æ³•

ORãƒžãƒƒãƒ‘ãƒ¼ãªã‚‰DomaãŒä¸€ç•ªã€‚ - newta(ã«ã‚…ãƒ¼ãŸ)ã®æ—¥è¨˜

ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ

æœ€é€Ÿä¸¦ã³æ›¿ãˆç ”ç©¶ä¼š - Yappo::ã‚¿ãƒ¯ã‚·

ãŠçŸ¥ã‚‰ã›

ã€Œã‚ã¨ã§èªã‚€ã€ã‚¿ã‚°ã§æŒ¯ã‚Šè¿”ã‚‹2024å¹´ ã€œä»Šå¹´ã®ã€Œã‚ã¨ã§èªã‚€ã€ã€ä»Šå¹´ã®ã†ã¡ã«ã€œ

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬3é€±ï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆç¬¬2é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹