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

mysql Æô¶¯²»ÆðÀ´

windows xp·þÎñÖÐÆô¶¯mysql 

Ìáʾ±¾µØ¼ÆËã»úÎÞ·¨Æô¶¯mysql·þÎñ

´íÎó3 ϵͳÕÒ²»µ½Ö¸¶¨Â·¾¶

cmdÀïÔËÐÐ

error  2003:Can't  connect  to  MySQL  server  on  'localhost'(10061£©

Ð¶ÔØÁËmysql Îļþ¼ÐɾÁË ×¢²á±íÀïÈýÏîҲɾÁË  ֨װºóµÚÒ»´Î¿ÉÒÔÆô¶¯ ÖØÆôµçÄÔºó¾ÍÆô¶¯²»ÁË

ÊDz»ÊǺÍʲôÈí¼þ³åÍ»  »ú×ÓÉÏÓÐoracle
ÓÐERRÎļþÂ𣬼ì²éÒ»Ñù£¬Ó¦¸ÃÓëORACLEûÓгåÍ»£¬ÎÒÒ²Êǰ²×°ÁËORACLEµÄ£¬Ã»ÓÐÎÊÌâ

È·ÈÏÒ»ÏÂÄãµÄMYSQLÊÇ·ñ°²×°ÍêÕû¡£
ÄãÊÇÈçºÎÆô¶¯µÄ£¿Í¨¹ýwidnowsµÄ·þÎñ¹ÜÀíÆ÷£¿»¹ÊÇͨ¹ýÃüÁ

¿´Ò»Ï·þÎñÖеÄMYSQL·þÎñµÄÃüÁîÊÇʲô£¿ ±ÈÈç "C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.1\my.ini" MySQL

È»ºó¼ì²éÒ»ÏÂÕâЩÏà¹ØµÄÎļþÊÇ·ñ´æÔÚ£¿

¿´Ò»ÏÂÊDz»ÊǶ˿ڱ»Õ¼ÓÃÁË¡£dosÏ£ºnetstat -a

dataÀïÓÐ xinnian-d0207ea.err  Õâ¸öÎļþ

ÎÒÊÇÍêÕû°²×°  ´Ó·þÎñ£¬dos£¬exlipseÀïÆô¶¯¶¼ÊÔ¹ý È«²»ÐÐ

my.iniÀïÅäÖãº

#Path to installation directory. All paths are usually resolved relative to this.
basedir="D:/MySQL/MySQL Server 5.1/"

#Path to the database root
datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"

xinnian-d0207ea.errÎļþÄÚÈÝ


090914 21:20:22 [Note] Plugin 'FEDE


Ïà¹ØÎÊ´ð£º

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

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

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

hibernate mysql ÈÕÎÄ


±í½á¹¹

mysqlÊý¾Ý


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

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

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


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

ÈçºÎÔÚwindows µÄmysql°ÑÊý¾Ý¿â·Åµ½dÅÌ

windows ϰ²×°Ò»¸ömysql £¬×°ÔÚcÅÌ
ÏÖÔÚcÅ̿ռä»ù±¾¿ìûÓÐÁË £¨ºÜ¶àÈí¼þĬÈÏÊÇ×°ÔÚcÅÌ£©

ÏëÖªµÀÈçºÎÔÚwindows µÄmysql
ϰÑÊý¾Ý¿â·Åµ½dÅÌ  £¨linux»áµÄ £¬²»ÖªµÀwinodwsÈçºÎ×÷£©
Ö±½Ó¸´ÖƹýÈ¥¡£ ......

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

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

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

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

´ó¼ÒºÃ£¬ÎÒÔÚÓÃsql´´½¨ÊÓͼµÄʱºò£¬³öÏÖÎÊÌâÁË£¬´úÂëÈçÏ£º

use student_info;
create view results_view as
select r.student_id as ѧºÅ, s.student_name as ÐÕÃû, c.course_name as ¿Î³ÌÃû³Æ, r.res ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ