List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:May 24 2007 10:09pm
Subject:How to get the table.column in mysql client tab completion? Or feature request to add this.
View as plain text  
Is there a way to get the full table.column always in mysql client when
using the auto-tab completion feature? I'm currently using 5.0.36.

The way it works now is a bit confusing. Notice I have TWO different
"DateOnly" columns (for example) in two different tables. [middle
column]
 
mysql> select Scan
ScanData.Data       [ ScanData.DateOnly ]   ScanData.device_id
ScanData.IP_Addr      ScanData.JQID         ScanData.Name
ScanData.NoteMD5      ScanData.Port         ScanData.Proto
ScanData.ScanDate     ScanData.ScanID       ScanData.Service
ScanData.Summary      ScanData.VulnID       ScanDate
ScanInfo            [ ScanInfo.DateOnly ]   ScanInfo.DeviceID
ScanInfo.IP_Addr      ScanInfo.JobQID       ScanInfo.NewVulns
ScanInfo.ScanDate     ScanInfo.ScanID       ScanInfo.ScannerID
ScanInfo.StaleData    ScanInfo.Trend_Vulns  ScanInfo.Trend_Warns
ScanInfo.Warns        ScannerID             ScanData

But when I go to select DateOnly, I don't know which table it's in. 

mysql> select Dat[TAB]
Data      DateOnly  
 
We have nearly 300 tables across 3 databases for our product. I can't
even begin to remember all the columns in each one...
 
Also, it would be great if mysql client was "smart" enough to limit my
tab completion choices to possibilities based upon the current SQL query
I'm crafting. So If I have:
 
"select t[TAB] from ResolveTable join Tickets;"
 
It should only show me columns that start with a 't' that are in the
ResolveTable or Tickets tables only.
 

ÐÆ5ÏÐ 


Thread
How to get the table.column in mysql client tab completion? Or feature request to add this.Daevid Vincent25 May
  • Re: How to get the table.column in mysql client tab completion? Orfeature request to add this.Baron Schwartz25 May
    • RE: How to get the table.column in mysql client tab completion? Or feature request to add this.Daevid Vincent25 May
  • Need script to populate data.SRM SRM25 May
  • Need script to populate data.SRM SRM25 May
    • Re: Need script to populate data.Ryan Stille25 May
      • Re: Need script to populate data.SRM SRM25 May
        • Re: Need script to populate data.Dan Nelson25 May