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.
List-Archive: http://lists.mysql.com/mysql/206991
Message-Id: <BRAKAMdki9vufeIYqS400000d54@mx1.lockdownnetworks.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

mysql> select Dat[TAB]
Data      DateOnly =20
=20
We have nearly 300 tables across 3 databases for our product. I can't
even begin to remember all the columns in each one...
=20
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:
=20
"select t[TAB] from ResolveTable join Tickets;"
=20
It should only show me columns that start with a 't' that are in the
ResolveTable or Tickets tables only.
=20

=D0=C65=CF=D0=20