ÇóÖúosworkflow mysql³Ö¾Ã»¯
´ó¼ÒºÃ
ÎÒÅäÖúÃosworkflowµÄmysql³Ö¾Ã»¯ºó¿ÉÒÔÕý³£ÔËÐÐÁË£¬Ö»ÊÇ»¹Óе㲻Ã÷°×µÄµØ·½£¬Ïë¸÷λָµãÖ¸µãµÄ¡£
ÎÒµÄosworkflow.xmlÅäÖÃÈçÏÂ
XML code:
<persistence class="com.opensymphony.workflow.spi.jdbc.MySQLWorkflowStore">
<property key="datasource" value="jdbc/ce"/>
<property key="entry.sequence" value="SELECT max(id)+1 from OS_WFENTRY"/>
<property key="entry.sequence.increment" value="update os_wfentry set ID=ID limit 1"/>
<property key="entry.sequence.retrieve" value="SELECT max(id)+1 from OS_WFENTRY"/>
<property key="entry.table" value="OS_WFENTRY"/>
<property key="entry.id" value="ID"/>
<property key="entry.name" value="NAME"/>
<property key="entry.state" value="STATE"/>
<property key="step.sequence" value="SELECT max(ID)+1 from OS_STEPIDS"/>
<property key="step.sequence.increment" value="INSERT INTO OS_STEPIDS (ID) values (null)"/>
<property key="step.sequence.retrieve" value="SELECT max(ID) from OS_STEPIDS"/>
<property key=&
Ïà¹ØÎÊ´ð£º
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......
±ÈÈç±íAÓÐÒ»Ìõ¼Ç¼
ID Name Number GroupId
1 nm1 50493831 6
ID×Ö¶ÎÊDZíAµÄÖ÷¼ü£¬ÓÐ×Ô¶¯Ôö¼ÓµÄÊôÐÔ£¬GroupIdΪÁíÒ»¸ö±íBµÄ ......
3¸ö±í
a±í:
aid
ascore
*******************************************
b±í:
bid
bpei
********************************************
c±í:
bid
aid
......