fxmysql: MySQL

A database interface to MySQL open source database.

This interface supports MySQL version 5.0 and above. The database can be downloaded from www.mysql.org.

Connect String

A MySQL connect string, typically specified via a command line option, takes the following form:

-c=<connectString>

where <connectString> contains the MySQL connection parameters. e.g.

-c="user=fred,pwd=itsasecret,host=dbsvr1,database=stores"

Components of the connection string may be separated with , or ;
The connection string may or may not be enclosed within quotes depending on the contents of its components. At a minimum, a user and password is necessary.

To hide any sensitive connection information from prying eyes, an encoded string may be used. The utility fxencode is available for such encoding.

Extensions to Standard Commands

query_tables

query_tables <client_string_array>

Returns the names of all tables that exist in the currently connected database. This list is also selectable by the following command:

iselect * from fxtables

Additional Commands

client_info

client_info

Displays version information for the client side MySQL library.

server_info

server_info

Displays version information for the MySQL Database server that is currently being connected to.

display_types

display_types

Displays the Fire/MySQL data type mappings that are supported.

In addition to the above commands, a number of MySQL utility commands can also be used. For example show tables can be executed, the results can then be fetched into an appropriate fire variable.

SQL Type Translation

The following table gives the mappings between MySQL datatypes and the Eim data which the translator produces to represent them: