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 ÄãÕæµÄÊÇÎÒµÄÉñ°¡ лл°¡..
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
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: ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË.
»¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£
ÆäÖÐmysqµÄ±àÂë¸ñʽ ......