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


Ïà¹ØÎÊ´ð£º

jsp±¸·ÝmysqlÖ»ÓпÕÎļþ

ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......

Winform+MySQL×öÏîÄ¿

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

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

mysqlÃüÁîÐпͻ§¶ËÏÔʾÂÒÂë

mysqlÃüÁîÐпͻ§¶ËÏÔʾÂÒÂë

mysql> select * from userinfo;
+--------+----------+----------+------+-----------+-----------+
| autoid | username | password | sex  | realname  | q ......

hibernate mysql ÈÕÎÄ


±í½á¹¹

mysqlÊý¾Ý


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

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

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


ÓÐʱºòһˢеÄʱºò£¬»¹³öÏÖÕâÖÖÎ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ