1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 | 题目8. 通过sql语句向s表中添加信息。
INSERT INTO S(Sno,Sname,Ssex,Ssp,Sdept,Sbirth,Sfrom,Schg,Spa,Snation,remark) VALUES
( '001' , '李春刚' , '男' , '计算机应用' , 'CS' , '1985-5-10' , '河源' , '' , '团员' , '汉' , '' );
INSERT INTO S(Sno,Sname,Ssex,Ssp,Sdept,Sbirth,Sfrom,Schg,Spa,Snation,remark) VALUES
( '002' , '东学婷' , '女' , '计算机应用' , 'CS' , '1986-10-24' , '包头' , '转系' , '团员' , '蒙' , '' );
INSERT INTO S(Sno,Sname,Ssex,Ssp,Sdept,Sbirth,Sfrom,Schg,Spa,Snation,remark) VALUES
( '003' , '张五男' , '男' , '电子商务' , 'MA' , '1984-2-17' , '上海' , '退学' , '团员' , '汉' , '' );
INSERT INTO S(Sno,Sname,Ssex,Ssp,Sdept,Sbirth,Sfrom,Schg,Spa,Snation,remark) VALUES
( '004' , '刘%' , '男' , '电子商务' , 'MA' , '1985-4-24' , '巴盟' , '' , '团员' , '汉' , '' );
INSERT INTO S(Sno,Sname,Ssex,Ssp,Sdept,Sbirth,Sfrom,Schg,Spa,Snation,remark) VALUES
( '005' , '吴惠' , '女' , '软件开发' , 'CS' , '1985-2-10' , '通辽' , '' , '团员' , '汉' , '' );
INSERT INTO S(Sno,Sname,Ssex,Ssp,Sdept,Sbirth,Sfrom,Schg,Spa,Snation,remark) VALUES
( '006' , '王涛' , '男' , '软件开发' , 'CS' , '1984-9-8' , '赤峰' , '' , '团员' , '满' , '' );
INSERT INTO S(Sno,Sname,Ssex,Ssp,Sdept,Sbirth,Sfrom,Schg,Spa,Snation,remark) VALUES
( '007' , '郭凤丽' , '男' , '应用电子' , 'IS' , '1984-3-2' , '广州' , '' , '团员' , '蒙' , '' );
INSERT INTO S(Sno,Sname,Ssex,Ssp,Sdept,Sbirth,Sfrom,Schg,Spa,Snation,remark) VALUES
( '008' , '贾惠' , '男' , '应用电子' , 'IS' , '1983-2-2' , '深圳' , '' , '团员' , '汉' , '' );
INSERT INTO S(Sno,Sname,Ssex,Ssp,Sdept,Sbirth,Sfrom,Schg,Spa,Snation,remark) VALUES
( '009' , '刘一%' , '男' , '软件开发' , 'CS' , '1985-9-9' , '东莞' , '' , '团员' , '满' , '' ); |