Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿â·þÎñÆ÷ÉÏÏßǰµÄÒÉÎÊ

ÈÕIPÊýǧ ÒÔºó»áÉÏÍò Ò²ÊÇflex+javaÓÎÏ·ÀàÐ͵ÄÍøÕ¾ ¼¯ÖÐÔڸ߷åÆÚÍíÉÏ
  ÇëÎÊÊý¾Ý¿â·þÎñÆ÷µÄ»úÆ÷ÓÃÊ²Ã´Æ·ÅÆºÃ£¿ÍƼöÒ»¸öÅäÖã¿


ÏÖÔÚÊý¾Ý¿âÊÇʹÓÃmysql5.0 ÊDz»ÊÇÊʺϣ¿ ¸Ã²»¸Ã»»³ÉOralce(ÏÖÔÚ»»»¹ ......

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

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

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

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

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

Á¬½ÓMySQLʱUnknown columnÎÊÌ⣬Çó¸ßÊÖ½â´ð

import java.sql.*;

public class A
{
public static void main(String[] args)
{
try
{
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost ......

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

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

ÎÒÊÇÕâÑùдµÄ...µ«ÊÇÖ»ÒªÓÐÒ»¸ö±í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ