MySQL Databases (Magic xpa 3.x)
The following topics describe Magic xpa’s functionality when working with MySQL:
MySQL Data Types
Magic xpa Data Types - MySQL
The following is information about working with the MySQL database:
|
Locking
|
No explicit table locks exist in MySQL. Therefore, Share-None and Share-Read have no effect. The underlying database engine itself executes the locking.
|
|
Views
|
You must define a virtual unique index for a View. Insert, Update, and Delete operations are permitted on Views. Magic xpa will display an error message and will not convert or rename the View in the database.
|
|
Direct SQL
|
MySQL cannot be the Result Database in Direct SQL tasks.
|
|
|
The Magic xpa Single User Edition does not support the MySQL database.
|
