Possibility To Copy All Column Names?

[bitseeker]

Hi there,

is there any possibility to copy all column names from a table to insert them in query editor?

Right now i´m using the 'Paste SQL Statments' and delete the unwanted statements to just get the column names.

thx bitseeker

[peterlaursen]

No. But you can double-click on anything in the Object Browser and it will insert to the editor.

[bitseeker]

'peterlaursen' wrote:

No. But you can double-click on anything in the Object Browser and it will insert to the editor.

I know, but double-clicking every single column in a table with 30+ columns is rather annoying.

What about extending 'Paste SQL Statements' with 'All table columns'? 🙄

thx bitseeker

[Samatva]

Select the table, select the “Info tab” – all fields are shown – hold Ctrl-Alt and left-click-drag over the field names to mark them (will be in “column” mode). Right-click marked area and copy.

Works well if pasted into an editor that will trim trailing spaces.

This works on Ubuntu with SQLyog running in Wine 1.3. YMMV

[bitseeker]

thanks Samatva,

but still not very handy. On windows column select works with ALT-LMB drag. Funny this works only in Text/Detailed mode and not in HTML mode ;o)

In MySQL Front you could select field names in Object Browser just like files in Windows Explorer using Shift or Ctrl + LMB and then copy -> when pasting you got selected fields comma-seperated in one single line.

[Author]

Posts