按键精灵MySql数据库操作
查询
MySql服务器地址="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