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

½ô¼±ÇóÖú£ºmysql´´½¨ºÍÓ¦ÓÃÊÓͼµÄÎÊÌâ

´ó¼ÒºÃ£¬ÎÒÔÚÓÃ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 courses c on r.course_id=c.course_id;
select * from results_view
where ¿Î³ÌÃû³Æ='¼ÆËã»úÓ¦Óûù´¡'and ³É¼¨ is not null
order by ³É¼¨ desc limit 3;

ÎÒ±£´æΪ8.9.sql,ÔËÐÐÁËһϣ¬³öÏÖ´íÎóÌáʾ£º
      mysql> c:\wamp\www\8.9.sql
      show warnings disabled.
      show warnings disabled.
      error:
      unknown command '\8'
      ->

Õâ¸ö´íÎóÌáʾʲôÒâ˼£¿£¿¶øÇÒ£¬ÎÒûÓа취£¬»Øµ½mysql>µÄÌáʾ·û״̬ÁË¡£¡£¡£
°ÝÍдó¼Ò°ïÎÒ¿´¿´£¬Ð»Ð»~~~~


Ïà¹ØÎÊ´ð£º

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵģ¬¶ÔC ......

url´æÈëmysqlÊý¾Ý¿âÇ°µÄʱºòÒª½øÐÐʲô´¦Àí£¿

SQL code:
UPDATE `footballmatch`.`promote` SET `pr_ballhype` = http://ballhype.com/post/url/?url=http%3A//www.allfootballtv.com/%3Fp%3D369&league=8 WHERE `promote`.`fm_post_id` =369


ÒÔÉ ......

hibernate mysql ÈÕÎÄ


±í½á¹¹

mysqlÊý¾Ý


ÍøÒ³ÏÔʾµÄÊý¾Ý

ÏÖÔÚÎÊÌâ¾ÍÊÇ£¬³ýÁËÖ÷¼üÓÐÖµÍ⣬ÆäËü×Ö¶ÎÈ«²¿Îª¿Õ¡£

ÕâÀïºÍÈÕÎÄÓйØϵ£¬Ï£ÍûÓÐÄÜÓÐÄãµÄ°ïÖú¡£Ð»Ð»


ÓÐʱºòһˢеÄʱºò£¬»¹³öÏÖÕâÖÖÎ ......

mysqlÖжà±í²éѯµÄÎÊÌâ...

ÎÒÓÐ6Õűí
·Ö±ðÊÇ£º
t1,t2,t3,t4,t5,t6
Õâ6ÕÅ±í¶¼ÓиöÏàͬµÄ×Ö¶Îifm
ÎÒÏëͬʱ²éѯÕâ6Õűí....°ÑËùÓеıíÖÐifm=1µÄÐÅÏ¢¶¼µ÷È¡³öÀ´..
SQLÓï¾ä¸ÄÔõôд°¡£¿£¿£¿

ÎÒÊÇÕâÑùдµÄ...µ«ÊÇÖ»ÒªÓÐÒ»¸ö±í ......

mysql°²×°ÎÊÌâ unpacking of archive failed on¡£¡£

linuxϵͳ Ô­À´×Ô´ømysqlÒѾ­Ð¶ÔØ ÐÂװа汾 °²×°Ê±Ìáʾ unpacking of  archive  failed on file usr/bin/ replace 4acebledle4d:cpio :read ÇëÎÊÊÇʲôÎÊÌâ

ÒýÓÃ
ÎļþÊÇÖ»¶ÁµÄ ¸ü¸ÄϸÃĿ¼ȨÏÞΪ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ