Links

2. 插入

-- 对所有字段赋值,省略字段名称
INSERT INTO `employee` VALUES ('John', 'B', 'Smith ', '123456789', '1965-01-09 00:00:00', '731 Fondren, Houston. TX', 'M', 30000, '333445555', '5');
​
-- 指定字段
INSERT INTO `employee`(fname,ssn) VALUES ('demo', '123456987');
​
-- 插入子查询结果
INSERT INTO `employee` (fname,sex) (SELECT dependent_name,sex from dependent);
​
-- 查询创建表
-- mysql
create table new_table_name as select * from (your_sql) as sql_table;
​
create table test as select * from works_on as test;
​
-- sql Server
select * into test from works_on