.net+MySqlÏîÄ¿ÈçºÎ·¢²¼µ½·þÎñÆ÷£¨ÔÚÏߵȴý£©
ÏÖÔÚÎÒÓÐÒ»¸öСweb³ÌÐò£¬ÎÒÏ뽫Ëü·¢²¼µ½·þÎñÆ÷ÉÏ£¬À´ÊìϤºÍÕÆÎÕÈçºÎÔÚ·þÎñÆ÷Éϲ¿Êð.netÏîÄ¿,Çë´ó¼Ò¶à¶à°ï棬лл£¡
¿ª·¢ÓïÑÔ£ºC#
Êý¾Ý¿â£ºMySql£¨ Server version: 5.0.86£©
Êý¾Ý¿âÇý¶¯£ºMySQL Connector Net 5.2.5
ÏÖÔÚÎÒÒªÔÚ·þÎñÆ÷ÉÏÀ´²¿ÊðËü£¬ÇëÎÊÎÒÒª×öÄÄЩÊ£¿
·þÎñÆ÷µÄ²Ù×÷ϵͳ£¬Ó¦¸ÃÊÇ2000»òÕß2003
ÎÒ¸öÈ˵Ä×ö·¨ÊÇ£º
1.Èç¹ûIIS×°ºÃÁ˾ÍÖ±½Ó×°.NET3.5¿ò¼Ü¡£
2.×°MySqlÊý¾Ý¿â£¬ÉèÖÃÕ˺ÅÃÜÂë¡£
3.ÔÚÏîÄ¿ÖаÑÁ¬½ÓÊý¾Ý¿âµÄ×Ö·û´®ÖеÄÕË»§ÃÜÂë¸Ä³ÉºÍÊý¾Ý¿âµÄÒ»Ö£¬·¢²¼£¬½«Éú³ÉµÄÎļþ¿½±´µ½IISµÄwwwrootÏÂÃæ
ÔÚÎÒ¸öÈË»ú×ÓÉÏ£¬ÎÒÊÇÕâÑù×öµÄ£¬ÇëÎÊÔÚ·þÎñÆ÷ÉÏÒ²ÊÇÒ»ÑùÂð£¬Çë¸÷λ°ï棿
ÖÜÄ©Óä¿ì ÎÒ¾ÍÊÇÅ Õâ¸ö»á³öÏÖʲôÎÊÌâ
ÔÚ·þÎñÆ÷ÉÏ ²»ÖªµÀ¸ÃÔõô×ö
http://blog.oucsoft.com/post/130.html
Õâ¸ö²»ÄѰ¡,°ÑÎļþcopyµ½·þÎñÆ÷ÉÏ£¬Êý¾Ý¿âµ¼Èë¾Í¿ÉÒÔÁË
"°ÑÎļþcopyµ½·þÎñÆ÷ÉÏ" ÕâÑù×ö²»ºÃ°É£¿£¿
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
´ó¼ÒºÃ:
ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......
mysql>create book(
->id varchar(20) not null,g
->
ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷
ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô ......
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ʱ½«Êý¾Ý¿âµÄ×Ö· ......