create table studentlist ( data varchar(20) null, name varchar(10) null, sex int(2) null, age int(100) null, sno int(12) not null primary key, class varchar(10) null, status int(2) null, address varchar(20) null, telephone int(12) null );生成50条以上表结构的数据
时间: 2023-06-17 12:06:15 浏览: 168
INSERT INTO studentlist VALUES ('2020-01-01', '张三', 1, 18, 100000000001, '一年级一班', 1, '北京市海淀区', 18888888888);
INSERT INTO studentlist VALUES ('2020-01-02', '李四', 0, 19, 100000000002, '一年级一班', 1, '北京市海淀区', 17777777777);
INSERT INTO studentlist VALUES ('2020-01-03', '王五', 1, 20, 100000000003, '一年级二班', 1, '北京市朝阳区', 16666666666);
INSERT INTO studentlist VALUES ('2020-01-04', '赵六', 0, 18, 100000000004, '一年级二班', 1, '北京市朝阳区', 15555555555);
INSERT INTO studentlist VALUES ('2020-01-05', '钱七', 1, 19, 100000000005, '一年级三班', 1, '北京市丰台区', 14444444444);
INSERT INTO studentlist VALUES ('2020-01-06', '孙八', 0, 20, 100000000006, '一年级三班', 1, '北京市丰台区', 13333333333);
INSERT INTO studentlist VALUES ('2020-01-07', '周九', 1, 18, 100000000007, '一年级四班', 1, '北京市石景山区', 12222222222);
INSERT INTO studentlist VALUES ('2020-01-08', '吴十', 0, 19, 100000000008, '一年级四班', 1, '北京市石景山区', 11111111111);
INSERT INTO studentlist VALUES ('2020-01-09', '郑十一', 1, 20, 100000000009, '一年级五班', 1, '北京市通州区', 19999999999);
INSERT INTO studentlist VALUES ('2020-01-10', '王十二', 0, 18, 100000000010, '一年级五班', 1, '北京市通州区', 18888888888);
INSERT INTO studentlist VALUES ('2020-01-11', '张十三', 1, 19, 100000000011, '二年级一班', 1, '北京市顺义区', 17777777777);
INSERT INTO studentlist VALUES ('2020-01-12', '李十四', 0, 20, 100000000012, '二年级一班', 1, '北京市顺义区', 16666666666);
INSERT INTO studentlist VALUES ('2020-01-13', '王十五', 1, 18, 100000000013, '二年级二班', 1, '北京市昌平区', 15555555555);
INSERT INTO studentlist VALUES ('2020-01-14', '赵十六', 0, 19, 100000000014, '二年级二班', 1, '北京市昌平区', 14444444444);
INSERT INTO studentlist VALUES ('2020-01-15', '钱十七', 1, 20, 100000000015, '二年级三班', 1, '北京市大兴区', 13333333333);
INSERT INTO studentlist VALUES ('2020-01-16', '孙十八', 0, 18, 100000000016, '二年级三班', 1, '北京市大兴区', 12222222222);
INSERT INTO studentlist VALUES ('2020-01-17', '周十九', 1, 19, 100000000017, '二年级四班', 1, '北京市西城区', 11111111111);
INSERT INTO studentlist VALUES ('2020-01-18', '吴二十', 0, 20, 100000000018, '二年级四班', 1, '北京市西城区', 19999999999);
INSERT INTO studentlist VALUES ('2020-01-19', '郑二十一', 1, 18, 100000000019, '二年级五班', 1, '北京市东城区', 18888888888);
INSERT INTO studentlist VALUES ('2020-01-20', '王二十二', 0, 19, 100000000020, '二年级五班', 1, '北京市东城区', 17777777777);
INSERT INTO studentlist VALUES ('2020-01-21', '张二十三', 1, 20, 100000000021, '三年级一班', 1, '北京市海淀区', 16666666666);
INSERT INTO studentlist VALUES ('2020-01-22', '李二十四', 0, 18, 100000000022, '三年级一班', 1, '北京市海淀区', 15555555555);
INSERT INTO studentlist VALUES ('2020-01-23', '王二十五', 1, 19, 100000000023, '三年级二班', 1, '北京市朝阳区', 14444444444);
INSERT INTO studentlist VALUES ('2020-01-24', '赵二十六', 0, 20, 100000000024, '三年级二班', 1, '北京市朝阳区', 13333333333);
INSERT INTO studentlist VALUES ('2020-01-25', '钱二十七', 1, 18, 100000000025, '三年级三班', 1, '北京市丰台区', 12222222222);
INSERT INTO studentlist VALUES ('2020-01-26', '孙二十八', 0, 19, 100000000026, '三年级三班', 1, '北京市丰台区', 11111111111);
INSERT INTO studentlist VALUES ('2020-01-27', '周二十九', 1, 20, 100000000027, '三年级四班', 1, '北京市石景山区', 19999999999);
INSERT INTO studentlist VALUES ('2020-01-28', '吴三十', 0, 18, 100000000028, '三年级四班', 1, '北京市石景山区', 18888888888);
INSERT INTO studentlist VALUES ('2020-01-29', '郑三十一', 1, 19, 100000000029, '三年级五班', 1, '北京市通州区', 17777777777);
INSERT INTO studentlist VALUES ('2020-01-30', '王三十二', 0, 20, 100000000030, '三年级五班', 1, '北京市通州区', 16666666666);
INSERT INTO studentlist VALUES ('2020-01-31', '张三十三', 1, 18, 100000000031, '四年级一班', 1, '北京市顺义区', 15555555555);
INSERT INTO studentlist VALUES ('2020-02-01', '李三十四', 0, 19, 100000000032, '四年级一班', 1, '北京市顺义区', 14444444444);
INSERT INTO studentlist VALUES ('2020-02-02', '王三十五', 1, 20, 100000000033, '四年级二班', 1, '北京市昌平区', 13333333333);
INSERT INTO studentlist VALUES ('2020-02-03', '赵三十六', 0, 18, 100000000034, '四年级二班', 1, '北京市昌平区', 12222222222);
INSERT INTO studentlist VALUES ('2020-02-04', '钱三十七', 1, 19, 100000000035, '四年级三班', 1, '北京市大兴区', 11111111111);
INSERT INTO studentlist VALUES ('2020-02-05', '孙三十八', 0, 20, 100000000036, '四年级三班', 1, '北京市大兴区', 19999999999);
INSERT INTO studentlist VALUES ('2020-02-06', '周三十九', 1, 18, 100000000037, '四年级四班', 1, '北京市西城区', 18888888888);
INSERT INTO studentlist VALUES ('2020-02-07', '吴四十', 0, 19, 100000000038, '四年级四班', 1, '北京市西城区', 17777777777);
INSERT INTO studentlist VALUES ('2020-02-08', '郑四十一', 1, 20, 100000000039, '四年级五班', 1, '北京市东城区', 16666666666);
INSERT INTO studentlist VALUES ('2020-02-09', '王四十二', 0, 18, 100000000040, '四年级五班', 1, '北京市东城区', 15555555555);
INSERT INTO studentlist VALUES ('2020-02-10', '张四十三', 1, 19, 100000000041, '五年级一班', 1, '北京市海淀区', 14444444444);
INSERT INTO studentlist VALUES ('2020-02-11', '李四十四', 0, 20, 100000000042, '五年级一班', 1, '北京市海淀区', 13333333333);
INSERT INTO studentlist VALUES ('2020-02-12', '王四十五', 1, 18, 100000000043, '五年级二班', 1, '北京市朝阳区', 12222222222);
INSERT INTO studentlist VALUES ('2020-02-13', '赵四十六', 0, 19, 100000000044, '五年级二班', 1, '北京市朝阳区', 11111111111);
INSERT INTO studentlist VALUES ('2020-02-14', '钱四十七', 1, 20, 100000000045, '五年级三班', 1, '北京市丰台区', 19999999999);
INSERT INTO studentlist VALUES ('2020-02-15', '孙四十八', 0, 18, 100000000046, '五年级三班', 1, '北京市丰台区', 18888888888);
INSERT INTO studentlist VALUES ('2020-02-16', '周四十九', 1, 19, 100000000047, '五年级四班', 1, '北京市石景山区', 17777777777);
INSERT INTO studentlist VALUES ('2020-02-17', '吴五十', 0, 20, 100000000048, '五年级四班', 1, '北京市石景山区', 16666666666);