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

mysqlÖÐ repair table

ÔÚmysqlÖÐrepair table xxxxx;Ìáʾ

mysql> repair table recordTbl;
+-----------------+--------+----------+----------------------------------------------+
| Table          | Op    | Msg_type | Msg_text                                    |
+-----------------+--------+----------+----------------------------------------------+
| xxxxx          | repair | error    | 28 when fixing table                        |
| xxxxx          | repair | warning  | Number of rows changed from 328959 to 536475 |
| xxxxx          | repair | status  | OK                                          |
+-----------------+--------+----------+----------------------------------------------+
3 rows in set (1 min 39.06 sec)

ǰ2ÐÐʲôÒâ˼ лл£¡
µÚÒ»ÐÐÖ»ÊDZ¨´í¡£
µÚ¶þÐУ¬ÊÇ×ÜÐÐÊý²¹ÐÞ¸ÄÁË¡£
µÚÈýÐУ¬Ó¦¸ÃÊÇOKÁË¡£ÐÞ¸´³É¹¦¡£

Ò»¸öerror
Ò»¸ö¾¯¸æ
Ò»¸öok

show warnings
show errors
¿ÉÒÔ¿´¿´

»¹ÊDz»ÊÇÌØ±ðÃ÷°×¡¡ÄܾßÌåµãÂð£¿

¿ÉÒÔÀí½âΪÐÞ¸´±í¹ý³ÌÖвúÉúµÄÈÕÖ¾ÐÅÏ¢


Ïà¹ØÎÊ´ð£º

MySQLÊý¾Ý¿â¹ØÁªµÄÎÊÌâ

ÎÒ½¨ÁËÁ½¸ö±í£¬Ò»¸ö±íÃ÷user£¬Ò»¸ö±íanswer
±íuserµÄ½á¹¹{id,username,password}
±íanswerµÄ½á¹¹{A_id,question,answer,U_id}
Çë½Ì´ó¼ÒÎÒÔõôÉèÖòÅÄÜÔÚ±íuser²åÈëÊý¾Ýʱ£¬±íanswer¶ÔÓ¦µÄU_id×Ô¶¯¸üжÔÓ¦± ......

C#¶ÁÈ¡mysqlÊý¾Ý¿âÎÊÌâ

ÎÒʹÓÃC#Á¬½ÓmysqlÊý¾Ý¿â¶ÁÈ¡ÆäÖеÄÊý¾Ý£¬
¶ÁÈ¡Êý¾Ý±íÖеÄVarcharÀàÐ͵ÄÊý¾Ý£¬Èç¹ûÊÇÓ¢ÎÄÄܹ»Õý³£¶ÁÈ¡³öÀ´£¬
¶øÈç¹ûÊÇÖÐÎÄ£¬¾Í»áÏÔʾΪ¡°£¿£¿¡±£¬

Èç¹û°ÑvarcharÀàÐÍ»»³ÉbinaryÀàÐÍ£¬Asp.net³ÌÐòÄܹ»Õý ......

Á½Ì¨Mysql·þÎñÆ÷£¬Êý¾Ýͬ²½

ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ

ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµ ......

´óÏÀÃǾÈÃü°¡:MysqlµÄmy.iniÎļþ¸ü¸ÄÊý¾Ý¿â·¾¶ÎÊÌâ

  ÎÒ°²×°ºÃmysqlºó,ĬÈϵÄÊý¾Ý¿â·¾¶ÊÇÔÚCÅÌÏÂ,ÎÒÏë°ÑËü¸Äµ½EÅÌÀï: ÎÒÏȰÑmysql·þÎñÍ£Ö¹,ÔÙÔÚmysql°²×°Ä¿Â¼(Ò²ÊÇÔÚEÅÌ)ÏÂÕÒµ½my.iniÎļþ,¾Í¸ÄÁËÏÂÃæÄÇô¶à:
#Path to the database root
datadir="E ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ