Export a single column of a MySQL-Table

[Manaug]

Hey dudes

I'm working with MySQL now for more than 2 years and I always used phpMyAdmin, but now I fount SQLyog and it really seems to be much better than phpMyAdmin.

The reason, why I searched for another MySQL-tool is, that I wan't to export a single column of a mysql-table to another database with the same table- and column-structure. There's no possibility to do that with phpMyAdmin.

A friend of mine told me, that SQLyog could do that, but I couldn't find any documentation or any help, that's why I'm posting here.

As I said I have a database online and one offline. They have totally the same structure. But that one offline is more up to date than the database online, but in the database online there are some important infos (in about 600 entries) that I really need.

I think the best way is to export the column with the important infos from the database online to the database offline. But I don't want to lose the datas in the other columns in the database offline.

(Boah really difficult to explain…. If it's not all clear, plz ask!)

Can somebody tell me how I can export only a single column of a table?

I'd be very pleased to get some help!

Thx a lot!

Manaug

PS: Plz excuse my not-so-good english, but I'm a student from Switzerland 😉

[peterlaursen]

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 …

[Manaug]

Thx for this fast answer!

There are always two backups of my databases 😉

I won't risk to loose all these datas….

I'll try to handle the Synchronising Tool.

If I can't handel it, I'll try it with your second idea.

Thx for both of them…. They seem to be useful.

Have to go to school now and write my final examination in latin.

I'll post my success or if it doesn't work….

EDIT: I was successful with your second idea. Thx a lot!

I'm sorry that I opend a new topic….

Delete it, if you want….

Greets

[Author]

Posts