C#Á¬½ÓMYSQL£¬¶ÁÈ¡ÖÐÎÄÎÊÌâ
MySQLConnection DBConn; DBConn = new MySQLConnection(new MySQLConnectionString("localhost" , "admin" , "root" , "123456" , 3306).AsString); DBConn.Open(); MySQLCommand DBComm; DBComm = new MySQLCommand("select * from tb1" , DBConn); MySQLDataReader DBReader = DBComm.ExecuteReaderEx(); try { while (DBReader.Read()) { Console.WriteLine("Host = {0} and User = {1}", DBReader.GetString(0),DBReader.GetString(1)); //×¢£ºDBReader.GetString(0)ÔÚÊý¾Ý¿âÖдæµÄÊÇÖÐÎÄ£¬µ«²éѯ³öÀ´ÊÇ¡®ÂÒÂ롯 ÏÔʾµ½Ò³ÃæÊÇÈ«ÊÇ£¿ Ôõô½â¾öÕâÎÊÌ⣿Êý¾Ý¿â±àÂë¸ñʽûÎÊÌâ(gb2312) ±ð˵ÅäÖÃweb.config£¬ÊÔ¹ýÁË£¬²»¹ÜÓᣠҲ±ð˵±àÂë½âÂ룬¶¼²»¹ÜÓᣠ} } finally { DBReader.Close(); DBConn.Close(); } DBConn.Close();
û»Ø»Ø´ð£¿ Data Source=localhost;Port=3306;User ID=???;Password=????;Initial Catalog=?????;Pooling=true;Allow Zero Datetime=true;charset=gb2312 ÉÏÃæµÄÊÇconnectstring ÎÒ¿ñ¶¥Äã Ö±µ½ÎÊÌâ½â¾öΪֹ ÔÙ¶¥ ÎÒÍùËÀÀï¶¥ÒýÓà Data Source=localhost;Port=3306;User ID=???;Password=????;Initial Catalog=?????;Pooling=true;Allow Zero Datetime=true;charset=gb2312 ÄãÒâ˼ÊÇDBConn = new MySQLConnection(new MySQLConnectionString("localhost" , "admin" , "root"
Ïà¹ØÎÊ´ð£º
//C ½Ó¿Ú extern "C" { TESSDLL_API int __cdecl GetTessText(const char *imagefile, char *text); } //ÎÒÔÚC#ÖÐÉùÃ÷ //µ÷ÓÃC DLL Öеĺ¯Êý [DllImport("OCRapi.dll&quo ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿ now() SQL code: sqlÀïÊÇ£º getdate() ÒýÓà now() ѧϰ SQL code: select now(); SQL code: TODAY() ? SQL code: select now(); /* ......
MYSQL ½ØÈ¡Ò»¸öÊý¾Ý±íÖÐ,ijһ¸ö×Ö¶Î(fulltext) µÄǰÈý°Ù¸ö×Ö·û,·Åµ½¸Ã±íÏÂÁíÒ»¸ö×Ö¶Î(introtxt)Àï. ÇóʵÏÖÕâ¸öЧ¹ûµÄÃüÁî SQL code: update ±í set introtxt=left(`fulltext`,300); ¶¥£¬Ñ§Ï° SQL code: ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from ( SELECT tg.tguildname,c.cid, ( cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......