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¿·Ö¡£¿´Ãû×ÖÊÇÍêÕûµÄ±íÊý¾Ý¡£ÒýÓà ²»ÖªµÀÄãÏëʵÏÖʲô£¿ ÄãµÄÕ⼸¸ö±íÒ²²»ÊÇ·ÖÇø±íÖе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£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡ ±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿ Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......
CREATE DATABASE ADDRESSLIST; USE ADDRESSLIST; DROP TABLE IF EXISTS FRIEND; CREATE TABLE FRIEND (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY , FRIEND_NAME VARCHAR(20) NOT N ......
ÔÚC++³ÌÐòÖÐͨ¹ýmysqlµÄC APIÖ±½ÓÁ¬½ÓÊý¾Ý¿â£¬µ±°ÑÖÐÎIJåÈëmysqlµÄʱºò£¬¾Í±ä³ÉÂÒÂëÁË. »¹ÓоÍÊÇʹÓÃload°ÑÎı¾Îļþµ¼ÈëmysqlÊý¾Ý¿â£¬ÎÞÂÛÎı¾ÎļþÊÇANSI±àÂ뻹ÊÇutf8±àÂ룬µ¼ÈëÖ®ºó¶¼ÊÇÂÒÂë¡£ ÆäÖÐmysqµÄ±àÂë¸ñʽ ......