Try to have a look at the tool “syncronization wizard” (Power tools .. database syncronization wizard) It can do a “two-way syncronization”. It does not “export only a single column of a table” but maybe you can still use it ??
but PLEASE PLEASE PLEASE:
read the inline help and read some posts in the forum about “Data Synchronization and SQLyog Job Agent” and understand how it works. And backup your tables before experimenting with it! You must still define one DB as the “source” and another as the “target” You must have an identical Primary Key in the tables, and in case of conflicting Primary Keys (and only then) data from the “source” will overwrite the target.
the answer to your original question
Quote:
Can somebody tell me how I can export only a single column of a table?
is hard to ansvwer. Export to where ?? But maybe just use a simple INSERT … SELECT statement where you SELECT from existing tabel and INSERT It to new rows a an identical table.
syntax:
INSERT [LOW_PRIORITY | DELAYED] [IGNORE]
[INTO] tbl_name [(col_name,…)]
SELECT …
