1,216
社区成员
发帖
与我相关
我的任务
分享
MYsql = "DRIVER={MySQL ODBC 3.51 Driver};server=" & Trim(txtSQL) & ";
user id=" & Trim(txtUser) & ";password=" & Trim(txtPW) & ";
database=" & Trim(txtDBName)
myconn.Open MYsql
myrecord.Open "select table_name from information_schema.tables
where table_name ='mytable1' and table_schema='"+Trim(txtDBName)+"'", myconn, adOpenStatic, adLockReadOnly
If myrecord.EOF Then
MYsql = "CREATE TABLE mytable1(mydata1 integer (50))"
myconn.Execute MYsql
MsgBox "成功建立", vbInformation
Else
MsgBox "建表失败,表已经存在!"
End If