Tables with extrenal connection

Hi there!

I use SphinxSE in my database and I have created a table with external connection with Sphinx. The command SHOW CREATE TABLE seems to generate the correct sql statement.

CREATE TABLE `app_phrases_index` (
`phrase_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/books'

The HeidiSQL seems to lose the CONNECTION parameter.

Thanks
Costis Papadakis

Where exactly doese HeidiSQL lose that CONNECTION clause? Afte pressing "Save" in a modified table structure or after exporting that table or...?

On "CREATE code" tab the CONNECTION parameter is missing. Also, there is no reference in any tab about external connection.

Costis Papadakis

Does that CONNECTION value show up in the result of such a query?

SHOW TABLE STATUS LIKE 'app_phrases_index'

No, it doesn't. :(

So that will be difficult. HeidiSQL relies on the SHOW TABLE STATUS output in MySQL mode.