Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

mysql ½ØÈ¡×Ö·û´®

±í½á¹¹ÈçÏ£¬ÏÖÔÚÎÒÒª¶Á³öÀ´µÄÊý¾Ý±£Áô1λСÊý£¬sqlÓï¾äÒªÔõÃ´Ð´ÄØ£¿£¨Ö»ÄÜÔÚsqlÓï¾äÖÐʵÏÖ£¬²»¿ÉÓÃjava¡¢phpµÈÀ´ÊµÏÖ£©
 lat lng
20.14 113.45
20.15 113.46
10 100.04

д³ÉÕâÑùµÄ»°
SELECT substr( lat, 1, instr( lat, '.' ) +1 ) AS lat1, substr( lng, 1, instr( lng, '.' ) +1 ) AS lng1
from address
GROUP BY lat1, lng1

10¾Í±ä³É1ÁË¡£

¸÷λ´óÏÀ°ï°ïæ¡£
±íµÄ½á¹¹ÕâÑù£º
lat lng
20.14 113.45
20.15 113.46
10 100.04



²»ÊÇËÄÉáÎåÈ룬ÊÇÖ±½Ó½ØÈ¡

ÒýÓò»ÊÇËÄÉáÎåÈ룬ÊÇÖ±½Ó½ØÈ¡


¿´ #3Â¥

Á½¸öÀ¸Î»¶¼ÊÇvarcharÀàÐÍ£¬ÓÃFLOOR(lat*10)/10³ö´í

ÒýÓÃ

Á½¸öÀ¸Î»¶¼ÊÇvarcharÀàÐÍ£¬ÓÃFLOOR(lat*10)/10³ö´í


¿ÉÒÔÁËÊÇÎÒ¸ã´íÁË£¬ÄãµÄ×ö·¨ÊǶԵÄ

Æ®×ß¡£¡£¡£¡£¡£

¿´ÊÖ²áÖÐTRUNCATEº¯Êý£¡£¡£¡


Ïà¹ØÎÊ´ð£º

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

mysqlÖÐÎÄÂÒÂë - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......

vc++ ÓÃmysql¹Ù·½ connector ³ö´í - VC/MFC / Êý¾Ý¿â

try
{
sql::Driver *driver;
sql::Connection *con;
//´´½¨Á¬½Ó
driver = get_driver_instance();
con = driver->connect("tcp://192.168.18.52:3306", "root", "1234 ......

mysql×Ö¶ÎÌáÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

¸÷λÐÖµÜÇë½Ì Ï£¬ÔÚmysqlÖÐÄܲ»ÄÜʵÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬
Ò»¸ö×Ö¶ÎAÊÇ´¢´æÒ»´ó¶ÎÎÄ×ÖÄÚÈݵģ¬ÊÇÓ¢ÎÄ£¬Äܲ»ÄÜͨ¹ýMYSQLµÄ²éѯ֮ÀàµÄ¹¦ÄÜ£¬À´»ñµÃÕâ¸ö×Ö¶ÎÖÐ ³öÏÖÆµÂÊ×î¸ßµÄÊ®¸öµ¥´Ê£¬²¢½«ÕâÊ®¸öµ¥´Ê×öΪеÄ×ֶδ¢´æ
a ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ