mysqlÕÒ²»µ½±í
mysql> use bookstore;
Database changed
mysql> show tables;
+---------------------+
| Tables_in_bookstore |
+---------------------+
| account |
| bookinfo |
| guestbook |
| tuer |
+---------------------+
4 rows in set (0.00 sec)
mysql> select * from tuser;
ERROR 1146 (42S02): Table 'bookstore.tuser' doesn't exist
Ϊʲô¿ÉÒÔÏÔʾ³ö±íÃû£¬µ«ÊÇÓÃselect µÄʱºòÈ´²»ÄÜÕÒ²»µ½±í°¡£¿£¿ ¿àÄÕÐí¾ÃÁË£¬Íû¸÷λ´Í½Ì£¡ ÆäËû±íÊÇÕý³£µÄ,¾Ítuser±íÓÐÎÊÌâ!
¿ÉÄÜtuser±íË𻵣¬Äãrepair table tuserÊÔÊÔ¿´£¡
mysql> repair table tuser;
+-----------------+--------+----------+---------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------+--------+----------+---------------------------------------+
| bookstore.tuser | repair | Error | Table 'bookstore.tuser' doesn't exist |
| bookstore.tuser | repair | error | Corrupt |
Ïà¹ØÎÊ´ð£º
echo %~dp0
CD %~dp0
mysqld.exe --defaults-file=..\my.ini --console
pause
´ó¼Ò¿´¿´ÒÔÉÏbatÎļþµÄÒâ˼£¬Çë´óÏÀ¸ø¸öÏêϸµÄ½âÊͰ¡¡£
ÕâÊÇÆô¶¯mysql·þÎñ°¡¡£
echo %~dp0
ÏÔʾµ±Ç°batËùÔÚĿ¼Ãû
CD %~dp0
......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......