ÔÚ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»ÊÇÌرðÃ÷°×¡¡ÄܾßÌåµãÂð£¿
¿ÉÒÔÀí½âΪÐÞ¸´±í¹ý³ÌÖвúÉúµÄÈÕÖ¾ÐÅÏ¢
Ïà¹ØÎÊ´ð£º
ÎÒ½¨ÁËÁ½¸ö±í£¬Ò»¸ö±íÃ÷user£¬Ò»¸ö±íanswer
±íuserµÄ½á¹¹{id,username,password}
±íanswerµÄ½á¹¹{A_id,question,answer,U_id}
Çë½Ì´ó¼ÒÎÒÔõôÉèÖòÅÄÜÔÚ±íuser²åÈëÊý¾Ýʱ£¬±íanswer¶ÔÓ¦µÄU_id×Ô¶¯¸üжÔÓ¦± ......
MySQLÃüÁîÊäÈë´íÎóºó,Ö´ÐдíÎóÃüÁî·¢³ö¿ÉŵĽÐÉù
ÔõôÑù½â¾ö???
ÄǽÐÉùÒô¸úÖ¸Õë¶ÁÊý¾Ý¶Á´íÁË,·¢³öÒ»Ñù¿ÉÒÔŵĽÐÉù
¸ãµÄÎÒ²»¸ÒÓÃÃüÁîÐÐ
ºÇºÇ£¡lzÕæ¿É°®£¡
·½·¨Ò»£¬°ÑÄãµÄPCÉϵÄÀ®°È²ð³ý
·½ ......
ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ
ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµ ......
mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ
±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£©
ûÓС£
³ý·ÇÄã×Ô¼º¸ÄдһÏÂ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 '' ......