±í½á¹¹
mysqlÊý¾Ý
ÍøÒ³ÏÔʾµÄÊý¾Ý
ÏÖÔÚÎÊÌâ¾ÍÊÇ£¬³ýÁËÖ÷¼üÓÐÖµÍ⣬ÆäËü×Ö¶ÎÈ«²¿Îª¿Õ¡£
ÕâÀïºÍÈÕÎÄÓйØÏµ£¬Ï£ÍûÓÐÄÜÓÐÄãµÄ°ïÖú¡£Ð»Ð»
ÓÐʱºòһˢеÄʱºò£¬»¹³öÏÖÕâÖÖÎÊÌ⣬һʱ¿ÉÒÔ£¬Ò»Ê±²»ÐС£
ÕâÊÇ´úÂë
½á¹¹ÊÇstruts2+hibernate
²»¿ÉÏÔʾ²»³ö ......
Ö÷ÒªÇé¿öÈçÏ£º
ÏÖÓÐÒ»Îı¾Êý¾ÝÎļþ£¬ÀïÃæµÄÊý¾ÝÈçÏ£º
abc 123
def 223 2 wwww
uuu 456 5 xxx
¡¡
Êý¾ÝÓм¸wÌõ Ò»ÐÐ×î¶à4ÁÐ µ«ÊÇ3£¬4Á½ÐпÉÄÜûÓУ¬Îª¿Õ¸ñ
¹ØÓÚÕâ¸öÎļþ£¬ÎÒÔõôµ¼È룬Çë¸ßÊÖÖ¸µã£¬Ç뾡Á¿Ïêϸ˵Ã÷¡£
......
windows ϰ²×°Ò»¸ömysql £¬×°ÔÚcÅÌ
ÏÖÔÚcÅ̿ռä»ù±¾¿ìûÓÐÁË £¨ºÜ¶àÈí¼þĬÈÏÊÇ×°ÔÚcÅÌ£©
ÏëÖªµÀÈçºÎÔÚwindows µÄmysql
ϰÑÊý¾Ý¿â·Åµ½dÅÌ £¨linux»áµÄ £¬²»ÖªµÀwinodwsÈçºÎ×÷£©
Ö±½Ó¸´ÖƹýÈ¥¡£È»ºó¸ÄÒ»ÏÂÄãµÄ my.ini ÎļþÖеÄÏà¹ØÂ·¾¶£¬±ÈÈçdatadir, basedir µÈ£¬ÄãÔÚÎļþÖÐËÑË÷һϠC: £¬Ïà¹Øµ ......
ÎÒÓÐ6Õűí
·Ö±ðÊÇ£º
t1,t2,t3,t4,t5,t6
Õâ6ÕÅ±í¶¼ÓиöÏàͬµÄ×Ö¶Îifm
ÎÒÏëͬʱ²éѯÕâ6Õűí....°ÑËùÓеıíÖÐifm=1µÄÐÅÏ¢¶¼µ÷È¡³öÀ´..
SQLÓï¾ä¸ÄÔõôд°¡£¿£¿£¿
ÎÒÊÇÕâÑùдµÄ...µ«ÊÇÖ»ÒªÓÐÒ»¸ö±íµÄifm²»µÈÓÚ1£¬ÆäËûËùÓбíµÄÐÅÏ¢¶¼²é²»³öÀ´...
select * from t1,t2,t3,t4,t5,t6 where t1.ifm=t2.ifm=t ......
linuxϵͳ ÔÀ´×Ô´ømysqlÒÑ¾Ð¶ÔØ ÐÂװа汾 °²×°Ê±Ìáʾ unpacking of archive failed on file usr/bin/ replace 4acebledle4d:cpio :read ÇëÎÊÊÇʲôÎÊÌâ
ÒýÓÃ
ÎļþÊÇÖ»¶ÁµÄ ¸ü¸ÄϸÃĿ¼ȨÏÞΪchmod 777
ÇëÎÊÕâ¸ö´íÎóʱʲôÒâ˼ ÊǸÄusr/bin/µÄȨÏÞÂð Õâ¸öÓ¦¸Ã²»ÊÇÖ»¶ÁµÄ°É
......
´ó¼ÒºÃ£¬ÎÒÔÚÓÃsql´´½¨ÊÓͼµÄʱºò£¬³öÏÖÎÊÌâÁË£¬´úÂëÈçÏ£º
use student_info;
create view results_view as
select r.student_id as ѧºÅ, s.student_name as ÐÕÃû, c.course_name as ¿Î³ÌÃû³Æ, r.result as ³É¼¨
from results r inner join students s on r.student_id=s.student_id
inner join cours ......