Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example

The CREATE DATABASE statement is used to declare an MySQL database within an Omnidex Environment File. This statement can either be issued directly, or it can be extracted from MySQL using the EXTRACT statement as discussed in the previous section.

The CREATE DATABASE statement must include the database name and the MySQL user and password. Note that the datatype type is ODBC, with a subtype of MYSQL, reflecting that ODBC is the primary method of accessing a MySQL database.

create database                "SIMPLE"
 type                          odbc
 subtype                       mysql
 user                          "simple"
 password                      "simple"
 index_directory               "idx"
 in                            "simple.xml";

Omnidex uses a single user and password to access an MySQL database. MySQL database administrators should provide an appropriate user and password that gives access to all of the database objects referenced in the Omnidex Environment Files.

When connecting to an Omnidex Environment File, it is generally not possible to pass different user and passwords dynamically; however, there is an exception to this rule. The user and password can reference environment variables or shell commands. This can provide a rudimentary mechanism for providing dynamic users and passwords. Care should be taken when using this approach, though. All users passed should have access to all database objects declared in the Omnidex Environment File, and should also have access to all rows in the tables.

Prev | Next

See also: