[SQL筆記] Insert Into 插入數據

插入數據

標準語法

--向部門表插入數據
insert into Department(DepartmentName,DepartmentRemark) values('市場部','test')
insert into Department(DepartmentName,DepartmentRemark) values('軟體部','test')
insert into Department(DepartmentName,DepartmentRemark) values('企劃部','test')

插入數據(簡寫)

儘量不要使用簡寫，如果欄位結構位置錯位，數據就會錯誤。

insert into Department values('工程部','test123')
insert into Department values('銷售部','test123')

一次性插入多行數據

insert into select union

insert into Department(DepartmentName,DepartmentRemark)
select '摸魚部','test...' union
select '打混部','test...' union
select '測試部','test...'

向職級表插入數據

--向職級表插入數據
insert into [Rank](RankName,RankRemark) values('初級','...')
insert into [Rank](RankName,RankRemark) values('中級','...')
insert into [Rank](RankName,RankRemark) values('高級','...')

向員工表插入數據

insert into Employee(DepartmentId,RankId,EmployeeName,EmployeeSex,EmployeeBirth,EmployeeSalary,EmployeePhone,EmployeeAddress,EmployeeAddTime)
values(8,1,'張三','男','1999-9-9',50000,'0988888888','USA',getdate())

https://www.bilibili.com/video/BV1XV411C7TP?p=5