kexi project
Rapid Database Application Development
Development
"Microsoft Access for Linux"

Home Download FAQ Support Features Handbook Screenshots Screencasts Compile Kexi Development Authors Contact License Sponsorship Translate This Site

wiki navigation:

Front Page
[info] [diff] [login]
[recent changes]
[most popular]
You can donate
to Kexi Project:
Via PayPal

Spread the word about Kexi!
Get Kexi Now!

Built on the KDE technology
KDE

Member of the Calligra Suite

No Software Patents!

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)?

^ toc

TODOs

^ toc

Maintainer

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



Kexi - "MS Access for Linux" ... and Windows
© 2002-2007 Kexi Team
This content is available under GFDL
Last edited: August 12, 2005 by js, visited 0 times.