Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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»ÊÇÌØ±ðÃ÷°×¡¡ÄܾßÌåµãÂð£¿

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


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

Mysql²éѯÎÊÌâ¡£¡£¡£

  ÎÒÏëÔÚmysqlÖн«t_flow_card_detail±íÖеÄclient_id×ֶθÄΪÍâ¼ü£¬ÒýÓÃt_client±íÖеÄclient_id×ֶΣº
  ÎÒµÄsqlÓï¾äÊÇ£º alter table t_flow_card_detail add constraint FK_flowcard_client foreig ......

¹ØÓÚMySQLµÄ²éѯ½á¹û

´úÂëÈçÏ£º
$sql = "select count(*) from admin";
$result = mysql_query($sql);
$num=mysql_num_rows($result);
echo $num;
Ϊʲô²»¹ÜÎҵļǼÓжàÉÙÌõ£¬¶¼ÊÇÊä³ö1£¬
ÎÒÏëÊä³ö²éѯµÄ ......

mysqlÐÞ¸ÄÃÜÂëÎÊÌâ

ÎÊÌâÊÇÕâÑùµÄ£¬ÏÖÔÚÓиöÓû§mysql ÃÜÂëΪ¿Õ£¬È»ºóÎÒÏȰÑËü¸Ä³É123£¬ÕâÑùдΪʲô²»ÄܸÄmysqladmin -u mysql password 123£¬½á¹û³öÏÖmysqladmin: Can't turn off logging; error: 'Access denied; you need t ......

mysql:´´½¨Ë÷Òý³ö´í

´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º

create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;

±£´æÎªindex ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ