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·ÃÎÊ£¬ºÜ·½±ã {{
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4 mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓᣠ×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£ Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡ mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿ ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ ¿ÉÒÔÓÃÈ ......
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 ......
±í 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 ......