Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÈçºÎʵÏÖ¸ßЧµÄËÑË÷£¿

Ò»¸öÐÐÒµÍøÕ¾£¬ÒªÊµÏֵŦÄÜÒªÇóΪ£º

Ò»ËÑË÷±íµ¥¿ÉÑ¡ËÑË÷ ²úÆ·/×ÊѶ/É̼ң¬ËÑË÷ʱϣÍûÏÈËѱêÌâºóÈ«ÎÄ£¬µ±Ç°µÄÊý¾ÝÁ¿¹À¼Æ3Íò¶à£¬¶¨Î»ÆÚÍûÔÚ°ÙÍò¼¶Ò²¿ÉÓá£

Êý¾ÝÀàÐÍΪinnodb£¬µ±Ç°µÄ·½·¨ÊǶԹؼü´Ê½øÐÐ ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

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ÉÏÏÞÎÊÌâ

  ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......

ÇóÒ»ÌõMySqlÓï¾ä

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

ID×Ö¶ÎÊDZíAµÄÖ÷¼ü£¬ÓÐ×Ô¶¯Ôö¼ÓµÄÊôÐÔ£¬GroupIdΪÁíÒ»¸ö±íBµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ