mysql.getDatabaseNames

Retrieve a list of database names from a MySQL server

mysql.getDatabaseNames(dbid)

A database connection ID

A Frontier list containing a list of the databases available on the MySQL server.

on databaseNames () {
	local (id, result, nameList);
	mysql.init();
	try {
		id = mysql.connect("127.0.0.1", "root", "frontier", "frontier", 3306)}
	else {
		dialog.alert(mysql.getErrorMessage(id))};
	nameList = mysql.getDatabaseNames(id);
	dialog.alert(nameList);
	result = mysql.close(id);
	mysql.end();
	return result}
	 » {"information_schema", "frontier", "mysql", "test"}

This is implemented as a script using “SHOW DATABASES” as the query.

• SHOW DATABASES syntax