FrontPage/KexiDBDesign/KexiDBDrivers

MySQL Driver

 notes by jstaniek

Table of Contents    Useful notes      The Server SQL Mode    TODOs    Maintainer

This driver implements most of current KexiDB features.

Useful notes ^ toc

The Server SQL Mode

From the docs: The MySQL server can operate in different SQL modes, and (as of MySQL 4.1) can apply these modes differentially for different clients. This allows an application to tailor server operation to its own requirements.

Modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. This makes it easier to use MySQL in different environments and to use MySQL together with other database servers.

more information...

Idea: we can use SQL modes to be able to use syntax not available in MySQL by default. This prevents a requirement of generating different SQL statements for MySQL compared to other backends.

For example, setting:

 SET SQL_MODE=PIPES_AS_CONCAT

We're able to use || concatenation operator (as in PostgreSQL and SQLite) instead of CONCAT() function.

Problem: Note that some of these modes work for MySQL 4.0 and above, some other for 4.1 or even 5.0. Thus we may need to use version information to know what modes are available. Then, what about older MySQL versions (<4.0)?

TODOs

• We're allowed to use MySQL logo (http://dev.mysql.com/downloads/logos.html) on the web page and/or within Kexi.

Maintainer

The driver was originally developed by many Kexi developers. It has been cleaned up by Martin Ellis (see Contact page).