Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQL£¨asp.net£© ÊÂÎñ

 try
        {
            string _conStr = "Driver={MySQL ODBC 3.51
Driver};server=localhost;database=test;uid=test;password=1;option=3";
            OdbcConnection _odbcCon = new OdbcConnection(_conStr);
            _odbcCon.Open();
            OdbcTransaction trans = _odbcCon.BeginTransaction
(IsolationLevel.ReadCommitted);
            OdbcCommand cmd = new OdbcCommand();
            cmd.Connection = trans.Connection;
            cmd.Transaction = trans;
            string _sqlStr = "";
          
            try
            {
                _sqlStr = "update  test ....."
              
                cmd.CommandText = _sqlStr;
                cmd.ExecuteNonQuery();
                _sqlStr = "";
            }
            catch
            {
      &n


Ïà¹ØÎĵµ£º

asp.netÓû§ASPNETµÇ¼ʧ°ÜµÄÎÊÌâ

¡¡Ö´Ðе±Ç° Web ÇëÇóÆÚ¼ä£¬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£
¡¡¡¡Òì³£ÏêϸÐÅÏ¢: System.Data.SqlClient.SqlException: Óû§ 'XXXASPNET' µÇ¼ʧ°Ü¡£
¡¡¡¡½ñÌì½«ÍøÕ¾Ç¨ÒÆ¹ýÀ´ºó,¾Í·¢ÏÖÕâ¸öÎÊÌâ.¾­¹ýÃþË÷,·¢ÏÖÔ­ÒòÊÇÎÒÃǵǼÊý¾Ý¿âµÄ½ÇÉ«¶ÔÊý¾Ý¿âµÄȨÏÞ²»¹». ......

MySQLÖÐInnoDBºÍMyISAMµÄ²î±ð

InnoDBºÍMyISAMÊÇÔÚʹÓÃMySQL×î³£ÓõÄÁ½¸ö±íÀàÐÍ£¬¸÷ÓÐÓÅȱµã£¬ÊÓ¾ßÌåÓ¦Óöø¶¨¡£ÏÂÃæÊÇÒÑÖªµÄÁ½ÕßÖ®¼äµÄ²î±ð£¬½ö¹©²Î¿¼¡£
innodb 
      InnoDB ¸ø MySQL ÌṩÁ˾ßÓÐÊÂÎñ(commit)¡¢»Ø¹ö(rollback)ºÍ±ÀÀ£ÐÞ¸´ÄÜÁ¦(crash recovery capabilities)µÄÊÂÎñ°²È«(transaction-safe (ACID complian ......

MYSQLÔÚWindows 2003ÉÏÁ¬½Ó²»ÉϵĽâ¾ö·½·¨

½ñÌì´î½¨mysqlÊý¾Ý¿â,Á¬½ÓÁ˰ëÌì,¶¼Ìáʾ10061´íÎó,ÒÔΪÃÜÂë³öÁËÎÊÌâÊÔÁ˰ëÌì,ѹ¸ùÁ¬·þÎñ¶¼Á¬½Ó²»ÉÏ,æ»îÁ˰ë¸ö¶àСʱ,²Å·¢ÏÖÊÇϵͳ²¹¶¡´òÁËÖ®ºó³öÏÖµÄÎÊÌâ(kb967723)
ÓÚÊÇÍøÉÏÕÒÁËÒ»ÏÂ×ÊÁÏ
×î½üÒ»¸ö¿Í»§·þÎñÆ÷µÄMYSQLƵ·±ÌáʾÁ¬½Ó²»ÉÏ£¬ÐÞ¸ÄÁËMYSQLµÄ×î´óÁ¬½ÓÊý»¹ÊÇÕâÑù£¬ÓÚÊÇ¿ªÊ¼ÎÊÍòÄܵÄËÑË÷ÒýÇæ´óÈË£¡ÖÕÓÚÔÚ΢ÈíÕÒµ½ÁË ......

mysql ÃüÁî

1¡¢MySQL³£ÓÃÃüÁî
create database name; ´´½¨Êý¾Ý¿â
use databasename; Ñ¡ÔñÊý¾Ý¿â
drop database name Ö±½Óɾ³ýÊý¾Ý¿â£¬²»ÌáÐÑ
show tables; ÏÔʾ±í
describe tablename; ±íµÄÏêϸÃèÊö
select ÖмÓÉÏdistinctÈ¥³ýÖØ¸´×Ö¶Î
mysqladmin drop databasename ɾ³ýÊý¾Ý¿âǰ£¬ÓÐÌáʾ¡£
ÏÔʾµ±Ç°mysql°æ±¾ºÍµ±Ç°È ......

ʹÓÃC3P0Á¬½ÓMysqlµÄÒ»¸öÎÊÌâµÄ½â¾ö¹ý³Ì


×î½üµÄÒ»¸öÏîÄ¿ÔÚʹÓÃC3P0µÄÁ¬½Ó³Ø£¬Êý¾Ý¿âΪMysql¡£¿ª·¢²âÊÔûÓÐÎÊÌ⣬ÔÚÔËÐÐÖÐÿ¸öÒ»¶Î³¤µÄ¿ÕÏÐʱ¼ä¾Í³öÏÖÒì³£Communications link failure due to underlying exception:
java ´úÂë
²é¿´ÁËMysqlµÄÎĵµ£¬ÒÔ¼°Connector/JµÄÎĵµÒÔ¼°ÔÚÏß˵Ã÷·¢ÏÖ£¬³öÏÖÕâÖÖÒì³£µÄÔ­ÒòÊÇ£º
Mysql·þÎñÆ÷ĬÈϵēwait_timeout&rdquo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ