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

ÇóÖú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µÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html

¾ÍÕÒÒ»±¾ºÜ»ù´ ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

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. ......

mysql µ¼ÖÂËÀ»ú

»·¾³£º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 ......

ÇóÒ»ÌõMySqlÓï¾ä

±ÈÈç±íAÓÐÒ»Ìõ¼Ç¼
ID  Name    Number    GroupId
1    nm1  50493831      6

ID×Ö¶ÎÊDZíAµÄÖ÷¼ü£¬ÓÐ×Ô¶¯Ôö¼ÓµÄÊôÐÔ£¬GroupIdΪÁíÒ»¸ö±íBµÄ ......

mysql update jion ¶à±í ¸ßÊÖÀ´¿´¿´

3¸ö±í

a±í:
aid
ascore
*******************************************

b±í:
bid
bpei

********************************************

c±í:
bid
aid ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ