数据库之SQL语句之DML

SELECT INTO 语句
如：SELECT * INTO WebsitesBackup2016 FROM Websites;

INSERT INTO语句
如：INSERT INTO Websites (name, country) SELECT app_name, country FROM apps WHERE id=1;

CREATE DATABASE dbname;

create table(column 类型(长度),)

create table as select * from table1
create database;
create index;
create unique index;
drop database;
drop table;
drop index;
TRUNCATE TABLE，物理清空数据
约束
not null，unique,PRIMARY KEY,FOREIGN KEY,DEFAULT

ALTER TABLE Persons ALTER COLUMN DateOfBirth year
ALTER TABLE Persons drop COLUMN DateOfBirth