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

mysql²éѯÎÊÌ⣬¼± - Java / Java EE

ʹÓÃmysqlµÄjdbc driverÁ¬½ÓmysqlÊý¾Ý¿â¡£¾­³£³öÏÖÏÂÃæµÄ²éѯ£¬ÇëÎÊÊǸÉɶµÄ£¿

/* mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} ) */SHOW
VARIABLES WHERE Variable_name ='language' OR Variable_name = 'net_write_timeout' OR
Variable_name = 'interactive_timeout' OR Variable_name = 'wait_timeout' OR Variable_name
= 'character_set_client' OR Variable_name = 'character_set_connection' OR Variable_name =
'character_set' OR Variable_name = 'character_set_server' OR Variable_name =
'tx_isolation' OR Variable_name = 'transaction_isolation' OR Variable_name =
'character_set_results' OR Variable_name = 'timezone' OR Variable_name = 'time_zone' OR
Variable_name = 'system_time_zone' OR Variable_name = 'lower_case_table_names' OR
Variable_name = 'max_allowed_packet' OR Variable_name = 'net_buffer_length' OR
Variable_name = 'sql_mode' OR Variable_name = 'query_cache_type' OR Variable_name =
'query_cache_size' OR Variable_name = 'init_connect'

¹À¼ÆÇý¶¯°ü°æ±¾ÓÐÎÊÌâ°É

²»Á˽⣬ȥϸö×îеÄÇý¶¯°ü¿´¿´°É

¸Ð¾õÊÇ·ñÊÇconnectorÔÚά»¤Á¬½Ó³ØÀïµÄÁ¬½Ó£¿»òÕß˵ÊDzâÊÔÁ¬½Ó³ØÀïµÄÁ´½ÓÊÇ·ñ¿ÉÓ㿸ßÈË¿ì³öÏÖ°É

֨װ......................

²¹³äÒ»µã£¬²¢Ã»Óе¼Ö³ÌÐò³ö´í»òÕß²»ÄÜÔËÐУ¬Ö»ÊÇ´ÓmysqlµÄshow full processlistÖп´µ½´óÁ¿ÕâÖÖ²éѯ£¬²»Ã÷°×ÊÇÕ¦»ØÊ£¬Òò´ËÇë½Ì¸÷λ¸ßÈË£¬ÕâЩ¶«¶«ÊÇÔõôÀ´µÄ

ÒýÓÃ

²¹³äÒ»µã£¬²¢Ã»Óе¼Ö³ÌÐò³ö´í»òÕß²»ÄÜÔËÐУ¬Ö»ÊÇ´ÓmysqlµÄshow full process


Ïà¹ØÎÊ´ð£º

JAVAµç×Ӵʵ䣿 - Java / Java SE

¸÷·´óÏÀ¸ø¸ö˼·£¬²»ÊÇÔÚÏßµÄÄÇÖÖ£¬¾ÍÊÇÒ»¸ö×öÆÕͨµÄÓ¦ÓóÌÐò¡£


´Ê¿âÔõôÉú³ÉÄØ£¿

²»»á¡£

ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
ÕÒ±¾×Öµä

ÒýÓÃ
´Ê¿âÔõôÉú³ÉÄØ£¿
Êý¾Ý¿â ºÇºÇ

ÓÃmap ¼üÖµ¶ÔÓ¦

Èç¹ûÓÃÊý¾Ý¿ ......

FCKÉÏ´«Îļþµ½linux·þÎñÆ÷ÎÊÌâ - Java / Java EE

ÇëÎÒÓÃFCKÉÏ´«Îļþ,ÔÚ±¾µØµÄwindows»úÉϲâÊÔ¿ÉÒÔ£¬µ«²¿Êðµ½linux·þÎñÆ÷ÉϾÍÉÏ´«²»ÁËÎļþ£¬ÉÏ´«Îļþʱһֱ¿¨ÔÚÄÇÀï¡£Íû¸÷λ´óϺָµã£¬Ð»Ð»£¡
·¹ý£¬°ïÄ㶥һϡ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£

ÉÏ´«ÎļþµÄ·¾¶ÎÊÌ⣬ ......

java windows7 MSSQL - Java / Java SE

ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates
Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......

mysqlµÄ¸üÐÂÓï¾ä - Java / Java SE

id name datetime
1 a 2010-05-13 10:15:00
2 b 2010-05-14 09:10:00
3 d 2010-05-14 10:10:00
ÈçºÎ½«¾àÀëĿǰ×î½üµÄÄǸö¼Ç¼µÄname ¸üÐÂΪ¡°x¡±ÄØ
лл¿© °¡ ºÇºÇ
update table_n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ