❶ 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个字符以后才会开始补全)。其他都不用改。