Mysql 1146´íÎó.
°²×°ÍêMySQLºó,ÎÒ½«ÒÔǰMySQLÀïÊý¾Ý±£´æÁËÏÂÀ´. È»ºóÎÒÖ±½Ó½«Êý¾Ý¸´ÖƵ½DataĿ¼ÏÂ,È»ºóÔÙ·ÃÎÊÀïÃæµÄÊý¾Ýʱ,ÌáʾÎÒ1145´íÎó,ÌáʾÎÒÕÒ²»µ½±í.. ÍøÉϵķ½·¨ÎÒÒѾÕÒ±éÁË,ûÓÐÒ»¸öÄܹ»½â¾öÎÒµ±Ç°µÄÎÊÌâ.. µ±È»,ÎÒÊÇÏëÔÚ²»É¾³ýÔÓÐÊý¾ÝµÄÇé¿öÏÂ,»Ö¸´ÎÒµÄÊý¾Ý.
ʲô²Ù×÷ϵͳ£¿ ÌùÒ»ÏÂÄãµÄ´íÎóÈÕÖ¾ÖеÄÏà¹ØÄÚÈÝ¡£ ¼ì²éÒ»ÏÂĿ¼ȨÏÞ¡£¡¡ ÁíÍâÌùÒ»ÏÂÄãµÄmy.ini /my.cfg #1146 - Table 'crmpro.company' doesn't exist ²Ù×÷ϵͳÕý°æWinXP SP3 AdminȨÏÞ.. show tables; ¿´Ò»ÏÂÕâ¸ö±íÊÇ·ñ´æÔÚ£¿ show create table company ¿´Õâ¸ö±íµÄ´æ´¢ÒýÇæÊÇʲô£¿ ÒýÓà ȻºóÎÒÖ±½Ó½«Êý¾Ý¸´ÖƵ½DataĿ¼Ï Ïêϸ˵Ã÷Ò»ÏÂÄãµÄ¸´ÖƲ½Ö裬¶¼¸´ÖÆÁËÄÄЩÎļþ£¿ Äã°Ñ±¨´íµÄÐÅÏ¢·¢³öÀ´´ó¼Ò¿´¿´ ×ܽáÉÏÃæµÄ»°. ÎÒÔÙÃèÊöµÄÏêϸһµã.. Ê×ÏÈ,ÎÒ°²×°ÁËMySQL5.0. Ö®ºóÀïÃæÄ¬ÈϵıíÊÇ¿ÉÒÔʹÓõÄ,ÎÒ×Ô¼º´´½¨µÄÊý¾Ý¿â,ºÍ±íÒ²ÊÇ¿ÉÒÔʹÓõÄ.. ÏÖÔÚ,ÎÒ´ÓÆäËüµØ·½¸´ÖƹýÀ´Ò»¸öÊý¾Ý¿â,·Åµ½ÁËÏÖÔÚа²×°µÄMySQL5.0°²×°Ä¿Â¼ÏµÄDATAĿ¼ÏÂ, È»ºó,ͨ¹ýRootÓû§µÇ½ºó,¿ÉÒÔ·¢ÏÖ,Êý¾Ý¿âÊÇ´æÔÚµÄ.. µ«ÊÇ,Èç¹û·ÃÎÊÄǸöÊý¾Ý¿âÀïÃæµÄ±í,Ôò»á³öÏÖ#1146 - Table 'crmpro.company' doesn't exist ÍøÉϵÄÄÚÈÝ˵ÊÇMySQL²»Ö§³Ö¸´ÖÆÊý¾Ý¿âÎļþµ½DATAĿ¼ÏÂ. µ«ÎÒÏÖÔÚ²»Ï붪ʧÎÒÒÔǰÊý¾Ý¿âÀïÃæµÄÄÚÈÝ,ÇëÎÊ,ÔõôÑù²ÅÄܹ»ÈÃÀïÃæµÄÊý¾Ý¿â±íµÃÒÔ»Ö¸´,ÈÃËü¼ÌÐøÄܹ»Ê¹ÓÃÄØ? Äã¿ÉÒÔ°ÑÄãÐèÒ
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡ linux? ÔõôдÈëµÄ ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£ ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
Ҫת³ÉÒ»ÑùµÄЧ¹û£¬ÓÃpowerdesignerÔõôת£¿ÄÜתÂ𣿠create table publishers ( publisherID int identity, publisherName varchar (30) NOT NULL, constraint pk_publishers primary key (publisherID) )& ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
´ó¼Ò°ïÎÒ¿´Ï°ɣ¬±¾À´Êý¾Ý¿âûÓж«Î÷£¬ÄÜÏÔʾûÓж«Î÷µÄÐÅÏ¢£¬µ«ÊÇÎÒÌí¼ÓÁËÒ»ÌõÄÚÈݺó£¬×ÖûÁË£¬µ«ÊÇͼƬҲÎÞ·¨ÏÔʾ£¬ºì²æ²æÒ²Ã»ÓУ¬Ôõô»ØÊ°¡£¿ PHP code: <?php $str="select * from product wh ......
ÎÒÔÚÇåÀímysqlµÄʱºò£¬Ò»²»ÁôÉñ½«mysql(¼´dataÀïµÄmysqlÎļþ¼Ð)Êý¾Ý¿â¸øÉ¾µôÁË£¬¸ôÁ˼¸¸öСʱÎÒÖØÆôÁËmysqlÈí¼þ£¬mysql¾Í×Ô¶¯³õʼ»¯ÁËÊý¾Ý¿â£¬µ¼Ö´Óɾ³ýmysqlÎļþ¼Ð¿ªÊ¼µ½ÖØÆôÕâ¶Îʱ¼äµÄÊý¾Ý¶ªÊ§£¬ÄÇλ¸ßÊÖ°ïÏëÏë°ì ......