_MySQL_List_Tables() Help

[Herb191]

I am having problems getting a list of all the tables in a MySQL database. Any pointers on what I might be doing wrong would be appreciated.

Here is what I have been trying:

#include <Array.au3>
#include "mysql.au3"

_MySQL_InitLibrary()

;connect to MySQL DB
$MysqlConn = _MySQL_Init()
$connected = _MySQL_Real_Connect($MysqlConn, "Localhost", "root", "", "DB_name")
If $connected = 0 Then Exit MsgBox(16, 'Connection Error', _MySQL_Error($MysqlConn))

$query = "SELECT *  FROM *"
_MySQL_Real_Query($MysqlConn, $query)

$res = _MySQL_Store_Result($MysqlConn)

$tables = _MySQL_List_Tables($res)

_ArrayDisplay($tables)

; close the connection
_MySQL_Close($MysqlConn)

; close the library
_MySQL_EndLibrary()

[ProgAndy]

You have mixed two ways of getting all tables.

1)

_MySQL_Real_Query($MysqlConn, "SHOW TABLES")
$res = _MySQL_Store_Result($MysqlConn)
$tables = _MySQL_Fetch_Result_StringArray($res) ; I think, maybe the function name is a bit different
_MySQL_Free_Result($res)
_ArrayDisplay($tables)

2)

$res = _MySQL_List_Tables($MysqlConn)
$tables = _MySQL_Fetch_Result_StringArray($res) ; I think, maybe the function name is a bit different
_MySQL_Free_Result($res)
_ArrayDisplay($tables)

[Herb191]

Thanks ProgAndy. I had tried “SHOW TABLES” but was not using _MySQL_Fetch_Result_StringArray.