Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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µÄÅäÖÃÎļþ

ÅäÖÃÎļþ¿ÉÓÃÀ´´æ·ÅһЩ¶à´ÎÓõ½µÄ³£Á¿Êý¾Ý£¬ÈçÁ¬½Ó´®£º
<appSettings>
<add key="connStr1" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="/>
<add key="connStr2" value="App_Data\test.mdb"/>
</appSettings>
Õâ¸öÅäÖÃÊý¾Ý¿âÁ¬½Ó´®
ʹÓÃʾÀý£º
  public class DBCo ......

ASP.NET±à³Ì¹æ·¶Ö®ÃüÃû¹æ·¶Ç³Îö

ASP.NET±à³Ì¹æ·¶Ö®ÃüÃû¹æ·¶¶¼ÓÐÄÄÐ©ÄØ£¿¾ßÌåÓÖÓÐʲôÄÚÈÝÄØ£¿ÈÃÎÒÃÇ¿ªÊ¼°É£º
ASP.NET±à³Ì¹æ·¶Ö®ÃüÃû¹æ·¶1£®°´Å¥IDÃüÃû£º
btn+°´Å¥²Ù×÷¹¦ÄÜ£¨ÈçbtnSave£©
ASP.NET±à³Ì¹æ·¶Ö®ÃüÃû¹æ·¶2£®ÆäËü¿Ø¼þ£º
I£®ÓëÊý¾Ý²Ù×÷Ïà¹Ø£ºÆäID<.SPAN>ΪÏàÓ¦µÄ×Ö¶ÎÃû³Æ£¬Èç¹ûÓжà¸ö¿Ø¼þ¶ÔÓ¦Ò»¸ö×ֶΣ¬Ôò°´ÒÔϹ淶ÃüÃû£º
×Ö¶ÎÃû+&rdqu ......

MySQL FOR LINUX


MySQL FOR LINUX
Ïȼì²éϵͳÊÇ·ñ×°ÉÏÁËmysql£¬Èç¹ûÓн«ÆäÐ¶ÔØµô
rpm -qa | grep mysql
×¢ÒâmysqlµÄ´óСд£¬´óСд¶¼ÓпÉÄÜ
rpm -e --nodeps mysql*
Ò»¶¨ÒªÓÃ--nodepsÐ¶ÔØ£¬²»¼ì²éÒÀÀµÐÔ¹ØÏµ¡£
´´½¨Óû§mysql
groupadd mysql
useradd -g mysql mysql
passwd mysql
ÔÚ/usr/localϽ¨Á¢ mysql Îļþ¼Ð
È»ºó½«°²×°Î ......

LinuxÏÂMySQL¶¨ÆÚ×Ô¶¯±¸·ÝÊý¾Ý¿â

MySQL :: Linux ÏÂ×Ô¶¯±¸·ÝÊý¾Ý¿âµÄ shell ½Å±¾
Linux ·þÎñÆ÷ÉϵijÌÐòÿÌì¶¼ÔÚ¸üРMySQL Êý¾Ý¿â£¬ÓÚÊǾÍÏëÆðдһ¸ö shell ½Å±¾£¬½áºÏ crontab£¬¶¨Ê±±¸·ÝÊý¾Ý¿â¡£Æäʵ·Ç³£¼òµ¥£¬Ö÷Òª¾ÍÊÇʹÓà MySQL ×Ô´øµÄ mysqldump ÃüÁî¡£
½Å±¾ÄÚÈÝÈçÏ£º
#!/bin/sh
# File: /home/mysql/backup.sh
# Database info
......

mysql³£ÓÃSQLÓï¾ä

Ò»¡¢±íµÄµ¼Èëµ¼³öÓï¾ä¼°Ê±¼ä×Ö·û´®²¿·Ö´¦Àíº¯Êý
µ¼³öÊý¾Ý¿âËùÓбíµÄ½á¹¹               mysqldump -uroot -proot db_name -d > d:/export_db.sql(½áβ²»Ó÷ֺÅ)
µ¼³öÊý¾Ý¿âij¸ö±íµÄ½á¹¹               mysqldump -uroot -proot db_n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ