·ÖÏíÒ»¸öMysql¸ßЧ±¸·Ý³ÌÐò(´úÂëÈ«¿ªÔ´)
¡°ÈÃMYSQL±¸·Ý¸ü·½±ã¡¢¸ü¸ßЧ¡±ÊÇÎÒÃÇ¿ª·¢µÛ¹ú±¸·ÝÍõµÄ×ÚÖ¼£¬¾¹ý9¸ö°æ±¾µÄ²»¶ÏÉý¼¶ÓëÍêÉÆ£¬µÛ¹ú±¸·ÝÍõ±¸·ÝÊý¾Ý¸ü¼ÓÎȶ¨¡¢¸ßЧ¡¢·½±ã£¬ÌرðÊÇÔÚ´óÊý¾Ý±¸·Ý·½ÃæÐ§Âʸü¼ÓÍ»³ö¡£
µÛ¹ú±¸·ÝÍõ(Empirebak)¼ò½é
EmpireBakÊÇÒ»¿îÍêÈ«¿ªÔ´Ãâ·Ñ¡¢×¨ÃÅΪMYSQL´óÊý¾ÝµÄ±¸·ÝÓëµ¼Èë¶øÉè¼ÆµÄÎȶ¨¸ßЧÈí¼þ,ϵͳ²ÉÓÃ·Ö¾í±¸·ÝÓëµ¼Èë,ÀíÂÛÉϿɱ¸·ÝÈκδóСµÄÊý¾Ý¿â.
µÛ¹ú±¸·ÝÍõ½â¾öMYSQL±¸·ÝÈý´óÄÑÌ⣺
1¡¢½â¾ö±¸·Ý´óÊý¾ÝÎÊÌ⣬²ÉÓ÷Ö×鱸·Ý£¬±¸·ÝÎȶ¨¸ßЧ£»
2¡¢½â¾ö±¸·ÝÊý¾Ý±àÂëÂÒÂëÎÊÌ⣬±¸·ÝÍõÖÇÄÜʶ±ð±àÂ룻
3¡¢½â¾ö²»Í¬MYSQL°æ±¾Êý¾Ý²»ÄÜ»¥µ¼ÎÊÌ⣬ͨ¹ý±¸·ÝÍõ²»´æÔÚÊý¾Ý°æ±¾Çø±ð¡£
µÛ¹ú±¸·ÝÍõ(EmpireBak)Ö÷ÒªÌØÐÔ
1¡¢·Ö×鱸·Ý£¬×¨Îª´óÊý¾Ý±¸·ÝÉè¼Æ
2¡¢²»Í¬MYSQL°æ±¾Æ½»¬×ª»»£¬¿ÉÖ±½Ó±¸·ÝÓë»Ö¸´
3¡¢°²È«ÐÔ
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
SQL code:
create PROCEDURE aa(SqlCMD1 varchar(8000),SqlCMD2 varchar(8000),SqlCMD3 varchar(8000))
begin
declare exit handler for sqlexception rollback;
start TRANSACTION;
EXECUTE SqlCMD1;
EXE ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......