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 ÄãÕæµÄÊÇÎÒµÄÉñ°¡ лл°¡..
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
Óиöwinform³ÌÐò,ʹÓÃc#+mysql,ÐèÒªÔÚÒ»¸ö´°ÌåÉèÖÃmysql×Ô¶¯É¾³ý¹¦ÄÜ,°üÀ¨×Ô¶¯É¾³ý¶àÉÙÌì֮ǰµÄÊý¾ÝÒÔ¼°ÊÇ·ñ¿ªÆô×Ô¶¯É¾³ý¹¦ÄÜ,ÎÒ³ÌÐòÍ˳öºó,»¹Ôõô¿ØÖÆMysql×Ô¼ºÉ¾³ý°¡?ÊDz»ÊÇÒªÓÃmysqlµÄeventÀ´ÊµÏÖ?c#¿ÉÒÔµ÷ÓÃmysq ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
±í
CREATE TABLE `ch1` (
`id` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
`no` int(10) unsigned DEFAULT NULL,
`dtime` datetime DEFAULT NULL,
PRIMARY KEY (`id ......
PHPÖУ¬Ê¹ÓÃmysqlÊý¾Ý¿â,Linuxϵͳ¡£
ÔÚʹÓÃËÑË÷¹¦ÄÜʱ£¬Ö±½ÓÖ´ÐÐÕâÑùµÄÓï¾ä°²È«Âð£¿
$keyword=$_POST["keyword"];
$sql="select * from abc where a_name like '%$keyword%'";
$rs=mysql_q ......