可以 select id,name ,'123456' as new_add --新增 from s_employee where id >300
select *,'新增列'from table1
select *,'新增列'from table1 是成功的 我试过了
不好用 报找不到关键字FROM
可以,要用引号括起来. SQL> select id,name,age,money from tt; ID NAME AGE MONEY ---------- -------------------- ---------- -------------------- 4 D 20 13 4 C 20 16 1 A 23 4 1 B 25 6 2 A 23 8 2 C 20 10 3 D 16 12 4 E 17 14 4 B 16 159 rows selected SQL> select id,name,age,money,'add column' "新增列" from tt; ID NAME AGE MONEY 新增列 ---------- -------------------- ---------- -------------------- ---------- 4 D 20 13 add column 4 C 20 16 add column 1 A 23 4 add column 1 B 25 6 add column 2 A 23 8 add column 2 C 20 10 add column 3 D 16 12 add column 4 E 17 14 add column 4 B 16 15 add column9 rows selected
这个没什么好争的新增一列数字就直接写. 比如表叫test.固有字段id,name select id,name,1 from test;新增字符串就引上. select id,name,'你好' from test;
select id,name
,'123456' as new_add --新增
from s_employee
where id >300
是成功的 我试过了
报找不到关键字FROM
SQL> select id,name,age,money from tt; ID NAME AGE MONEY
---------- -------------------- ---------- --------------------
4 D 20 13
4 C 20 16
1 A 23 4
1 B 25 6
2 A 23 8
2 C 20 10
3 D 16 12
4 E 17 14
4 B 16 159 rows selected
SQL> select id,name,age,money,'add column' "新增列" from tt; ID NAME AGE MONEY 新增列
---------- -------------------- ---------- -------------------- ----------
4 D 20 13 add column
4 C 20 16 add column
1 A 23 4 add column
1 B 25 6 add column
2 A 23 8 add column
2 C 20 10 add column
3 D 16 12 add column
4 E 17 14 add column
4 B 16 15 add column9 rows selected
比如表叫test.固有字段id,name
select id,name,1 from test;新增字符串就引上.
select id,name,'你好' from test;