Connection parameter in Tables

I uses Sphinx SearchEngine for indexing tables. The indexing tables have an external connection with Sphinx SE. Here is an example:

CREATE TABLE `app_persons_index` (
`pa_id` bigint(20) unsigned NOT NULL,
`weight` int(11) NOT NULL,
`query` varchar(3072) NOT NULL,
`group_id` int(11) DEFAULT NULL,
KEY `query` (`query`(1024))
) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION='sphinx://localhost:9312/persons';

The only thing that I canont handle through HeidiSQL table interface is Connection parameter. I think that you can add it in Options tab.

Thanks
Costis Papadakis
webmaster@bookworld.gr
webmaster@airpics.net

That ENGINE=SPHINX is plugin based, is it? That's not supported by HeidiSQL.

The CONNECTION parameter is a mysql option, not a Sphinx.

Costis Papadakis

that's true. CONNECTION='...' is a part of the standard mysql CREATE TABLE syntax; only its semantics (and the content of the string following the =) are dependent on the storage engine used.