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

mySqlÖÐÈçºÎÅúÁ¿¸üмÆÊýÆ÷


¼ÙÈçÎÒÃǵÄmysqlÓÐÒ»¸ö¼ÆÊýÆ÷£¬¶øÕâ¸ö¼ÆÊýÆ÷ÐèÒªÎÒÃÇÖØÐÂͳ¼Æ£¬Ôõô°ìÄØ£¿
Ó¦Óó¡¾°£¬±ÈÈç˵ÓÐÒ»¸öÉ̳¡£¬Ã¿ÂôÒ»¸ö²úÆ·¶¼²úÉúÒ»¸öÁ÷Ë®£¬È»ºóÎÒÃÇÐèÒªÖªµÀÿ±ÊÁ÷Ë®ÊǸòúÆ·µÚ¼¸´Î³öÊ۵ģ¬ÕâÑù˵¿ÉÄܲ»Ã÷°×£¬ÎÒÄÃÒ»¸öÏêϸµÄÊý¾Ý
¾ÙÀý°É¡£
recordID,productID,productType,sellDate,counter
1, 1, 1, '2010-1-15 15:20:10' 0
2, 1, 2, '2010-1-15 15:20:10' 1
3, 2, 1, '2010-1-15 15:20:10' 0
4, 2, 1, '2010-1-15 15:20:10' 1
ÉÏÃæÕâ¸öÊý¾ÝÊÇһЩÈöÆøÊý¾Ý£¬°üÀ¨¼Ç¼µÄÁ÷Ë®ºÅ£¬²úÆ·µÄ±àºÅ£¬²úÆ·µÄÀàÐÍ£¬ÏúÊÛµÄʱ¼ä£¬¼ÆÊýÆ÷¡£Ò»°ãÀ´Ëµ£¬¼ÆÊýÆ÷ÎÒÃÇÊ×ÏÈÎÒ»áÏëµ½×ÔÔö£¬µ«Õâ¶ø¿Ï¶¨
ÊDz»¿ÉÄÜʹÓÃ×ÔÔö³¤µÄ¡£
ÎÒ×î³õµÄʱºò£¬³¢Ê¹ÓÃÕâÑùµÄ´úÂ룺update t_product set t_counter = (select max(counter)
from t_product where productid = 1 and productType = 1) + 1 where where
productid = 1 and productType = 1
µ«ÊÇmysql±¨´í£¬ÉÏÍøÒ»²é£¬mysql²»Ö§³ÖÕâÖÖд·¨£¬ºÇºÇ£¬ÎÒ¶ÔmysqlÍêÈ«²»ÊìϤ¡£¼ÇµÃÒÔǰÔÚsql
serverÓùýÓα꣬ȻºóÒ²ÊÔÊÔ²éÕÒÓα꣬¾­¹ýn´ÎgoogleÓë°Ù¶È£¬×îÖո㶨Õâ¸öÄÑÌâ¡£
ÎÒ±¾Éí¶ÔmysqlÍêÈ«ÊǸöÍâÐУ¬¾ÍÁ¬×¢ÊÍÒ²²»ÖªµÀÔõôעÊ͵ģ¬ÏÖÔÚÖÕÓÚÖªµÀÓÐÈýÖÖд·¨µÄ£¬¶ø--µÄ×¢ÊͺóÃæÊÇÒª¿ÕÒ»¸ñµÄ£¬ËùÒÔ´úÂëдµÃÐÔÄÜʲôµÄ
¾Í²»¸Ò˵ÁË£¬Ö»ÊÇʵÏÖÁËÕâ¸ö¹¦ÄÜ£¬Ï£Íû¶ÔÓÐͬÑùÐèÇóµÄÅóÓÑÓÐÓá£
ºÇ£¬»¹Ñ§µ½Ò»µã£¬declareÖ»ÄÜдÔÚ×îÇ°Ãæ¡£
¿´×îÖյĴúÂ룺
CREATE
PROCEDURE
p_resetCounter (
)
BEGIN
DECLARE
productID INT
;
DECLARE
type
INT
;
DECLARE
tmpCount INT
;
DECLARE
stopFlag int
;
 
#ʹÓÃÓαê
DECLARE
cur cursor for SELECT
COUNT
(
*
)
,
productID,
productType from
t_product GROUP BY
productID,
productType;
DECLARE
CONTINUE HANDLER
FOR NOT
FOUND set
stopFlag=
1
;
#Èç¹ûÕÒ²»µ½¼Ç¼£¬ÔòÉèÖÃstopFlag=1
 
#¶¨Òå±äÁ¿¼°´´½¨ÁÙʱ±í
CREATE
TEMPORARY
TABLE
tmp_Counter(
recordID int
not
null
,
Counter int
not
null
)
TYPE
=
HEAP;
 
#´ò¿ªÓαê
open cur;
REPEAT
fetch cur into
tmpCount,
productID,
type
;
SET
@id =
-
1
;
INSERT
INTO
tmp_Counter
(
SELECT
recordID,
(
@id :=
@id +
1
)
counter
from
t_prod


Ïà¹ØÎĵµ£º

linuxϰ²×°mysqlµÄÈýÖÖ·½Ê½

±¾´Î°²×°µÄϵͳƽ̨Ϊredhat 5
Ò»¡¢Ê¹ÓÃRPM°ü½øÐа²×°
  Ê×ÏÈ¿ÉÒÔ´Ó°²×°¹âÅÌÖлòÕßµ½mysqlµÄÍøÕ¾ÉÏÏÂÔØ¶ÔÓ¦°æ±¾µÄrpm°üÈçÏ£º
MySQL-server-community-5.1.38-0.rhel5.i386.rpm
MySQL-client-community-5.1.38-0.rhel5.i386.rpm
    ½Ó×ÅÎÒÃÇ¿ÉÒÔʹÓÃrpmÃüÁî½øÐа²×°£º
rpm -ivh MySQL ......

Mysql Êý¾Ý¿â×Ö·û¼¯×ª»»¼°°æ±¾Éý¼¶/½µ¼¶µÄÏêϸ½Ì³Ì

¿´µ½²»ÉÙÓû§·´Ó³×ª»»ÍêÒÔºóÊÇÂÒÂëµÄÇé¿ö,³öÏÖÕâÖÖÏÖÏóµÄÖ÷ÒªÔ­ÒòÊÇÕâÀàÓû§Ê¹ÓõͼÊÇmysql4.1ÒÔÉϵİ汾.ÏÂÃæ×÷Ò»¸ö˵Ã÷,Ï£Íû³öÏÖÕâ¸öÎÊÌâµÄÅóÓѶ¼ÄÜÄÍÐĵİÑÕâ¸öÎĵµ¿´Íê!!!
MySQL 4.1¿ªÊ¼£¬¶Ô¶àÓïÑÔµÄÖ§³ÖÓÐÁ˺ܴó±ä»¯ (Õâµ¼ÖÂÁËÎÊÌâµÄ³öÏÖ)¡£¾¡¹Ü´ó²¿·ÖµÄµØ·½ (°üÀ¨¸öÈËʹÓúÍÖ÷»úÌṩÉÌ)£¬MySQL 3¡¢4.0 ÈÔȻռÖ÷µ¼µØ ......

MySQL³£ÓÃÃüÁîÓë»ù±¾ÃüÁî²Ù×÷


1¡¢MySQL³£ÓÃÃüÁî ­
­
create database name; ´´½¨Êý¾Ý¿â ­
­
use databasename; Ñ¡ÔñÊý¾Ý¿â ­
­
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ ­
­
show tables; ÏÔʾ±í ­
­
describe tablename; ±íµÄÏêϸÃèÊö ­
­
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î ­ ......

²»ÒªÊ¹ÓÃһЩmysqlÌØÓеÄtipÀ´Ð´²éѯ

http://immike.net/blog/2007/04/09/how-not-to-optimize-a-mysql-query/
ÕâÆªÎÄÕ½¨Ò飺
£¨1£©²»ÒªÊ¹ÓÃһЩmysqlµÄtip£¬È磺SQL_SMALL_RESULT, HIGH/LOW_PRIORITY, and INSERT DELAYED£¬STRAIGHT_JOIN£¬³ý·ÇûÓÐÆäËû·½·¨£¬ÒòΪÕâÑùʧȥÁËSQLµÄ¿ÉÒÆÖ²ÐÔ
£¨2£©Êʵ±¶Ô±í½øÐÐË÷Òý
£¨3£©±ÜÃâ¶Ô²»±ØÒªÊý¾ÝµÄ²éѯ
£¨4£©´¦Àí× ......

windows2003+iis6+php+mysql ·þÎñÆ÷ÅäÖÃ

ÔÚÍøÉÏ¿´ÁËºÜ¶à¹ØÓÚwindows2003+iis6+php+mysql ·þÎñÆ÷ÅäÖõÄÎÄÕ£¬´óÌåÉ϶¼ÊÇ»¥Ïà³­Ï®£¬²»¹ýһЩ¹«¹²µÄÐÅÏ¢»¹ÊǺÜÕýÈ·µÄ£¬µ«ÊÇÕë¶ÔÒ»Ð©ÌØ±ðµÄ»úÆ÷»òÕßÒòΪ¸öÈ˲»Í¬µÄÅäÖÃ×ܲ»Äܰ´ÕÕÎÄÕµÄÄÚÈݲÙ×÷³É¹¦£¬ÏÂÃæËµÒ»ÖÖ½ÏΪ¼òµ¥µÄ²Ù×÷·½·¨£¬²½ÖèÈçÏ£º
1.iis°²×°£¨ÂÔ£©
2.ÏÂÔØAppServ²¢°²×°
3.ÔÚc:\½¨php5Îļþ¼Ð£¬È»ºóÔÙphp5 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ