insert into student(sno,sname,ssex,sage,sdept) select '95001','李勇','男','20','cs'
union select '95002','刘晨','女','19','is'
union select '95003','王敏','女','18','ma'
union select '95004','张立','男','19','is'
转载于:https://www.cnblogs.com/darzui/archive/2005/11/22/282229.html