MariaDb (v. 10.4.10) import error (WAMPServer 3.2.0)
Usually happens when importing a huge amount of data to a table with many columns (total data length too large).
Tag: database
Backup tables of mysql server and import to the other server
這邊的使用情況是要把 gcp sql 的 import 到 aliyun 去
定期備份 mysql 資料到其他機器
最理想的方式當然是做 cluster，但是有時候沒這麼理想。
Allow multiple statements in MySQL ODBC
While using MySQL ODBC to execute sql statements, only single sql statement is allowed for execution by default. If you want to execute multiple sql statements at once, you have to enable the multiple statements setting in MySQL ODBC.
C# 建立ODBC DSN 連線到 SQL Server
那個\0很重要。 using System.Runtime.InteropServices; public bool DoDBConnect(string strDSN,string strUID,string strPWD) { try { strConn = “DSN=” + strDSN + “;UID=” + strUID + “;PWD=” + strPWD + “;”; cn = new OdbcConnection(strConn); cmd = new OdbcCommand(); adp = new OdbcDataAdapter(); cmd.CommandType = CommandType.Text; cmd.Connection = cn; } catch { return false; } return true; } [ […]