Interested in improving this site? Please check the To Do page.

Back to MySQL Verbs

mysql.getFieldNames

Retrieve a list of field names from the specified table

Syntax

mysql.getFieldNames(dbid, tableName)

Params

A database connection ID

Returns

A Frontier list containing a list of fields in the specified table

Examples

dialog.alert(getFieldNames(id, "names"))
	 ยป {"name", "occupation", "floating"}

Notes

This is implemented as a script using the “SHOW COLUMNS” SQL syntax

See Also


Personal Tools