在db2中怎么update一个包含空格的列

显示全部楼层 · 2007-10-20 08:38:44

Hi, everybody
我在db2中创建了一个包含有空格的列的表，如下：
CREATE TABLE pc_p1(SCHOOL_ID int PRIMARY KEY not null, “SCHOOL NAME” VARCHAR(40));
插入一些数据：
insert into pc_p1 values(1,'a');
但是现在有一个问题了，我需要对这个包含有空格的列进行update，怎么办？我试了"",[],'',,这些都不行，请各位大侠帮个忙。
谢谢

千问 · 2007-10-20 08:38:44

$ db2 describe table pc_p1
Column
TypeType
name
schemaname
Length Scale Nulls
------------------------------ --------- ------------------ -------- ----- ------
SCHOOL_ID
SYSIBMINTEGER
4 0 No
SCHOOL NAME
SYSIBMVARCHAR
40 0 Yes
2 record(s) selected.
$ db2 "insert into pc_p1 values(1,'a')"
DB20000IThe SQL command completed successfully.
$ db2 "update pc_p1 set "SCHOOL NAME"='b'"
DB20000IThe SQL command completed successfully.
$ db2 "select * from pc_p1"
SCHOOL_ID SCHOOL NAME
----------- ----------------------------------------

1 b
1 record(s) selected.
$

千问 · 2007-10-20 08:38:44

yes， I got it
The column name in quote must be uppercase.
Thanks a lot