CreateAs

Create As建立表格

• Create As 可直接把查詢結果建立表格

################# 語法如下:
CREATE TABLE tablename AS
SELECT columnnames
FROM tablename
WHERE condition;

################# 範例如下:
CREATE TABLE bookback AS
SELECT * FROM book WHERE price >=1000;

Insert into插入表格

• Insert into 也可直接把查詢結果插入表格

################# 語法如下:
INSERT INTO tablename
SELECT columnnames
FROM tablename
WHERE condition;

################# 範例如下:
INSERT INTO expbook
SELECT * FROM book WHERE price >=5000;