SQL建表create table as 的用法

2024-12-25 16:22:03
推荐回答(2个)
回答1:

Alter table tabname add column col int

tabname是表名,col是列名

回答2:

CREATE TABLE temp
AS
SELECT *, 0 AS 栏位 FROM A