最好用CTAS来建表,如:create table table2
as
select *,'2' as new1,'33' as new2,'2005/06/06' as new3
FROM TABLE1
WHERE TABLE1.NO='1'注意,在创建新表的时候,要把你的select 语句查出的各列指定列标题,不然没办法创建新表.
as
select *,'2' as new1,'33' as new2,'2005/06/06' as new3
FROM TABLE1
WHERE TABLE1.NO='1'注意,在创建新表的时候,要把你的select 语句查出的各列指定列标题,不然没办法创建新表.
insert into table2
SELECT *,'2','33','2005/06/06'
FROM TABLE1
WHERE TABLE1.NO='1'
SELECT TABLE1.*,'2','33','2005/06/06'
FROM TABLE1
WHERE TABLE1.NO='1'
SELECT TABLE1.*,'2','33','2005/06/06'
FROM TABLE1
WHERE TABLE1.NO='1'
SELECT t.*,'2','33','2005/06/06,yyyy/mm/dd'
from table1 t
where t.no='1'
可以的
SELECT t.*,'2','33',('2005/06/06','yyyymmdd')
from table1 t
where t.no='1'
可以的