Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Expand Wildcards

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Expand Wildcards

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • November 25, 2010 at 10:59 pm #12168
      lucazav
      Member

      Hi all,

      it'd be very useful to have a feature (a simple TAB pressure near the * char) that lets you to expand SELECT * and SELECT table.* statements so that they list all of the columns that exist in the referenced tables.

      Thank you.

      Luca

    • November 26, 2010 at 6:18 am #31599
      ashwin
      Member

      Hi,

      Quote:
      it'd be very useful to have a feature (a simple TAB pressure near the * char) that lets you to expand SELECT * and SELECT table.* statements so that they list all of the columns that exist in the referenced tables.

      Please tell the exact case from the two listed below:

      1. Do you want a shortcut key to replace * with all the columns in the table?

      2. Do you want to list all the columns belonging to a particular table in a popup window?

      If it is the second one, then we have the autocomplete feature available in PROFESSIONAL/ENTERPRISE/ULIMATE editions of SQLyog. Please go through the program help file to know more.

    • November 26, 2010 at 9:44 am #31600
      lucazav
      Member
      'ashwin' wrote:

      Hi,

      Please tell the exact case from the two listed below:

      1. Do you want a shortcut key to replace * with all the columns in the table?

      2. Do you want to list all the columns belonging to a particular table in a popup window?

      If it is the second one, then we have the autocomplete feature available in PROFESSIONAL/ENTERPRISE/ULIMATE editions of SQLyog. Please go through the program help file to know more.

      Hi,

      I meant the case 1. While you are writing a query involving a table with a lot of columns and you have to select a lot of them, it will be a nice shortcut!

      Thank you so much.

      Luca

    • November 26, 2010 at 9:58 am #31601
      peterlaursen
      Participant

      table menu already has a 'paste SQL statements' option. Are you aware of this?

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.