sql2000有自動(dòng)補(bǔ)全命令的功能嗎？有的話怎樣操作？

默認(rèn)不是開啟的。若要開啟此功能，可以在Linux中

創(chuàng)新互聯(lián)是一家企業(yè)級(jí)云計(jì)算解決方案提供商,超15年IDC數(shù)據(jù)中心運(yùn)營(yíng)經(jīng)驗(yàn)。主營(yíng)GPU顯卡服務(wù)器，站群服務(wù)器，四川電信機(jī)房托管，海外高防服務(wù)器，機(jī)柜大帶寬，動(dòng)態(tài)撥號(hào)VPS，海外云手機(jī)，海外云服務(wù)器，海外服務(wù)器租用托管等。

vi /etc/my.cnf

[mysql]

#no-auto-rehash

auto-rehash #添加auto-rehash

即將[mysql]中的no-auto-rehash改為auto-rehash

再次登陸MySQL就可以自動(dòng)補(bǔ)全了。

如果你想嘗試在Windows中做同樣嘗試，會(huì)發(fā)現(xiàn)不會(huì)成功。

原因在下面的英文中有解釋：

It ought to work this way:

C:\ mysql --auto-rehash

Or configure your my.cnf:

[mysql]

auto-rehash

edit: My apologies. I have found some references that the tab-completion feature in mysql client works only on UNIX/Linux. It does not work on Windows.

update: The reason for this is mentioned briefly in MySQL bug #4731:

[31 Jul 2004 12:47] Sergei Golubchik

I just downloaded 4.0.15 - command completion in mysql.exe is NOT working, as expected. It was never working in mysql.exe because we were not able to make readline to compile with VC++.

mysqlc.exe is a cygwin build, and it is linked with readline.

Explanation: GNU readline is a standard open-source library for handling user input. The MySQL team uses the readline library, but they are not its author. From the above comment, I understand that they were unsuccessful in compiling the readline library on Windows with Microsoft Visual C++, the tool they use to build the MySQL product. Some open-source projects have not been made fully compatible with the Microsoft Windows environment.

At one time in the past, the MySQL product provided an alternative client they called mysqlc.exe, which they compiled with the cygwin toolset on Windows, but they don't provide this anymore. The cygwin toolset includes the readline library, so it was possible to compile the mysqlc.exe client with support for tab-completion.

So in theory, if you are really intrepid, you could download the cygwin toolset including the readline library, then download the MySQL source code and build it using cygwin. Then you should have a mysql client program that can perform tab-completion. But this sounds like a lot of work even for someone who is familiar with building MySQL from source.

這是MySQL Windows版本的一個(gè)Bug :-)

有誰(shuí)知道怎么可以讓Mysql Workbench的查詢窗口中的輸入命令自動(dòng)補(bǔ)全么？

PL/SQL有自動(dòng)提示，例如輸入crea 的時(shí)候，會(huì)出現(xiàn)一個(gè)下拉單 create 但是沒有自動(dòng)補(bǔ)全的方法哦~~會(huì)提示，沒補(bǔ)全 新建一個(gè)SEQ： create sequence seq_

MYSQL：如何使用MYSQL命令行的自動(dòng)補(bǔ)全功能

使用MYSQL -I命令，查看MYSQL命令的參數(shù)，其中對(duì)--auto-rehash參數(shù)的說明如下：--auto-rehash Enable automatic rehashing. One doesn#39;t need to use #39;rehash#39; to get table and field completion, but startup and reconnecting may take a longer time. Disable with --disable-auto-rehash. 網(wǎng)上也找了一些資料，說是打開MYSQL的自動(dòng)補(bǔ)全功能，類似于LINUX的TAB鍵補(bǔ)全功能。但如下使用該參數(shù)后，輸入SQL命令，中途按TAB健，并未出現(xiàn)自動(dòng)補(bǔ)全的效果，不知道如何操作： [sql] C:\Users\qxlmysql -u root --auto-rehash Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 29 Server version: 5.1.28-rc-community MySQL Community Server (GPL) Type #39;help;#39; or #39;\h#39; for help. Type #39;\c#39; to clear the buffer. mysql use test Database changed mysql select * from newnam