ÇóÒ»ÌõsqlÓï¾ä£¬Ë³±ãÉ¢·Ö
ÏÈÓÐÈçÏÂÈýÕűí
µÚÒ»ÕűíΪrole£¨½ÇÉ«±í£©×Ö¶ÎÈçÏÂ
id name£¨ÐÕÃû£© sex£¨ÐԱ𣩠grade£¨½ÇÉ«µÈ¼¶µÈ¼¶£©
1 ÕÅÈý 1 1
2 ÀîËÄ 1 15
3 ÍõÎå 1 10
µÚ¶þÕűíΪtask£¨ÈÎÎñ±í£© ×Ö¶ÎÈçÏÂ
id title£¨ÈÎÎñÃû³Æ£© grade£¨ÈÎÎñµÈ¼¶£©
1 ²¶Óã 10
2 ÉÏɽ´òÍÃ×Ó 2
3 ¸øÄ³ÈËËͶ«Î÷ 5
µÚÈýÕűíΪrole_task(½ÇÉ«ÈÎÎñ±í) ×Ö¶ÎÈçÏÂ
role_id task_id state(״̬) ÆäÖÐ0±íʾδÍê³É 3±íʾÍê³É
1 1 0(δÍê³É)
1 2 3(Íê³É)
1 3 3
2 1 3
2 2 0
3 1 3
3 &nbs
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......