HSP¥Ý¡¼¥¿¥ë
¥µ¥¤¥È¥Þ¥Ã¥× ¤ªÌ䤤¹ç¤ï¤»


HSPTV!·Ç¼¨ÈÄ


̤²ò·è ²ò·è Ää»ß ºï½üÍ×ÀÁ

2017
0824
¥¤¥Ê¥¦¥µsql¤Ë¤Ä¤¤¤Æ12²ò·è


¥¤¥Ê¥¦¥µ

¥ê¥ó¥¯

2017/8/24(Thu) 00:30:02|NO.81080

°ìÅÙ¡¢²ò·è¤È¤·¤¿¤Î¤Ç¤¹¤¬¡¢µÍ¤Þ¤Å¤¤¤Æ¤·¤Þ¤¤¤â¤¦°ìÅÙ¿·µ¬¤È¤·¤Æ¼ÁÌ䤵¤»¤Æ¤¤¤À¤­¤Þ¤·¤¿¡£
Á°²ó¤Î¼ÁÌä¤Çstrongest¤µ¤ó¤¬Ä󼨤·¤Æ¤¤¤¿¤À¤­¤Þ¤·¤¿¡¢¥¹¥¯¥ê¥×¥È¤Ë¤¢¤Ã¤¿ÊÑ¿ôA¤Ë¤â¤Ã¤È¤â¶á¤¤
¥«¥é¥àB¤ò¸¡º÷¤¹¤ë¤È¤³¤í¢­

sql_q "SELECT B,C FROM data_bace ORDER BY abs(B-"+A+") ASC LIMIT 1"
¤³¤ì¤ÎÊÑ¿ôA¤¬Éé¤Î¿ô¤À¤Ã¤¿¾ì¹ç¤Ç¤âÂбþ¤Ç¤­¤ë¤è¤¦¤Ë¤¹¤ë¤Ë¤Ï¤É¤¦¤·¤¿¤é¤¤¤¤¤Ç¤¹¤«¡©
Éé¤Î¿ô¤Î¤Þ¤Þ¼Â¹Ô(ÊÑ¿ôA=-10)¤¹¤ë¤È¡¡B--10¤È¤Ê¤ê¤ª¤½¤é¤¯"-"¤¬Æó½Å¤Ê¤ë¤³¤È¤¬¥¨¥é¡¼¤Î¸µ¶§¤«¤È»×¤¤¤Þ¤¹¡£



¤³¤Îµ­»ö¤ËÊÖ¿®¤¹¤ë


tds12

¥ê¥ó¥¯

2017/8/24(Thu) 01:09:04|NO.81083

¤è¤¯¤ï¤«¤ê¤Þ¤»¤ó¤¬¤³¤Î¤è¤¦¤Ç¤Ï¤À¤á¤Ê¤Î¤Ç¤¹¡©
¡Ö"abs(B" + (-A) + ")"¡×



strongest

¥ê¥ó¥¯

2017/8/24(Thu) 07:39:36|NO.81086

A¤¬¥Þ¥¤¥Ê¥¹Ãͤâ¼è¤ê¤¦¤ë¤Î¤Ç¤¢¤ì¤Ð¡¢

abs(B-("+A+"))

¤È³ç¸Ì¤Ç°Ï¤ó¤Ç¤ä¤ê¤Þ¤·¤ç¤¦¡£



¤µ¤«

¥ê¥ó¥¯

2017/8/24(Thu) 22:02:27|NO.81093

¡ÖORDER BY ¡×¤ÏʤÓÂؤ¨¤ò¹Ô¤¦Ì¿Îá¤Ê¤Î¤ÇÄ̾ï¤Ï¥«¥é¥à̾¤òµ­½Ò¤¹¤ë¤Î¤Ç¤¹¤¬
¡ÖORDER BY abs(B-10)¡×¤Ï¤É¤¦¤¤¤¦°ÕÌ£¤Ê¤Î¤Ç¤·¤ç¤¦¤«¡£

¥«¥é¥à¤ÎÂå¤ï¤ê¤Ë¿ô»úN¤È¤¹¤ì¤Ð¡¢NÈÖÌܤΥ«¥é¥à¤È¤¤¤¦¤³¤È¤Ë¤Ï¤Ê¤ë¤Î¤Ç¾åµ­
¤Î¾ì¹ç¤À¤È¥Æ¡¼¥Ö¥ëÆâ¤Î0¤è¤êÂ礭¤¤¥«¥é¥à¿ô°Ê²¼¤Ê¤éÆ°¤¯¤È¤Ï»×¤¤¤Þ¤¹¤¬¡£



¥¤¥Ê¥¦¥µ

¥ê¥ó¥¯

2017/8/25(Fri) 00:10:45|NO.81095

¤Á¤Ê¤ß¤Ë¤³¤ì¤Ç¡¢ÊÑ¿ôA¤¬Éé¤Î¿ô¤Ç¤¢¤Ã¤Æ¤âƱ¤¸¤è¤¦¤ËÊÑ¿ôA¤ËºÇ¤â¶á¤¤¥«¥é¥àB¤¬Å¦½Ð¤µ¤ì¤Þ¤¹¤«¡©



¥¤¥Ê¥¦¥µ

¥ê¥ó¥¯

2017/8/25(Fri) 13:25:42|NO.81100

¤ï¤«¤ê¤Ë¤¯¤¯¤Æ¤¹¤ß¤Þ¤»¤ó¡£¼ÁÌä¤Î»ÅÊý¤òÊѤ¨¤Þ¤¹¡£

#include "sqlele.hsp" //sqlele¥â¥¸¥å¡¼¥ë ; ¥Ç¡¼¥¿¥Ù¡¼¥¹¥Õ¥¡¥¤¥ë¡Ösample.db¡×¤ò³«¤¯ (¥Õ¥¡¥¤¥ë¤¬Ìµ¤±¤ì¤ÐºîÀ®¤µ¤ì¤Þ¤¹) sql_open "data_bace.db" ;¡Ödata_base¡×¥Æ¡¼¥Ö¥ë¤òºîÀ® (¤¹¤Ç¤Ë¥Æ¡¼¥Ö¥ë¤¬¤¢¤ì¤ÐºîÀ®¤µ¤ì¤Þ¤»¤ó) sql_q "drop table if exists data_bace" ; [¥«¥é¥àB,C] ¥«¥é¥à¤òºîÀ® (¤¹¤Ç¤Ë¥«¥é¥à¤¬¤¢¤ì¤ÐºîÀ®¤µ¤ì¤Þ¤»¤ó) sql_q "CREATE TABLE IF NOT EXISTS data_bace (ID INTEGER PRIMARY KEY AUTOINCREMENT, B)" repeat A=rnd(100) sql_q "INSERT INTO data_bace(B) VALUES("+A+")" sql_q "SELECT B FROM data_bace ORDER BY abs("+B+"-("+A+")) ASC LIMIT 1" B =int(sql_v("B")) title ""+B+":"+A+"" await 20 loop
¤³¤ì¤ò¼Â¹Ô¤¹¤ë¤Èɬ¤ºB¤ÈA¤ÎÃͤÏƱ¤¸¤Ë¤Ê¤ë¤Ï¤º¤Ç¤¹¤è¤Í¡©¤½¤ì¤È¤â°ã¤¦Ãͤˤʤê¤Þ¤¹¤«¡©



strongest

¥ê¥ó¥¯

2017/8/25(Fri) 18:03:50|NO.81102

ORDER BY¶ç¤Ë¤Ï¡¢¥«¥é¥à̾°Ê³°¤Ë¤â¼°¤òµ­½Ò¤Ç¤­¤Þ¤¹¡£
tksqlite¤Ê¤É¤Ç¼ÂºÝ¤ËÀ¸À®¤µ¤ì¤¿¥Æ¡¼¥Ö¥ë¤ò³«¤­¡¢ÌäÂê¤ÎSQLʸ¤òLIMIT¶ç¤Ê¤·¤Ç¼Â¹Ô¤¹¤ë¤È¡¢
Àµ¤·¤¯Æ°ºî¤·¤Æ¤¤¤ë¤³¤È¤¬¤ï¤«¤ê¤Þ¤¹¡£

¾Ü¤·¤¯¤Ï¡¢SQLite¤Î¸ø¼°¥µ¥¤¥È¤Î¥É¥­¥å¥á¥ó¥È¤ò»²¾È¤¯¤À¤µ¤¤¡£
https://www.sqlite.org/lang_select.html



strongest

¥ê¥ó¥¯

2017/8/25(Fri) 18:29:18|NO.81103

¤½¤ì¤È¡¢¥¤¥Ê¥¦¥µ¤µ¤ó¤Î¿·¤·¤¤¥½¡¼¥¹¤Ï¡¢²¿¤ò°Õ¿Þ¤·¤Æ¤Î¼ÁÌä¤Ê¤Î¤«¤¬È½¤ê¤«¤Í¤Þ¤¹¡£
Á°²ó¤Î¥½¡¼¥¹¤ò°úÍÑ¡¦²þ½¤¤·¤Þ¤¹¤¬¡¢

#include "sqlele.hsp" ; ¥Ç¡¼¥¿¥Ù¡¼¥¹¥Õ¥¡¥¤¥ë¡Ösample.db¡×¤ò³«¤¯ (¥Õ¥¡¥¤¥ë¤¬Ìµ¤±¤ì¤ÐºîÀ®¤µ¤ì¤Þ¤¹) sql_open "data_bace.db" ;¡ÖMemoTable¡×¥Æ¡¼¥Ö¥ë¤òºîÀ® (¤¹¤Ç¤Ë¥Æ¡¼¥Ö¥ë¤¬¤¢¤ì¤ÐºîÀ®¤µ¤ì¤Þ¤»¤ó) sql_q "drop table if exists data_bace" sql_q "CREATE TABLE IF NOT EXISTS data_bace (ID INTEGER PRIMARY KEY AUTOINCREMENT, B, C)" sql_q "begin" repeat 1000 sql_q "insert into data_bace(B,C) values("+str(rnd(256)-128)+","+str(rnd(256)-128)+")" loop sql_q "commit" A=-100 sql_q "SELECT B,C FROM data_bace ORDER BY abs(B-("+A+")) ASC LIMIT 1" cls 4:pos 0,0:color 255,255,255:mes "B = " + sql_v("B") + " / C = " + sql_v("C")+""

¥Þ¥¤¥Ê¥¹Ãͤâ´Þ¤ó¤À¥Æ¡¼¥Ö¥ë¤òºîÀ®¤·¡¢¾å¤Ç½Ò¤Ù¤¿¤è¤¦¤Ë³ç¸Ì¤Ç°Ï¤Ã¤¿¤â¤Î¤Ç¤¹¡£
¤³¤Î¥½¡¼¥¹¤ò¼Â¹Ô¸å¡¢À¸À®¤µ¤ì¤¿¥Ç¡¼¥¿¥Õ¥¡¥¤¥ë¤ò tksqlite ¤Ç³«¤­¡¢Ãæ¤Ë¤¢¤ëdata_bace¤Ë
ÂФ·¾åµ­¥½¡¼¥¹Ãæ¤ÎSQLʸ¤Ç¤¢¤ë

SELECT B,C FROM data_bace ORDER BY abs(B-(-15)) ASC

¤ò¼Â¹Ô¤¹¤ì¤Ð¡¢£Á¤¬¥Þ¥¤¥Ê¥¹Ãͤξì¹ç¤Ç¤â¥Æ¡¼¥Ö¥ë¤¬Àµ¤·¤¯¥½¡¼¥È¤µ¤ì¡¢
LIMIT¶ç¤òÍѤ¤¤ì¤Ð¤½¤ÎÀèƬ¤Î£±¹Ô¤¬¼èÆÀ¤Ç¤­¤ë¤³¤È¤¬¤ï¤«¤ë¤È»×¤¤¤Þ¤¹¡£

HSP¤Î¥¹¥¯¥ê¥×¥È¥¨¥Ç¥£¥¿¤À¤±¤Ç¤Ï¡¢SQL¤òÍý²ò¤¹¤ë¤Î¤ÏÂçÊѤǤ¹¡£
tksqlite ¤Ê¤É¤ÎSQLite¸þ¤±¥¨¥Ç¥£¥¿¤òÍøÍѤµ¤ì¤ë¤³¤È¤ò¤ª´«¤á¤¤¤¿¤·¤Þ¤¹¡£



strongest

¥ê¥ó¥¯

2017/8/25(Fri) 18:31:20|NO.81104

¾åµ­ÆâÍƤò°ìÉôÄûÀµ¡£

£Á¤¬-100¤Ç¤¹¤Î¤Ç¡¢tksqlite¤Ç¼Â¹Ô¤¹¤Ù¤­¥³¡¼¥É¤Ï

SELECT B,C FROM data_bace ORDER BY abs(B-(-100)) ASC
¤Ç¤¹¤Í¡£¼ºÎ餤¤¿¤·¤Þ¤·¤¿¡£



strongest

¥ê¥ó¥¯

2017/8/25(Fri) 18:35:01|NO.81105

¤â¤¦¤Ò¤È¤ÄÄɵ­¡£

ORDER¶ç¤Ë¼°¤¬½ñ¤±¤ë¤È¤¤¤¦¤Î¤¬¤¤¤Þ¤¤¤Á¤ï¤«¤é¤Ê¤¤¤Î¤Ç¤¢¤ì¤Ð¡¢
¾åµ­¥½¡¼¥¹¤ÇÀ¸À®¤µ¤ì¤¿¥Æ¡¼¥Ö¥ë¤Ë tksqlite ¤Ê¤É¤Ç°Ê²¼¤ÎSQLʸ¤ò¼Â¹Ô¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£

SELECT *, abs(B-(-100)) FROM data_bace ORDER BY abs(B-(-100)) ASC



¥¤¥Ê¥¦¥µ

¥ê¥ó¥¯

2017/8/25(Fri) 23:47:38|NO.81106

¤¿¤¯¤µ¤ó¤Î²óÅúÍ­Æñ¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£²ò·è¤È¤µ¤»¤Æ¤¤¤¿¤À¤­¤Þ¤¹¡£º£¸å¤È¤â¤ª´ê¤¤¤·¤Þ¤¹¡£



¤µ¤«

¥ê¥ó¥¯

2017/8/26(Sat) 02:38:58|NO.81109

²ò·èºÑ¤È¤¤¤¦¤³¤È¤Ç¤¹¤¬Á°¤ÎÅê¹Æ¤Î°Ê²¼¤ÎSQL¤ò¤ß¤Æstrongest¤µ¤ó¤Î¤ä¤ê¤¿¤¤¤³¤È¤¬¤ï¤«¤ê¤Þ¤·¤¿¡£
­¡sql_q "SELECT [C] , [B] FROM [data_bace] WHERE abs([B] - " + A + ")= (SELECT min(abs([B] - " + A + ")) FROM [data_baceX]) ORDER BY [B] ;"

Æ°ºî¤È¤·¤Æ¤Ï°Ê²¼¤ÈƱ¤¸¤È¤¤¤¦¤³¤È¤Ç¤¹¤Í¡£
SELECT A, abs(B-(-100)) AS ABS FROM data_bace ORDER BY ABS
¤Þ¤¿¤Ï
SELECT A, abs(B-(-100)) FROM data_bace ORDER BY 2

¤·¤«¤·¸µ¡¹¤Î¥¤¥Ê¥¦¥µ¤µ¤ó¤Î¼ÁÌä¤Ç¤¢¤ë­¡¤Ïdata_bace¥Æ¡¼¥Ö¥ë¤Èdata_baceX¥Æ¡¼¥Ö¥ë¤ò»ÈÍÑ
¤·¤Æ¤Þ¤¹¤Î¤Çdata_baceX¤ò̵»ë¤·¤Æñ½ã¤Ëdata_bace¤Î¤ß¤Ë¤Ï¤Ê¤é¤Ê¤¤¤Î¤Ç¤Ï¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£
¤È¤Ï¸À¤¨¤Ê¤Ë¤ò¤·¤¿¤¤¤Î¤«¤ï¤«¤é¤Ê¤¤SQL¤Ê¤Î¤Ç¤½¤ì¤¾¤ì¤Î¥Æ¡¼¥Ö¥ë¤Î¥Ç¡¼¥¿¤òEXCELÅù¤Ëɽ¤È
¤·¤ÆÀ°Íý¤·¤É¤¦¤¤¤¦¾ì¹ç¤ÎC,B¤òÃê½Ð¤¹¤ë¤Î¤«¤Þ¤º¤ÏÀ°Íý¤·¤¿Êý¤¬Îɤ¤¤È»×¤¤¤Þ¤¹¡£



strongest

¥ê¥ó¥¯

2017/8/26(Sat) 15:46:10|NO.81114

¸µ¡¹¤Î¥½¡¼¥¹¤Ç¤Ï¡¢data_baceX ¤Ï¥½¡¼¥¹Ãæ¤Î¤É¤³¤Ë¤âÀ¸À®¤Îµ­½Ò¤¬¤Ê¤¤¤Î¤Ç¡¢
¥µ¥Ö¥¯¥¨¥ê¤Î¤Ä¤â¤ê¤Çµ­½Ò¤·¤¿¤Î¤À¤í¤¦¤«¤È¹Í¤¨¤Þ¤·¤¿¤¬¤½¤¦¤Ç¤â¤Ê¤µ¤½¤¦¤À¤È¡£
¤Ç¤¹¤Î¤Ç¡¢½ã¿è¤ËSQL¹½Ê¸¤ÎÊÙ¶¯ÉÔ­¤À¤ÈȽÃǤ·¡¢Â縵¤Î¼ÁÌäʸ¤Î

¡¡data_bace¤È¤¦¤¤¥Æ¡¼¥Ö¥ë¤ËID,B,C¤È¤¤¤¦¥«¥é¥à¤¬¤¢¤ê¤Þ¤¹¡£
¡¡¤½¤³¤«¤éÊÑ¿ôA¤ËºÇ¤â¶á¤¤¿ô[¥«¥é¥àB]¤ÎÃͤȤ½¤ì¤Î[¥«¥é¥àC]¤ÎÃͤòÃê½Ð¤·¡ÖB= / C= ¡×
¡¡¤Î¤è¤¦¤Ê´¶¤¸¤Çɽ¼¨¤·¤¿¤¤¡£

¤Ë¹Ê¤Ã¤Æ²ò¼á¤·¤Þ¤·¤¿¡£

ORDER BY¶ç¤Î¹½Ê¸¤Ë¤Ä¤¤¤Æ¤Ç¤¹¤¬¡¢¤Á¤ç¤Ã¤Èµ¤¤Ë¤Ê¤Ã¤¿¤Î¤Ç¡£
°Ê²¼¤Î­¡­¢¤ÎSQLʸ¤Ï¡¢Æ°ºî¤¬°Û¤Ê¤ê¤Þ¤¹¡£

¡¡­¡¡¡SELECT * FROM temp ORDER BY 3 ¡¡­¢¡¡SELECT * FROM temp ORDER BY 6-3

Àè¤Ë¾Ò²ð¤·¤¿SQLite¤Î²òÀâ¥Ú¡¼¥¸¤Ë¤â¤¢¤ê¤Þ¤¹¤¬¡¢ORDER BY¶ç¤Î»ØÄ꤬Äê¿ô¤Î¾ì¹ç¤Ï¡¢
¥«¥é¥à¤Î½çÈ֤˽¾¤¤»ØÄꤵ¤ì¤¿¥«¥é¥à¤ò´ð½à¤Ë¥½¡¼¥È¡£¾å¤ÎÎã¤À¤È¡¢temp¥Æ¡¼¥Ö¥ëÃæ¤Î
£³ÈÖÌܤΥ«¥é¥à¤ò´ð½à¤Ë¥½¡¼¥È¤·¤Þ¤¹¡£

¼°¤Î¾ì¹ç¤Ï¡¢¤½¤ì¤ò²ò¼á¤·¤¿¿·¥«¥é¥à¤ò´ð½à¤Ë¥½¡¼¥È¤·¤Þ¤¹¡£AS¶ç¤Ç¥¨¥¤¥ê¥¢¥¹¤ò
¤Ä¤±¤Ê¤¤¾ì¹ç¤Ï¡¢¼°¤½¤Î¤â¤Î¤¬¥«¥é¥à̾¤À¤È²ò¼á¤µ¤ì¤Þ¤¹¡£
¤¿¤À¤·¾å¤ÎÎã¤À¤È¡¢¡Ö6-3¡×¤È¤¤¤¦¥«¥é¥à¤¬ºî¤é¤ì¤Þ¤¹¤¬·×»»·ë²Ì¤Ï¾ï¤Ë£³¤Ç¤¹¤«¤é
Á´¤Æ¤Î¹Ô¤Îɾ²Á¤¬£³¤Ë¤Ê¤ë¤À¤±¡¢¼ÂºÝ¤Ë¤Ïtemp¥Æ¡¼¥Ö¥ë¤Ëinsert¤·¤¿½ç¤½¤Î¤Þ¤Þ¤¬
½ÐÎϤµ¤ì¤ë¤³¤È¤Ë¤Ê¤ê¤Þ¤¹¡£

¤³¤Î¼°¤Ë¡¢¹Ô¤´¤È¤ËÃͤ¬°Û¤Ê¤ë¾õÂ֤Υ«¥é¥à̾¤ò²Ã¤¨¤ë¤³¤È¤Ç¡¢³Æ¹Ô¤Î·ë²Ì¤¬ÊѲ½¤·¡¢
¤½¤ì¤ò¸µ¤Ë¥½¡¼¥È¤¬¹Ô¤ï¤ì¤ë¤È¤¤¤¦¤ï¤±¤Ç¤¹¡£

¤¯¤É¤¯¤Ê¤ê¤Þ¤¹¤Î¤Ç¡¢¤ï¤¿¤·¤â¤³¤³¤Þ¤Ç¡£



ONION software Copyright 1997-2023(c) All rights reserved.