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ÏÐ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]