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
Ïà¹ØÎĵµ£º
¿´µ½²»ÉÙÓû§·´Ó³×ª»»ÍêÒÔºóÊÇÂÒÂëµÄÇé¿ö,³öÏÖÕâÖÖÏÖÏóµÄÖ÷ÒªÔÒòÊÇÕâÀàÓû§Ê¹ÓõͼÊÇmysql4.1ÒÔÉϵİ汾.ÏÂÃæ×÷Ò»¸ö˵Ã÷,Ï£Íû³öÏÖÕâ¸öÎÊÌâµÄÅóÓѶ¼ÄÜÄÍÐĵİÑÕâ¸öÎĵµ¿´Íê!!!
MySQL 4.1¿ªÊ¼£¬¶Ô¶àÓïÑÔµÄÖ§³ÖÓÐÁ˺ܴó±ä»¯ (Õâµ¼ÖÂÁËÎÊÌâµÄ³öÏÖ)¡£¾¡¹Ü´ó²¿·ÖµÄµØ·½ (°üÀ¨¸öÈËʹÓúÍÖ÷»úÌṩÉÌ)£¬MySQL 3¡¢4.0 ÈÔȻռÖ÷µ¼µØ ......
ÓÉÓÚǰ¶Îʱ¼äÒªÓÃpowerdesignerÉè¼ÆÊý¾Ý¿â£¬¿ÉÊý¾Ý¿âÉè¼ÆºÃºóºÃµ¼ÈëMysQLʱÐèÒªODBCÁ¬½Ó£¬¶øMysQL5.0ÒÔÉϵľùÒªÐÞ¸ÄÃÜÂ루ÎÒÔÚÍøÉϲé¹ý£©£¬°´ËûÃǵÄÒâ˼ÐÞ¸ÄÁËrootÃÜÂ룬½á¹ûÊÇÖ±½Ó½ø²»ÁËMysQLÁË£¬ÎÒÄǸöÓôÃÆ£¬ÔÚÍøÉϲéÕÒ×ÊÁÏ£¬Ò²°´ËûÃǵķ½·¨×öÁË£¬¿É»¹ÊDz»ÐУ¨±¾È˶Ôdos²»Ê죩¡£µ«×îÖÕ»¹ÊÇ¿ÉÒÔÁË£¬ÏÂÃæËµÏ¾ßÌå·½·¨
1¡¢w ......
ÎÊÌâÊÇÕâÑùµÄ£º
Ò»ÕÅtestµÄ±í£¬×Ö·û¼¯²ÉÓõÄlatin1¡£
select to_id from test where to_id='cnÏó_Íõ';
+---------------+
| to_id |
+---------------+
| cnÌÕ_ÌÕ |
| cnÏó_Íõ |
+---------------+
2 rows in set (0.00 sec)
È¡cnÏó_ÍõµÄÊý¾Ý,¾ÓÈ»°ÑcnÌÕ_ÌÕµÄÊý¾ÝҲȡ»ØÀ´ÁË¡£
ÕâÏÔÈ»ÊDz»ÔÊÐíµÄ¡£
......
tomcat °²×°Ä¿Â¼ÏµÄconfĿ¼ÖеÄcontext.xmlÓëweb.xmlÎļþ·Ö±ðÐÞ¸ÄÈçÏ£º
context.xml мÓÈçÏÂÄÚÈÝ£º
<Resource name="jdbc/mysql"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://Êý¾Ý¿âµØÖ·:3306/Êý¾Ý¿âà ......
# MySQL-Front 5.1 (Build 4.2)
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */ ......