mysql Îļþ¶ÁÈ¡ - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql
ÎÒ¼¸ÕÅmysql±í ·ÖÇø
È»ºó°Ñ·ÖÇø±íµ¥¶À¿½³öÀ´
ÀýÈ磺test.MYD test.MYI data.MYD data.MYI user.MYD user.MYI dem.MYD dem.MYI
ÎÒÏë¶ÁÈ¡ÕâËÄÕűíµÄÄÚÈÝ
¹ØÁªÊý¾ÝÕûºÏµ½Ò»ÕűíÖС£Õâ¸öÒªÔõô×öÄØ
ÓóÌÐòÔõôÀ´ÊµÏÖÄØ£¿
(ÓÃmysqlµÄapi£¿ËÓÃC++µÄ£¬ÄÜÌṩµãÀý×Ó×îºÃÁË)
ר¼Ò ¸ßÊÖ ÓÐ×öµÄ ÅóÓÑÃÇ Ö¸µãÏÂ
http://dev.mysql.com/doc/refman/5.1/zh/apis.html#libmysqld
±ðÈËÌṩµÄÎĵµ ¿ÉÊÇ¿´µÄ²»Ã÷°×
²»ÖªµÀÄãÏëʵÏÖʲô£¿
ÄãµÄÕ⼸¸ö±íÒ²²»ÊÇ·ÖÇø±íÖеIJ¿·Ö¡£¿´Ãû×ÖÊÇÍêÕûµÄ±íÊý¾Ý¡£
ʵÏÖµÄģʽÈçÏÂ
ÎÒËÄÕÅ±í ¶¼ÊÇÓ÷ÖÇøµÄ
ÎÒ°ÑËÄÖÖ±íµÄ·ÖÇøÎļþ¿½³öÀ´ ±ÈÈçÊÇtest#P#p0.myd test#P#p0.myi user#P#p0.myd user#P#p0.myi data#P#p0.myd data#P#p0.myi dem#P#p0.myd dem#P#p0.myi
²»Òªµ¼Èëmysql È¥²é¿´(Õâ¸öÊÇ¿ÉÒԲ鿴µÄ)
¶øÊÇÏëÖ±½Óµ÷ÓÃmysqlµÄapiÈ¥¶ÁÈ¡ËüµÄÄÚÈÝ È»ºó°ÑËÄÕűíÄÚÈݸø¹ØÁªÆðÀ´
Õûµ½Ò»Õűí
ʵÏÖµÄģʽÈçÏÂ
ÎÒËÄÕÅ±í ¶¼ÊÇÓ÷ÖÇøµÄ
ÎÒ°ÑËÄÖÖ±íµÄ·ÖÇøÎļþ¿½³öÀ´ ±ÈÈçÊÇtest#P#p0.myd test#P#p0.myi user#P#p0.myd user#P#p0.myi data#P#p0.myd data#P#p0.myi dem#P#p0.myd dem#P#p0.myi
²»Òªµ¼Èëmysql È¥²é¿´(Õâ¸öÊÇ¿ÉÒԲ鿴µÄ)
¶øÊÇÏëÖ±½Óµ÷ÓÃmysqlµÄapiÈ¥¶ÁÈ¡ËüµÄÄÚÈÝ È»ºó°ÑËÄÕűíÄÚÈݸø¹ØÁªÆðÀ´
Õûµ½Ò»Õűí
»è£¬ÄãÊÇ˵³ÌÐò·ÃÎʰɣ¿myconnector£¿mysql++¶¼¿ÉÒÔ°¡£¬otlÀïÃæÒ²·â×°ÁËmysqlµÄodbc·ÃÎÊ£¬ºÜ·½±ã
{{
Ïà¹ØÎÊ´ð£º
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
mysqlÊý¾Ý¿âµÄ±àÂë¸ñʽÊÇutf8
ÔÚc++³ÌÐòÖÐʹÓÃC APIÖ±½ÓÁ¬½ÓmysqlÊý¾Ý¿â£¬°ÑÖÐÎı£´æµ½mysqlÊý¾Ý¿âÖУ¬ÖÐÎç±ä³ÉÂÒÂë
ʹÓÃmysqlµÄloadÃüÁîµ¼ÈëÎı¾Îļþ£¬ÎÞÂÛÎı¾ÎļþÊÇANSI»¹ÊÇutf8±àÂ룬¶¼ÊÇÂÒÂë
ÇëÎÊÉÏÃæÁ½¸öÎÊ ......
PHPCMSÆóÒµ»ÆÒ³2008·ÖÒ³ÎÊÌâ
ÎÒÓÃÒÔÏ·½Ê½Ç󯽾ùÊý
{get sql="SELECT DISTINCT c.*,
(select round(avg(sort1)) from `phpcms_yp_dp` where userid=c.userid) avgsort1,
(select round(avg(avgp ......
ÈçÌâ¡£ÎÒÒѾ°²×°ÁËmysqlodbcÇý¶¯¡£
adodc¿Ø¼þÊôÐÔÀïÃæ£¬Á¬½Ó×ÊÔ´£¬
ÓÐ
ʹÓÃDataLinkÎļþ
ʹÓÃODBCÊý¾Ý×ÊÔ´Ãû³Æ
ʹÓÃÁ¬½Ó×Ö·û´®
ÊÇÑ¡ÔñÄĸö£¿
È»ºóµÃ²½ÖèÊÇÔõôÑùµÄ£¿
HTML code:
http://www.connectionst ......