❶ sql2000有自動補全命令的功能嗎有的話怎樣操作
默認不是開啟的。若要開啟此功能，可以在Linux中
vi /etc/my.cnf
[mysql]
#no-auto-rehash
auto-rehash #添加auto-rehash
即將[mysql]中的no-auto-rehash改為auto-rehash
再次登陸MySQL就可以自動補全了。
如果你想嘗試在Windows中做同樣嘗試，會發現不會成功。
原因在下面的英文中有解釋：
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 proct. Some open-source projects have not been made fully compatible with the Microsoft Windows environment.
At one time in the past, the MySQL proct 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版本的一個Bug :-)
❷ 如何用sql把表中的數據補全
只能一條一條的更新了。
例如：
UPDATE 表A SET 日期=SUBSTRING(日期,1,4)+'-'+SUBSTRING(日期,5,2)+'-'+SUBSTRING(日期,7,2),期初=5,庫存=5 WHERE 日期='20131101'
❸ SQL自動補全數據的語句怎麼寫
Select right('000000'+convert(varchar(10),b),6) as b from a
❹ sql2008 自動補全功能在哪裡設置，按哪個鍵可以實現自動補全
工具——選項——文本編輯器——Transact-sql——IntellSense
❺ 資料庫數據整理，sql語句如何補齊為空的數據
在orderid順序排列或者有順序列的情況下，可以使用自連接對比循環來依次補全：
declare@iint
declare@jint
set@i=1
select@j=(selectcount(*)ascontfromtb)
while@i<=@j
begin
updateaseta.proid=b.proidfromtnnerjointbbona.orderid=b.orderid+1wherea.orderid=@ianda.proidisnull
set@i=@i+1
end
❻ 使用PL/SQL Developer操作oracle資料庫怎麼才可以自動補全命令例如輸入，cre,自動補全create.
新建一個SEQ：
create sequence seq_ceid
minvalue 1
maxvalue 9999999999
start with 1
increment by 1
cache 20;
插入時：
INSERT INTO STUDENTINFO (CRE_ID,NAME……) VALUES (SEQ_CEID.NEXTVAL,……);
這樣就可以了。
❼ 用SQL語言補充完整
1:
SELECT c.顧客號，c.顧客名,o.商品號，o.數量
from C,O
where c.顧客號=o.顧客號
2:
SELECT
FORM C,O
WHERE 顧客名=(SELECT 顧客號,max(數量) FORM O);
3:
SELET o.商品號、o.商品名,sum(數量)
FROM O,A,C,
WHERE o.商品號=a.商品號
and c.顧客號=o.顧客號
and c.性別='女'
GROUP BY O 商品號，商品名；
4：ALTER TABEL add 產地 char(30)
❽ pl sql中可不可以輸入函數,然後自動補全,
Tools->Preferences->User
Interface->CodeAssistant，可以設置自動補全功能。
首先勾選上面的Automatically activated。然後設置延時(默認500毫秒)和最少字元(默認3，即至少要輸入3個字元以後才會開始補全)。其他都不用改。