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
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]
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.