摘要：The tail of the transaction log usually refers to the contents of the database's transaction log that has not been backed up. Basically, every time you perform a transaction log backup, you are backing up the tail of the transaction log.Then why all the fuss over this? Well, the complication sta 阅读全文

摘要：权限问题，授权 给 root 所有sql 权限mysql> grant all privileges on *.* to root@"%" identified by ".";Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;Query OK, 0 rows affected (0.00 sec) 阅读全文

摘要：1. 去下载mysql的ODBC驱动。地址：http://dev.mysql.com/downloads/connector/odbc/3.51.html2. 安装该驱动，一路点next就行，路径都不用选的3. 启动mysql和sqlserver2k4. 从控制面板->性能和维护->管理工具中打开“数据源（ODBC）”（这是分类视图的情况，如果是经典视图，直接从控制面板里打开管理工具），出现ODBC数据源管理器5. 点“添加”按钮，在弹出的对话框里选择“MySQL ODBC 3.51 Driver”，然后点“完成”6. 此时弹出Connector/ODBC配置对话框，填入相关信息之 阅读全文

摘要：同步两个数据库的示例 有数据 srv1.库名..author有字段:id,name,phone, srv2.库名..author有字段:id,name,telphone,adress 要求： srv1.库名..author增加记录则srv1.库名..author记录增加 srv1.库名..author的phone字段更新，则srv1.库名..author对应字段telphone更新 --... 阅读全文

摘要："Provider=Microsoft.jet.oledb.4.0;Jet OLEDB:DataBase password=pwd;Persist Security Info=True;data source=DBPath" 阅读全文

摘要：select * From Orders where OrderTime between #" + start + "# and #" + end + "# 阅读全文