易语言mysql数据库表格读取数据

库函数 调用DLL("libmysql.dll", "mysql_init", "","","","")
库函数 调用DLL("libmysql.dll", "mysql_real_connect", "","","","","","","")
库函数 调用DLL("libmysql.dll", "mysql_query", "","","","")
库函数 调用DLL("libmysql.dll", "mysql_store_result", "","","","")
库函数 调用DLL("libmysql.dll", "mysql_fetch_row", "","","","")
库函数 调用DLL("libmysql.dll", "mysql_num_fields", "","","","")

变量 mysqlHost 字符串 = "数据库地址"
变量 mysqlPort 整数 = 数据库端口
变量 mysqlUser 字符串 = "用户名"
变量 mysqlPassword 字符串 = "密码"
变量 mysqlDatabase 字符串 = "数据库名"
变量 sqlQuery 字符串 = "SELECT * FROM 表名"

变量 mysql_conn = 调用DLL函数("libmysql.dll", "mysql_init",0,0,0,0)

调用DLL函数("libmysql.dll", "mysql_real_connect", mysql_conn, mysqlHost, mysqlUser, mysqlPassword, mysqlDatabase, mysqlPort, 0,0)
调用DLL函数("libmysql.dll", "mysql_query", mysql_conn, sqlQuery, 0, 0)

变量 mysql_result = 调用DLL函数("libmysql.dll", "mysql_store_result", mysql_conn, 0, 0, 0)

变量 num_fields = 调用DLL函数("libmysql.dll", "mysql_num_fields", mysql_result, 0, 0, 0)
循环 变量 i 从 0 到 num_fields-1
    输出 "字段名：" + 调用DLL函数("libmysql.dll", "mysql_fetch_field_direct", mysql_result, i, 0, 0)
结束循环

输出 "查询结果："
变量 row
循环 当 不等于0
    变量 row = 调用DLL函数("libmysql.dll", "mysql_fetch_row", mysql_result, 0, 0, 0)
    输出 调用DLL函数("libmysql.dll", "mysql_fetch_row", mysql_result, 0, 0, 0)
结束循环

调用DLL函数("libmysql.dll", "mysql_free_result", mysql_result, 0, 0, 0)
调用DLL函数("libmysql.dll", "mysql_close", mysql_conn, 0, 0, 0)