Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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×Ô¶¯¸üжÔÓ¦± ......

MySQL·¢³ö½ÐÉù

MySQLÃüÁîÊäÈë´íÎóºó,Ö´ÐдíÎóÃüÁî·¢³ö¿ÉŵĽÐÉù
ÔõôÑù½â¾ö???
ÄǽÐÉùÒô¸úÖ¸Õë¶ÁÊý¾Ý¶Á´íÁË,·¢³öÒ»Ñù¿ÉÒÔŵĽÐÉù
¸ãµÄÎÒ²»¸ÒÓÃÃüÁîÐÐ


ºÇºÇ£¡lzÕæ¿É°®£¡

·½·¨Ò»£¬°ÑÄãµÄPCÉϵÄÀ®°È²ð³ý
·½ ......

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

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

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

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£©

ûÓС£

³ý·ÇÄã×Ô¼º¸ÄдһÏÂMYSQLµÄÔ´´úÂëÈ»ºó±àÒëÔËÐС£

½èÖúÆäËûÓïÑÔ

Ä¿Ç°µÄmysqlÀïÃæÏÖ³ÉÕâÑùµÄ¹¦ÄÜ¡£ ......

MySQL´´½¨´æ´¢¹ý³Ì³ö´í

ÔÚMySQL5.0Öд¬½¢´æ´¢¹ý³Ìͨ²»¹ý£¬Ìáʾ£º
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ