MysqlÈý±í²éѯÎÊÌâ
Óöµ½µÄÇé¿öÈçÏÂ
ÓÐÈý¸ö±í..·Ö±ðΪ tt_user,tt_group,tt_config
tt_user ÓÐtt_id,tt_name,tt_check
tt_groupÓÐgg_id
tt_configÓÐcc_id
ÎÒÏÖÔÚµÄÄ¿µÄÊÇ..
Òª´Ótt_userÖвé³öÌõ¼þΪtt_user.tt_id!=tt_group.gg_id and tt_user.tt_check <tt_config.cc_id
³¢ÊÔÓÃÏÂÃæµÄ·½·¨...
select * from tt_user right join (tt_group,tt_config) on (tt_user.tt_id!=tt_group.gg_id and tt_user.tt_check <tt_config.cc_id)
select * from tt_user inner join (tt_group,tt_config) on (tt_user.tt_id!=tt_group.gg_id and tt_user.tt_check <tt_config.cc_id)
²é³öÀ´µÄ½á¹û
×ÜÊÇÓÐÖØ¸´µÄ...
Òâ˼¾ÍÊÇ˵
²é³öÀ´µÄÊÇ..ÏȰ´ÕÕtt_user.tt_id!=tt_group.gg_idÀ´²é...È»ºóÓÖ°´ÕÕtt_user.tt_check <tt_config.cc_id
À´²é
È»ºó½á¹ûµÈÓÚÁ½ÕßÖ®ºÍ...
ÓÐûÓÐÆäËû±È½ÏºÃµÄ..²éѯËÙ¶È¿ìµÄ·½·¨...
Âé·³½éÉÜÒ»ÏÂ....
°¥..±¾ÈËÊDzËÄñÒ»¸ö....
û¿´¶®£¡
½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£
²âÊÔÊý¾ÝÈçÏÂ
tt_user,tt_group,tt_config
tt_user:
tt_id tt_name tt_check
1 a 1
2 b 4
3 c 1
4 &nb
Ïà¹ØÎÊ´ð£º
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ ......
ÎÒÏÖÔÚѧϰMYSQL£¬ÎÊÏÂmysql´¢´æ¹ý³ÌÈçºÎ½¨Á¢ºÍʹÓã¬×îºÃд³É$sql="sqlÓï¾ä",$re=mysql_query($sql);лл
½¨ÒéÄãÏÈ×Ô¼º¿´Ò»ÏÂÎĵµÖеÄÀý×Ó¡£
http://dev.mysql.com/doc/refman/5.1/zh/stored-pro ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......