Delphi/Kylix

MySQL

Description

coLongPassword

CLIENT_LONG_PASSWORD

New more secure passwords

coFoundRows

CLIENT_FOUND_ROWS

Return the number of found (matched) rows, not the number of affected rows.

coLongFlag

CLIENT_LONG_FLAG

Get all column flags

coConnectWithDB

CLIENT_CONNECT_WITH_DB

One can specify db on connect

coNoSchema

CLIENT_NO_SCHEMA

Don't allow database.table.column

coCompress (see Compression property)

CLIENT_COMPRESS

Use compression protocol.

coODBC

CLIENT_ODBC

The client is an ODBC client. This changes mysqld to be more ODBC-friendly.

coLocalFiles

CLIENT_LOCAL_FILES

Enable LOAD DATA LOCAL handling.

coIgnoreSpace

CLIENT_IGNORE_SPACE

Allow spaces after function names. Makes all functions names reserved words.

coInteractive

CLIENT_INTERACTIVE

Allow interactive_timeout seconds (instead of wait_timeout seconds) of inactivity before closing the connection. The client's session wait_timeout variable will be set to the value of the session interactive_timeout variable.

coSSL

CLIENT_SSL

If you have compiled the MyComponents using the HAVE_SSL directive (see the product.inc file in the source directory) then you will have this option available.  You must now also have the OpenSSL libeay32.dll and ssleay32.dll libraries available to your application and system and may specify the key, ca, etc paths using the Params property of the TMySQLServer.

coIgnoreSigpipe

CLIENT_IGNORE_SIGPIPE

IGNORE sigpipes

coTransactions

CLIENT_TRANSACTIONS

Client knows about transactions

coProtocol41

CLIENT_PROTOCOL_41

New 4.1 protocol

coSecureConnection

CLIENT_SECURE_CONNECTION

New 4.1 authentication

coMultiQueries

CLIENT_MULTI_QUERIES

Tell the server that the client may send multi-row-queries (separated with ';'). If this flag is not set, multi-rowqueries are disabled. New in 4.1.

soAutoCreate

This option differs in that it has nothing to do with the initial connection.  If set to True this will recreate you database and all attached table structures (which also doAutoCreate set) on the MySQL server when the TMySQLServer connects, see CreateDatabase for more info. NOTE: You may wish to disable this option after the database has been recreated successfully, otherwise this create script will be executed everytime the TMySQLServer connects. Because it uses "IF NOT EXISTS" SQL this won't cause any harm, but it is additional work to be done by both your application and the mysql server.

soDropIfExists

If doAutoCreate is enabled and this setting is enabled the compiled sql will be prefixed with a "drop database if exists.." statement. This setting is also used with the CreateDatabase method. WARNING: Be very, very careful with this option, if it is enabled on an existing database and the TMySQLServer is activated, even just at designtime you will lose all tables and data in this database.

soCloseOnChildren

If enabled, this will automatically disconnect the TMySQLServer if and when all children have closed.