Home > Database > Mysql Tutorial > body text

sqlserver数据库机种insert语句用法insertintoemproyee(e_name,e

WBOY
Release: 2016-06-07 16:12:29
Original
1296 people have browsed it

刚倒弄sql server 对insert 语句插入多条数据时总结下》 单条数据插入: insert into emproyee(e_name,e_sex)values('唐家三少',0); insert into emproyee(e_name,e_sex)select'骷髅精灵',0 多条数据插入: insert into emproyee(e_name,e_sex)select'天蚕土

刚倒弄sql server 对insert 语句插入多条数据时总结下》

单条数据插入:

insert into emproyee(e_name,e_sex)values('唐家三少',0);
insert into emproyee(e_name,e_sex)select'骷髅精灵',0

多条数据插入:

insert into emproyee(e_name,e_sex)select'天蚕土豆',0
union all select '我吃西红柿',0
union all select '逆苍天',0

source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!