按键精灵MySql数据库操作
时间：2021-07-01 10:21:17
帮助过：415人阅读
192.168.1.166"
用户名 =
"root"
密码 =
"123"
数据库名=
"bookshop"
端口号=
"3306"
MySql句柄 =
Plugin.Super_MySQL.mysql_connect(MySql服务器地址, 用户名, 密码, 数据库名, 端口号)
sql语句 =
"select * from users"
返回=
Plugin.Super_MySQL.mysql_query(MySql句柄,sql语句)
记录集句柄 =
Plugin.Super_MySQL.store_result(MySql句柄)
rows =
Plugin.Super_MySQL.num_rows(记录集句柄)
For i =
1 To rows
//读字段
username=Plugin.Super_MySQL.fetch_text(记录集句柄,
"username")
//读字段
pass = Plugin.Super_MySQL.fetch_text(记录集句柄,
"pass")
TracePrint username&
","&
pass
//下一行
Plugin.Super_MySQL.row_next 记录集句柄
Next
按键精灵MySql数据库操作
标签：nbsp cep 服务器 select super 字段 按键 col store
