Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

java »ù´¡ £ºÒ»¶Ô¶àÎÊÌâ

¸÷λ´ó¸ç£º
ÎÒÔÚ±àÒë Ò»¶Ô¶àÎÊÌâÊDZ¨´í£º
ÏëÒªµÄ½á¹ûÊÇ£º

ÄϾ©´óѧ
ÄϾ©´óѧ
|- ѧÉúÐÕÃû£ºÐ¡Íõ ÄêÁ䣺28 ѧУ£ºÄϾ©´óѧ
|- ѧÉúÐÕÃû£º´ó¸ç ÄêÁ䣺36 ѧУ£ºÄϾ©´óѧ
|- ѧÉúÐÕÃû£ººÃÈË ÄêÁ䣺25 ѧУ£ºÄϾ©´óѧ

¿ÉÊdzöÀ´µÄÊÇ£º
ÄϾ©´óѧ
C04.School@5224ee
|- ѧÉúÐÕÃû£ºÐ¡ ......

mysql´íÎó


ÔÚ±¾µØ¼ÆËã»úÎÞ·¨Æô¶¯mysql

´íÎó3£ºÏµÍ³ÕÒ²»µ½ÖªµÀ·¾¶


ÎÒËÑÁËÒ»ÏÂû¿´µ½½â¾öµÄ£¬³ýÁË֨װ£¬µ«ÊÇÄÇÑùÌ«Âé·³£¬¶øÇÒ²»ÖªµÀÔõôµÄÎÒ×ܳöÕâ¸öÎÊÌâ

´ó¼ÒË­°ïæ½â¾öÏÂ
Õâ¸öÎÊÌ⻹ÊÇÖØÐÂ×°°É£¬¿ÉÄÜÊÇÄãɾ³ýÁËmysqlµÄϵͳÎļþ¡£

Õâ¸öÎÊÌâÎÒÓöµ½¹ý ÊÇÒòΪÄãµÄmySql·þÎñËÀÁË£¬É¾³ý·þÎñ £¬È»ºóÖØÐ°² ......

mysqlÁ¬½Ó³¬Ê±

¿ò¼ÜÓõÄÊÇssi
dataSourceÅäÖÃÎļþ
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName">
<value>com.mysql.jdbc.Driver </value>
</p ......

ÔõÑù²é¿´mysqlËùÓÐȨÏÞ

¼ÙÉ赱ǰÓû§Îªroot
show grants Ö»ÄÜÏÔʾrootµÄȨÏÞ£¬ÈçºÎÏÔʾËùÓÐȨÏÞÄØ£¿
ÏÔʾËùÓÐȨÏÞÄØ£¿

ÊÇָʲô£¿ÏÔʾËùÓÐÓû§µÄ£¿

SQL code:
show grants for ÄãµÄÓû§
--±ÈÈ磺
show grants for root@'localhost';

²»ºÃÒâ˼£¬ÎÒ±í´ï´íÎó£¬ÎÒÊÇÏëÏÔʾrootµÄÓû§µÄËùÓÐipµÄȨÏÞ
ÒòΪÎÒ³£³£ÏëÏÂÃæÕâÑù£¬¸øÔ ......

¹ØÓÚMysql´æ´¢¹ý³ÌÖеIJåÈëÓï¾ä

          ÎÒʹÓÃµÄ   MySQL   Connector/NET   6.1.3   Ö´ÐÐÒ»¸ö´æ´¢¹ý³Ì£¬Õâ¸ö´æ´¢¹ý³ÌºÜ¼òµ¥£¬¾ÍÁ½¸öInsertÓï¾ä£¬·Ö±ð°ÑÍⲿ´«ÈëµÄ²ÎÊý²åÈëµ½Á½¸ö±íÖС£
          ½á¹ûÊý¾ÝÊÇ²å½øÈ¥ÁË£¬µ«ÊDzåÈëµÄÊý¾Ý£¬È´Ã»ÓжÔÓ¦Ö¸¶¨µÄÁУ¬Âé·³´ ......

mysql Êý¾Ý¿â³ö´í..

ÎÒÔÚphpmyadminϵã»÷Ò»¸ö±íʱ³öÏÖ£º
´íÎó
SQL ²éѯ: 

SHOW INDEX from `dcr_news` ;


MySQL ·µ»Ø£º

#1146 - Table 'tuiguang.dcr_news' doesn't exist

Õâ¸ö±íÊÇinnodb ÎÒÔÚ±¾µØÊý¾ÝÎļþÏÂÓУºdcr_news.frm
Ϊʲô»á³öÏÖÕâÑù..

ÎÒÔÙcreate table dcr_n ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [1171] [1172] [1173] [1174] 1175 [1176] [1177] [1178] [1179] [1180]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ