Auto Increment
Set/Reset the Auto Increment value in the edit field. The Auto Increment Value indicates the value for next record.

Connection
To create the local table that will be federated to the remote table. You can create the local table and specify the connection string (containing the server name, login, password) to be used to connect to the remote table using the Connection edit box.

The CONNECTION string contains the information required to connect to the remote server containing the table that will be used to physically store the data. The connection string specifies the server name, login credentials, port number and database/table information.

The format the connection string is as follows:

scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name

Sample of connection strings:
CONNECTION='mysql://username:password@hostname:port/database/tablename'
CONNECTION='mysql://username@hostname/database/tablename'
CONNECTION='mysql://username:password@hostname/database/tablename'

Note: Support FEDERATED table type only.

Checksum
Check this option if you want MySQL to maintain a live checksum for all rows.

Note: Support MyISAM only.

Delay Key Write
Check this option if you want to delay key updates for the table until the table is closed.

Note: Support MyISAM only.