1.insert ta select
'张三',10,'人事部','20080110','075654' union select
'张三',10,'人事部','20080111','094054'
和insert into ta values('张三',10,'人事部','20080110','075654')
insert into ta values('张三',10,'人事部','20080111','095654')
两者区别?
'张三',10,'人事部','20080110','075654' union select
'张三',10,'人事部','20080111','094054'
和insert into ta values('张三',10,'人事部','20080110','075654')
insert into ta values('张三',10,'人事部','20080111','095654')
两者区别?
但是执行效率不同,第一种的效率慢,第二种直接赋值的效率高。--------
个人想法!
--------