distal-attribute
distal-attribute
distal-attribute
distal-attribute

Copy row[s] or column[s] name [data]

User, date Message
Written by solovejMoney, Euro
2 years ago
Category: General
6 posts since Wed, 12 Oct 11
Hello!

Will be very helpful if you can make possibility to copy selected rows or columns in table.
Sometimes I have task to write columns name, but I cant to copy it, therefore I should to write manually, one by one.
Written by ansgar
2 years ago
4800 posts since Fri, 07 Apr 06
Where do you write? In the query editor I guess. There is a tree node "Columns in <table>" on the very right top, and you can copy names from it, even multiple ones comma separated, you can create INSERT, UPDATE and DELETE query by right click etc.
Written by solovejMoney, Euro
2 years ago
6 posts since Wed, 12 Oct 11
It is good solution, but I write sql query not in Heidisql.
$sql ='SELECT id, address FROM user';
I have many columns and click in every table - little bit uncomfortable.
Written by ansgar
2 years ago
4800 posts since Fri, 07 Apr 06
You are writing PHP code? Well, what do you expect from HeidiSQL if you are not working in HeidiSQL??
Written by solovejMoney, Euro
2 years ago
6 posts since Wed, 12 Oct 11
I did not said "I am not working in HeidiSQL", I work in HeidiSQL everyday. I like it.
Therefore I said which function will be very helpful.
Copy selected column names.
Copy selected row names.

For example:
Table `cars`.
column names:
model,
year,
motor,
fuel,
tyre_size...
so, 200 columns.
Sure I can click 200 times in query tree node... But will be much better if I can to select columns and click one's a time and gets names.
Written by ansgar
2 years ago
4800 posts since Fri, 07 Apr 06
Hm you wrote "I write sql query not in Heidisql", so I thought you are talking about a totally different tool. Anyway.

You can of course select multiple rows by dragging a rectangle over these columns. You do not need to click each of these 200 columns separately.
 

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