.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 ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£
µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ
È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......