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

MysqlÓÅ»¯·½°¸Ö®Ë÷ÒýµÄʹÓÃ

 
Ë÷ÒýÓÃÓÚ¿ìËÙÕÒ³öÔÚij¸öÁÐÖÐÓÐÒ»Ìض¨ÖµµÄÐС£²»Ê¹ÓÃË÷Òý£¬MySQL±ØÐë´ÓµÚ1Ìõ¼Ç¼¿ªÊ¼È»ºó¶ÁÍêÕû¸ö±íÖ±µ½ÕÒ³öÏà¹ØµÄÐС£±íÔ½´ó£¬»¨·ÑµÄʱ¼äÔ½¶à¡£Èç¹û±íÖвéѯµÄÁÐÓÐÒ»¸öË÷Òý£¬MySQLÄÜ¿ìËÙµ½´ïÒ»¸öλÖÃÈ¥ËÑÑ°µ½Êý¾ÝÎļþµÄÖм䣬ûÓбØÒª¿´ËùÓÐÊý¾Ý¡£Èç¹ûÒ»¸ö±íÓÐ1000ÐУ¬Õâ±È˳Ðò¶ÁÈ¡ÖÁÉÙ¿ì100±¶¡£×¢ÒâÈç¹ûÄãÐèÒª·ÃÎʴ󲿷ÖÐУ¬Ë³Ðò¶ÁÈ¡Òª¿ìµÃ¶à£¬ÒòΪ´ËʱÎÒÃDZÜÃâ´ÅÅÌËÑË÷¡£
 
´ó¶àÊýMySQLË÷Òý(PRIMARY KEY¡¢UNIQUE¡¢INDEXºÍFULLTEXT)ÔÚBÊ÷Öд洢¡£Ö»ÊÇ¿Õ¼äÁÐÀàÐ͵ÄË÷ÒýʹÓÃR-Ê÷£¬²¢ÇÒMEMORY±í»¹Ö§³ÖhashË÷Òý¡£
 
×Ö·û´®×Ô¶¯µØѹËõǰ׺ºÍ½áβ¿Õ¸ñ¡£
 
×ܵÄÀ´Ëµ£¬°´ºóÃæµÄÌÖÂÛʹÓÃË÷Òý¡£±¾½Ú×îºóÃèÊöhashË÷Òý(ÓÃÓÚMEMORY±í)µÄÌØÕ÷¡£
 
Ë÷ÒýÓÃÓÚÏÂÃæµÄ²Ù×÷£º
 
·         ¿ìËÙÕÒ³öÆ¥ÅäÒ»¸öWHERE×Ó¾äµÄÐС£
 
·         ɾ³ýÐС£Èç¹û¿ÉÒÔÔÚ¶à¸öË÷ÒýÖнøÐÐÑ¡Ôñ£¬MySQLͨ³£Ê¹ÓÃÕÒµ½×îÉÙÐеÄË÷Òý¡£
 
·         µ±Ö´ÐÐÁª½Óʱ£¬´ÓÆäËü±í¼ìË÷ÐС£
 
·         ¶Ô¾ßÌåÓÐË÷ÒýµÄÁÐkey_colÕÒ³öMAX()»òMIN()Öµ¡£ÓÉÔ¤´¦ÀíÆ÷½øÐÐÓÅ»¯£¬¼ì²éÊÇ·ñ¶ÔË÷ÒýÖÐÔÚkey_col֮ǰ·¢ÉúËùÓйؼü×ÖÔªËØʹÓÃÁËWHERE key_part_# = constant¡£ÔÚÕâÖÖÇé¿öÏ£¬MySQLΪÿ¸öMIN()»òMAX()±í´ïʽִÐÐÒ»´Î¹Ø¼ü×Ö²éÕÒ£¬²¢Óó£ÊýÌæ»»Ëü¡£Èç¹ûËùÓбí´ïʽÌ滻Ϊ³£Á¿£¬²éѯÁ¢¼´·µ»Ø¡£ÀýÈ磺
 
·                SELECT MIN(key_part2),MAX(key_part2)
·                    from tbl_name WHERE key_part1=10;
·         Èç¹û¶ÔÒ»¸ö¿ÉÓùؼü×ÖµÄ×î×óÃæµÄǰ׺½øÐÐÁËÅÅÐò»ò·Ö×é(ÀýÈ磬ORDER BY key_part_1,key_part_2)£¬ÅÅÐò»ò·Ö×éÒ»¸ö±í¡£Èç¹ûËùÓйؼü×ÖÔªËغóÃæÓÐDESC£¬¹Ø¼ü×ÖÒÔµ¹Ðò±»¶ÁÈ¡¡£
·         ÔÚһЩÇé¿öÖУ¬¿ÉÒÔ¶ÔÒ»¸ö²éѯ½øÐÐÓÅ»¯ÒԱ㲻ÓòéѯÊý¾ÝÐм´¿ÉÒÔ¼ìË÷Öµ¡£Èç¹û²éѯֻʹÓÃÀ´×Ôij¸ö±íµÄÊý×ÖÐͲ¢ÇÒ¹¹³ÉÄ


Ïà¹ØÎĵµ£º

aspºÍmysql·ÖÒ³´úÂë

 <!--#include file="zheboconn.asp"-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB2312" />
<title>aspºÍmysql·ÖÒ³´úÂë</title>
<style type="text/css">
<!--
.STYLE3 {
 fon ......

linuxÏÂapache£¬php,mysqlÕûºÏtomcat

1.Ç°ÃæһƪÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔ­Òò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......

phpµ÷ÓÃmysql´æ´¢¹ý³Ì·µ»Ø¶à¸ö½á¹û¼¯µÄ´¦Àí

 ·µ»ØÒ»¸ö½á¹ûÈ«ÊÀ½ç¶¼ÖªµÀÔõô´¦Àí£¬¹Ø¼üÊÇ·µ»Ø¶à¸ö½á¹û¼¯¾Í²»ºÃ°ìÁË£¬ÏÂÃæÓÐÒ»½â¾ö°ì·¨
´æ´¢¹ý³Ì´úÂë
DELIMITER $$;
DROP PROCEDURE IF EXISTS `test`.`sp_test`$$
CREATE PROCEDURE `test`.`sp_test` ()
BEGIN
    select * from `user`.`user` limit 0, 50;
    select coun ......

ÀûÓÃmysqldumpµ¼³öµ¼ÈëmysqlËùÓÐÊý¾Ý¿â


1 µ¼³ö:
½øÈëÃüÁîÐÐ: Ö´ÐÐ
mysqldump -u username -p password –all-databases > all.sql
Ïêϸ²ÎÊý:
http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
2 µ¼Èë
½øÈëmysql -u username -p password
Ö´ÐÐsource all.sql;
......

mysqlÓÃjdbcÁ¬½Ó

Ê×ÏÈ·ÅÖúÃjdbcÇý¶¯³ÌÐò£¬ÔÚ java\jre6\lib\ext\Ï£¬java\jdk1.6\jre\libµÈµØ·½¶¼·ÅÆðÀ´£¬ÒòΪ²»È·¶¨ÔÚÄÄÀïÓÐÓ÷··
Class.forName("com.mysql.jdbc.Driver").newInstance();
 String url = "jdbc:mysql://localhost/DATABASENAME?user=USERNAME&password=PASSWORD&useUnicode=tru ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ