.NET·ÃÎÊmysqlÎÊÌâ
ͨ¹ýMySQLDriverCS·ÃÎÊmysqlµÄÁÙʱ±íÔõô·ÃÎʵÄѽ
ËÖªµÀѽ£¡°ÝÍС£
Ã²ËÆÒª×°ÉÏmysql È»ºóÌí¼Ó¸ö×é¼þ¶«Î÷²ÅÐÐ ×Ô¼ºÊÔÊÔ
²»Óõİɣ¬Ö»ÒªÔÚÏîÄ¿ÀïÃæÌí¼ÓMySQLDriverCS.dll¾Í¿ÉÒÔÁ˰¡¡£Ö÷ÒªµÄÎÊÌâÊÇÎÒÁ¬½Ó·þÎñÆ÷ºó²éѯһ°ãµÄ±í¿ÉÒÔ²é³öÀ´£¬µ«ÊDzéѯÁÙʱ±í¾Í³ö´í¡£²»ÖªµÀΪʲô
È¥ MySql ÍøÕ¾ÏÂÔØËûÃÇΪ .net ±àдµÄDLL.
´íÔÚÄÄÀï. Èç¹û±¨´íÊÇÊý¾Ý¿âµÄ. ҪôÊÇÓï¾ä²»¶Ô. ҪôÊÇÁÙʱ±íµÄÎÊÌâ. Ó¦¸Ã²»ÊÇMYSQLµÄÎÊÌâ. ±Ï¾¹Ä㶼˵¿ÉÒԲ鵽һ°ãµÄ±íÁË.
µ±È»»¹ÓÐÆäËüºÜ¶àδ֪ÒòËØ.
´íÔÚC# code:
public DataTable GetMailAuditBySqlStrOnlyRead(string sqlStr)
{
MySQLConnection mysqlCon = MysqlConnetion.MysqlConnection(MysqlConnetion.ConnectionString);
MySQLCommand mysqlCom = new MySQLCommand(sqlStr, mysqlCon);
MySQLDataReader mysqlDr;
DataTable returnTable = new DataTable();
returnTable.Columns.Add(new DataColumn("ID", typeof(UInt32))); //Ö÷¼ü
returnTable.Columns.Add(new DataColumn("LOG_TYPE", typeof(string))); //ÀàÐÍ ·¢ËÍ»ò½ÓÊÜ
returnTable.Columns.Add(new DataColumn("APP_PROTOCOL_NAME", typeof(Int32))); //ÐÒéÀàÐÍ
returnTable.Columns.Add(new DataColumn("SOURCE_IP", typeof(UInt32))); //Ô´ip
returnTable.Columns.Add(new DataColumn("DEST_IP", typeof(UInt32))); //Ä¿
Ïà¹ØÎÊ´ð£º
×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
¿ ......
MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï.
ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî
SQL code:
update ±í set introtxt=left(`fulltext`,300);
¶¥£¬Ñ§Ï°
SQL code: ......
ÐèÒªÔÚMySQLÀïÃæÐ´¸ö´¢´æ¹ý³Ì,
·ÃÎÊoracleµÄÊý¾Ý.
Ŀǰ²»ÄÜ
oracle¿ÉÒԾͿÉÒÔÁ¬½Ómysql£¬Í¨¹ýodbc+dblinkÀ´Á¬½Ó
ûÓа취¡£Ä¿Ç°µÄMYSQLµÄ°æ±¾ÖÐÉв»Ö§³ÖÁ¬½Óµ½ÆäËüÊý¾Ý¿â£¬
ÕæÍ¦ÓÐÏë·¨µÄ ĿǰÎÒû×ö¹ý
......