Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Copying column from one to other table?

Rapid1898's profile image Rapid1898 posted 2 weeks ago in General Permalink

Hello, i want to copy some columns from one table to another table -

So i select some columns in my source-table (right click - copy). And then i want to paste this in my target-table (select column where i want to insert - right click - paste columns) - but all it does is inserting a empty column.

Why is that? Am i doing here something wrong? (or is it not possible to copy a column from one to another table?)

ansgar's profile image ansgar posted 2 weeks ago Permalink

You mean a column from the table designer, or from a data grid?

In the table designer, you can rightclick one or more columns and copy/paste them in the same view of another table:

Description

Rapid1898's profile image Rapid1898 posted 2 weeks ago Permalink

See the attached video - it´s not working for me...

1 attachment(s):
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
ansgar's profile image ansgar posted 2 weeks ago Permalink

Your video shows you are clicking the wrong menu item - click the "copy selected columns" as in my screenshot above.

Rapid1898's profile image Rapid1898 posted 2 weeks ago Permalink

Ok thanks - everythings clear now - it works.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.