Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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>µÄÌáʾ·û״̬ÁË¡£¡£¡£
°ÝÍдó¼Ò°ïÎÒ¿´¿´£¬Ð»Ð»~~~~


Ïà¹ØÎÊ´ð£º

ѯÎÊ mysqlµÄÊý¾Ý¿â ¿âÃû³ÆÈçºÎ¸ü¸Ä

ѯÎÊ mysqlµÄÊý¾Ý¿â ¿âÃû³ÆÈçºÎ¸ü¸Ä
£¨±íÃûÊǺܼòµ¥µÄ£©
³¢ÊÔһϱäͨµÄ·½·¨£º

´´½¨Ò»¸öеÄÊý¾Ý¿âÃû³Æ

±¸·ÝÒªÐ޸ĵÄÊý¾Ý¿â£¬°Ñ±¸·ÝµÄÊý¾Ý»¹Ô­µ½Ð½¨µÄÊý¾Ý¿âÖÐ

²»¹ýÕâ¸öʵʱÐÔ²»ºÃ£¬½¨ÒéÔÚÊý¾ ......

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


ÒÔÉ ......

¹ØÓÚTXTÎļþµ¼ÈëMYSQLÎÊÌâ

Ö÷ÒªÇé¿öÈçÏ£º
ÏÖÓÐÒ»Îı¾Êý¾ÝÎļþ£¬ÀïÃæµÄÊý¾ÝÈçÏ£º

abc  123 
def  223  2  wwww
uuu  456  5  xxx
¡­¡­

Êý¾ÝÓм¸wÌõ Ò»ÐÐ×î¶à4ÁÐ µ« ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ