mysql Êý¾Ý¿â³ö´í..
ÎÒÔÚphpmyadminϵã»÷Ò»¸ö±íʱ³öÏÖ£º
´íÎó
SQL ²éѯ:
SHOW INDEX from `dcr_news` ;
MySQL ·µ»Ø£º
#1146 - Table 'tuiguang.dcr_news' doesn't exist
Õâ¸ö±íÊÇinnodb ÎÒÔÚ±¾µØÊý¾ÝÎļþÏÂÓУºdcr_news.frm
Ϊʲô»á³öÏÖÕâÑù..
ÎÒÔÙcreate table dcr_news{id int} ʱ ÓÖ˵´æÔÚÕâ¸ö±íÁË..
show tables; ¿´Ò»ÏÂÕâ¸ö±íÓÐûÓС£
ллacmain_chmÏÈ show tablesÓÐÕâ¸ö±í
select * from `dcr_news` ;
ÊÔһϣ¬Èç¹ûÓÐÎÊÌ⣬ֱ½Ó°Ñ´íÎóÌáʾÔÑùÌù³öÀ´
ÎÒÔÚ information_schemaÖÐSELECT * from `TABLES` where table_name='dcr_news' Àï
ºÃ¶àÐÅÏ¢ÊÇNULL
select * from 'dcr_news' ´íÎóÊÇ£º
SQL ²éѯ:
SELECT *
from dcr_news
LIMIT 0 , 30
MySQL ·µ»Ø£º
#1146 - Table 'tuiguang.dcr_news' doesn't exist
ACMAIN_CHM ÄãÕæµÄÊÇÎÒµÄÉñ°¡ лл°¡..
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......