MySQL18

Error_Fe

已于 2024-06-03 17:52:29 修改

阅读量228

点赞数 3

文章标签： sql 数据库

于 2024-06-03 17:00:08 首次发布

本文链接：https://blog.csdn.net/Error_Fe/article/details/139419577

版权

这个是源码


delimiter $$
drop procedure if exists get_word;
create procedure get_word(in s char(100),out w char(1))
begin
declare len tinyint;
set len = char_length(s);
set @a = floor(rand()*len+1);
set w = substring(s,@a,1);
end $$
delimiter ;

delimiter $$
drop procedure if exists get_a_character;
create procedure  get_a_character(in s char(100),out w char(1))
begin
call get_word(s,w);
end  $$
delimiter ;
set @x = '刘王张赵李钱朱何孙曾陈吴黄刘邓周毛江胡';

call get_a_character(@x,@k);
select @k;

delimiter $$
drop procedure if exists get_name;
create procedure  get_name(out m varchar(2),out xb int)
begin
declare cd int;
declare ms1,ms2 varchar(50);
declare m1,m2,m3 varchar(2);
set ms1='依秋香巧紫萱莉玉碧丽念雅红燕艳莲荷蕾紫莹颖琪';
set ms2='澄德海超阳昌瀚亮锋涵煦杰俊诚毅峰衍浩广邈言博畅';
set xb = floor(rand()*2);
set cd = floor(rand()*2+1);
    if  xb = 0 then
          call get_word(ms1,m1); 
          call get_word(ms1,m2); 
          set m3 = concat(m1,m2);
    elseif xb = 1 then
          call get_word(ms2,m1); 
          call get_word(ms2,m2); 
          set m3 = concat(m1,m2);
    end if;
    if cd = 1 then set m = m1;
    elseif cd = 2 then set m = m3;
    end if;
end $$
delimiter ;
call get_name(@name,@sex);
select @name,@sex;


delimiter $$
drop procedure if exists main;
create procedure main()
begin
declare x varchar(100);
declare xing,ming,xm varchar(3);
declare sex,n int;
declare xh varchar(8);
create  table xs2 as select 学号,姓名,性别 from xs where 1<>1 ;
set xh = '191100';
set n = 1;
while n<=20 do
 call get_a_character(@x,@k);
 set xing = @k;
 call get_name(@name,@sex);
 set ming = @name;
 set sex = @sex;
 set xm = concat(xing,ming);
 insert into xs2 values(xh,xm,sex);
 set n = n+1;
set xh = xh +1;
end while;
end $$
delimiter ;
call main();
select * from xs2;

delimiter $$
drop procedure if exists main2;
create procedure main2()
begin
declare x varchar(100);
declare xing,ming,xm varchar(3);
declare sex,n,f int;
declare xh varchar(8);
declare continue handler for sqlexception set f=2;
drop table if exists xs2;
create  table xs2 as select 学号,姓名,性别 from xs limit 0 ;
create unique index index_name on xs2(姓名);
set xh = '191100';
while xh<='191999' do
 call get_a_character(@x,@k);
 set xing = @k;
 call get_name(@name,@sex);
 set ming = @name;
 set sex = @sex;
 set xm = concat(xing,ming);
 insert into xs2 values(xh,xm,sex);
 if f=2 then 
	select xh,xm,'重名了';
	set f=1;
elseif f=1 then
	set xh = xh+1;
 end if;
end while;
end $$
delimiter ;
call main2();
select * from xs2;

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| lll                |
| lty                |
| mysql              |
| performance_schema |
| test               |
+--------------------+
6 rows in set (0.00 sec)

mysql> set names gbk;
Query OK, 0 rows affected (0.00 sec)

mysql> create database llll;
Query OK, 1 row affected (0.00 sec)

mysql> use llll;
Database changed
mysql> delimiter $$
mysql> drop procedure if exists get_word;
    -> create procedure get_word(in s char(100),out w char(1))
    -> begin
    -> declare len tinyint;
    -> set len = char_length(s);
    -> set @a = floor(rand()*len+1);
    -> set w = substring(s,@a,1);
    -> end $$
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> delimiter $$
mysql> drop procedure if exists get_a_character;
    -> create procedure  get_a_character(in s char(100),out w char(1))
    -> begin
    -> call get_word(s,w);
    -> end  $$
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> set @x = '刘王张赵李钱朱何孙曾陈吴黄刘邓周毛江胡';
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> call get_a_character(@x,@k);
Query OK, 0 rows affected (0.00 sec)

mysql> select @k;
+------+
| @k   |
+------+
| 刘     |
+------+
1 row in set (0.00 sec)

mysql> delimiter $$
mysql> drop procedure if exists get_name;
    -> create procedure  get_name(out m varchar(2),out xb int)
    -> begin
    -> declare cd int;
    -> declare ms1,ms2 varchar(50);
    -> declare m1,m2,m3 varchar(2);
    -> set ms1='依秋香巧紫萱莉玉碧丽念雅红燕艳莲荷蕾紫莹颖琪';
    -> set ms2='澄德海超阳昌瀚亮锋涵煦杰俊诚毅峰衍浩广邈言博畅';
    -> set xb = floor(rand()*2);
    -> set cd = floor(rand()*2+1);
    ->     if  xb = 0 then
    ->           call get_word(ms1,m1);
    ->           call get_word(ms1,m2);
    ->           set m3 = concat(m1,m2);
    ->     elseif xb = 1 then
    ->           call get_word(ms2,m1);
    ->           call get_word(ms2,m2);
    ->           set m3 = concat(m1,m2);
    ->     end if;
    ->     if cd = 1 then set m = m1;
    ->     elseif cd = 2 then set m = m3;
    ->     end if;
    -> end $$
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> call get_name(@name,@sex);
Query OK, 0 rows affected (0.00 sec)

mysql> select @name,@sex;
+-------+------+
| @name | @sex |
+-------+------+
| 邈煦      |    1 |
+-------+------+
1 row in set (0.00 sec)

mysql> delimiter $$
mysql> drop procedure if exists main;
    -> create procedure main()
    -> begin
    -> declare x varchar(100);
    -> declare xing,ming,xm varchar(3);
    -> declare sex,n int;
    -> declare xh varchar(8);
    -> create  table xs2 as select 学号,姓名,性别 from xs where 1<>1 ;
    -> set xh = '191100';
    -> set n = 1;
    -> while n<=20 do
    ->  call get_a_character(@x,@k);
    ->  set xing = @k;
    ->  call get_name(@name,@sex);
    ->  set ming = @name;
    ->  set sex = @sex;
    ->  set xm = concat(xing,ming);
    ->  insert into xs2 values(xh,xm,sex);
    ->  set n = n+1;
    -> set xh = xh +1;
    -> end while;
    -> end $$
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> call main();
ERROR 1146 (42S02): Table 'llll.xs' doesn't exist
mysql> source C:\Users\Administrator\Downloads\sy121.sql
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 6 rows affected (0.00 sec)
Records: 6  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 12 rows affected (0.00 sec)
Records: 12  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 21 rows affected (0.00 sec)
Records: 21  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> delimiter $$
mysql> drop procedure if exists main;
    -> create procedure main()
    -> begin
    -> declare x varchar(100);
    -> declare xing,ming,xm varchar(3);
    -> declare sex,n int;
    -> declare xh varchar(8);
    -> create  table xs2 as select 学号,姓名,性别 from xs where 1<>1 ;
    -> set xh = '191100';
    -> set n = 1;
    -> while n<=20 do
    ->  call get_a_character(@x,@k);
    ->  set xing = @k;
    ->  call get_name(@name,@sex);
    ->  set ming = @name;
    ->  set sex = @sex;
    ->  set xm = concat(xing,ming);
    ->  insert into xs2 values(xh,xm,sex);
    ->  set n = n+1;
    -> set xh = xh +1;
    -> end while;
    -> end $$
Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> call main();
Query OK, 1 row affected (0.02 sec)

mysql> select * from xs2;
+--------+--------+------+
| 学号      | 姓名       | 性别    |
+--------+--------+------+
| 191100 | 周涵海      |    1 |
| 191101 | 朱香秋       |    0 |
| 191102 | 江诚锋      |    1 |
| 191103 | 刘念颖      |    0 |
| 191104 | 李依       |    0 |
| 191105 | 钱毅昌      |    1 |
| 191106 | 赵荷依      |    0 |
| 191107 | 邓毅       |    1 |
| 191108 | 朱邈涵     |    1 |
| 191109 | 孙丽       |    0 |
| 191110 | 孙秋       |    0 |
| 191111 | 钱莉      |    0 |
| 191112 | 李超海      |    1 |
| 191113 | 李德       |    1 |
| 191114 | 钱雅      |    0 |
| 191115 | 陈荷      |    0 |
| 191116 | 李巧萱       |    0 |
| 191117 | 江超       |    1 |
| 191118 | 钱玉      |    0 |
| 191119 | 朱丽       |    0 |
+--------+--------+------+
20 rows in set (0.01 sec)

mysql> delimiter $$
mysql> drop procedure if exists main2;
    -> create procedure main2()
    -> begin
    -> declare x varchar(100);
    -> declare xing,ming,xm varchar(3);
    -> declare sex,n,f int;
    -> declare xh varchar(8);
    -> declare continue handler for sqlexception set f=2;
    -> drop table if exists xs2;
    -> create  table xs2 as select 学号,姓名,性别 from xs limit 0 ;
    -> create unique index index_name on xs2(姓名);
    -> set xh = '191100';
    -> while xh<='191999' do
    ->  call get_a_character(@x,@k);
    ->  set xing = @k;
    ->  call get_name(@name,@sex);
    ->  set ming = @name;
    ->  set sex = @sex;
    ->  set xm = concat(xing,ming);
    ->  insert into xs2 values(xh,xm,sex);
    ->  if f=2 then
    -> select xh,xm,'重名了';
    -> set f=1;
    -> elseif f=1 then
    -> set xh = xh+1;
    ->  end if;
    -> end while;
    -> end $$
Query OK, 0 rows affected, 1 warning (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;
mysql> call main2();
+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191100 | 何超    | 重名了       |
+--------+------+--------+
1 row in set (0.03 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191118 | 刘广     | 重名了       |
+--------+------+--------+
1 row in set (0.03 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191128 | 王阳     | 重名了       |
+--------+------+--------+
1 row in set (0.03 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191151 | 陈德    | 重名了       |
+--------+------+--------+
1 row in set (0.04 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191151 | 胡念     | 重名了       |
+--------+------+--------+
1 row in set (0.04 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191180 | 陈巧     | 重名了       |
+--------+------+--------+
1 row in set (0.04 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191187 | 毛澄    | 重名了       |
+--------+------+--------+
1 row in set (0.04 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191213 | 朱荷     | 重名了       |
+--------+------+--------+
1 row in set (0.04 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191220 | 何超    | 重名了       |
+--------+------+--------+
1 row in set (0.04 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191224 | 曾涵     | 重名了       |
+--------+------+--------+
1 row in set (0.05 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191272 | 李言     | 重名了       |
+--------+------+--------+
1 row in set (0.05 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191276 | 陈德    | 重名了       |
+--------+------+--------+
1 row in set (0.05 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191301 | 何超    | 重名了       |
+--------+------+--------+
1 row in set (0.05 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191306 | 刘碧     | 重名了       |
+--------+------+--------+
1 row in set (0.05 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191309 | 陈昌    | 重名了       |
+--------+------+--------+
1 row in set (0.06 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191312 | 何碧    | 重名了       |
+--------+------+--------+
1 row in set (0.06 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191322 | 赵莉     | 重名了       |
+--------+------+--------+
1 row in set (0.06 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191339 | 曾雅     | 重名了       |
+--------+------+--------+
1 row in set (0.06 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191350 | 黄煦浩       | 重名了       |
+--------+--------+--------+
1 row in set (0.06 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191355 | 刘艳     | 重名了       |
+--------+------+--------+
1 row in set (0.06 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191356 | 李峰     | 重名了       |
+--------+------+--------+
1 row in set (0.06 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191356 | 邓紫     | 重名了       |
+--------+------+--------+
1 row in set (0.07 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191360 | 何锋    | 重名了       |
+--------+------+--------+
1 row in set (0.07 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191362 | 朱煦锋       | 重名了       |
+--------+--------+--------+
1 row in set (0.07 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191367 | 胡博     | 重名了       |
+--------+------+--------+
1 row in set (0.07 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191371 | 孙莉     | 重名了       |
+--------+------+--------+
1 row in set (0.07 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191399 | 毛诚    | 重名了       |
+--------+------+--------+
1 row in set (0.07 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191412 | 刘琪     | 重名了       |
+--------+------+--------+
1 row in set (0.08 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191417 | 周秋     | 重名了       |
+--------+------+--------+
1 row in set (0.08 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191422 | 邓秋     | 重名了       |
+--------+------+--------+
1 row in set (0.08 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191428 | 毛红    | 重名了       |
+--------+------+--------+
1 row in set (0.08 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191430 | 毛浩    | 重名了       |
+--------+------+--------+
1 row in set (0.08 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191436 | 朱阳     | 重名了       |
+--------+------+--------+
1 row in set (0.08 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191441 | 李诚     | 重名了       |
+--------+------+--------+
1 row in set (0.08 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191441 | 钱杰    | 重名了       |
+--------+------+--------+
1 row in set (0.09 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191473 | 刘巧     | 重名了       |
+--------+------+--------+
1 row in set (0.09 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191475 | 曾涵     | 重名了       |
+--------+------+--------+
1 row in set (0.09 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191476 | 陈涵    | 重名了       |
+--------+------+--------+
1 row in set (0.09 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191491 | 王畅     | 重名了       |
+--------+------+--------+
1 row in set (0.10 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191494 | 曾秋     | 重名了       |
+--------+------+--------+
1 row in set (0.10 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191503 | 刘雅     | 重名了       |
+--------+------+--------+
1 row in set (0.10 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191506 | 钱杰    | 重名了       |
+--------+------+--------+
1 row in set (0.10 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191507 | 陈德    | 重名了       |
+--------+------+--------+
1 row in set (0.10 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191509 | 周琪     | 重名了       |
+--------+------+--------+
1 row in set (0.10 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191509 | 毛德    | 重名了       |
+--------+------+--------+
1 row in set (0.10 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191509 | 赵巧     | 重名了       |
+--------+------+--------+
1 row in set (0.10 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191523 | 毛莉    | 重名了       |
+--------+------+--------+
1 row in set (0.11 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191528 | 黄涵    | 重名了       |
+--------+------+--------+
1 row in set (0.11 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191538 | 刘萱     | 重名了       |
+--------+------+--------+
1 row in set (0.11 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191554 | 胡瀚     | 重名了       |
+--------+------+--------+
1 row in set (0.11 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191554 | 李碧     | 重名了       |
+--------+------+--------+
1 row in set (0.11 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191559 | 毛莉    | 重名了       |
+--------+------+--------+
1 row in set (0.12 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191559 | 张萱     | 重名了       |
+--------+------+--------+
1 row in set (0.12 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191568 | 李诚     | 重名了       |
+--------+------+--------+
1 row in set (0.12 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191571 | 曾碧     | 重名了       |
+--------+------+--------+
1 row in set (0.12 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191571 | 吴依     | 重名了       |
+--------+------+--------+
1 row in set (0.12 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191571 | 李阳     | 重名了       |
+--------+------+--------+
1 row in set (0.12 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191571 | 何邈     | 重名了       |
+--------+------+--------+
1 row in set (0.12 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191585 | 胡亮     | 重名了       |
+--------+------+--------+
1 row in set (0.13 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191590 | 胡雅     | 重名了       |
+--------+------+--------+
1 row in set (0.13 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191593 | 毛蕾    | 重名了       |
+--------+------+--------+
1 row in set (0.13 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191595 | 刘莹    | 重名了       |
+--------+------+--------+
1 row in set (0.13 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191609 | 周德    | 重名了       |
+--------+------+--------+
1 row in set (0.13 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191614 | 邓香     | 重名了       |
+--------+------+--------+
1 row in set (0.13 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191617 | 刘紫     | 重名了       |
+--------+------+--------+
1 row in set (0.13 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191618 | 江澄     | 重名了       |
+--------+------+--------+
1 row in set (0.13 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191622 | 毛毅    | 重名了       |
+--------+------+--------+
1 row in set (0.14 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191622 | 李莲     | 重名了       |
+--------+------+--------+
1 row in set (0.14 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191623 | 何莉     | 重名了       |
+--------+------+--------+
1 row in set (0.14 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191625 | 朱瀚     | 重名了       |
+--------+------+--------+
1 row in set (0.14 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191626 | 刘莲     | 重名了       |
+--------+------+--------+
1 row in set (0.14 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191630 | 赵博    | 重名了       |
+--------+------+--------+
1 row in set (0.14 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191632 | 钱巧    | 重名了       |
+--------+------+--------+
1 row in set (0.14 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191633 | 钱俊    | 重名了       |
+--------+------+--------+
1 row in set (0.15 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191634 | 陈莉     | 重名了       |
+--------+------+--------+
1 row in set (0.15 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191637 | 刘雅     | 重名了       |
+--------+------+--------+
1 row in set (0.15 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191639 | 毛诚    | 重名了       |
+--------+------+--------+
1 row in set (0.15 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191641 | 赵秋     | 重名了       |
+--------+------+--------+
1 row in set (0.15 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191645 | 王超     | 重名了       |
+--------+------+--------+
1 row in set (0.15 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191648 | 刘紫     | 重名了       |
+--------+------+--------+
1 row in set (0.16 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191650 | 刘亮     | 重名了       |
+--------+------+--------+
1 row in set (0.16 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191656 | 刘诚     | 重名了       |
+--------+------+--------+
1 row in set (0.16 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191659 | 钱艳    | 重名了       |
+--------+------+--------+
1 row in set (0.16 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191664 | 吴言     | 重名了       |
+--------+------+--------+
1 row in set (0.16 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191665 | 王琪     | 重名了       |
+--------+------+--------+
1 row in set (0.16 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191665 | 刘巧     | 重名了       |
+--------+------+--------+
1 row in set (0.16 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191666 | 周紫丽       | 重名了       |
+--------+--------+--------+
1 row in set (0.16 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191667 | 孙阳     | 重名了       |
+--------+------+--------+
1 row in set (0.17 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191668 | 江秋     | 重名了       |
+--------+------+--------+
1 row in set (0.17 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191669 | 江雅     | 重名了       |
+--------+------+--------+
1 row in set (0.17 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191672 | 刘澄     | 重名了       |
+--------+------+--------+
1 row in set (0.17 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191673 | 钱蕾    | 重名了       |
+--------+------+--------+
1 row in set (0.17 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191691 | 何浩    | 重名了       |
+--------+------+--------+
1 row in set (0.17 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191691 | 陈峰    | 重名了       |
+--------+------+--------+
1 row in set (0.17 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191697 | 刘莲     | 重名了       |
+--------+------+--------+
1 row in set (0.17 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191699 | 何俊    | 重名了       |
+--------+------+--------+
1 row in set (0.17 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191704 | 刘丽     | 重名了       |
+--------+------+--------+
1 row in set (0.18 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191705 | 邓亮     | 重名了       |
+--------+------+--------+
1 row in set (0.18 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191706 | 张超    | 重名了       |
+--------+------+--------+
1 row in set (0.18 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191713 | 毛紫    | 重名了       |
+--------+------+--------+
1 row in set (0.18 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191714 | 邓邈     | 重名了       |
+--------+------+--------+
1 row in set (0.18 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191720 | 刘丽     | 重名了       |
+--------+------+--------+
1 row in set (0.18 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191724 | 刘莲     | 重名了       |
+--------+------+--------+
1 row in set (0.19 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191724 | 吴依     | 重名了       |
+--------+------+--------+
1 row in set (0.19 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191724 | 李琪     | 重名了       |
+--------+------+--------+
1 row in set (0.19 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191733 | 张德    | 重名了       |
+--------+------+--------+
1 row in set (0.19 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191737 | 黄峰广      | 重名了       |
+--------+--------+--------+
1 row in set (0.19 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191743 | 何邈     | 重名了       |
+--------+------+--------+
1 row in set (0.19 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191757 | 胡亮     | 重名了       |
+--------+------+--------+
1 row in set (0.19 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191762 | 周煦     | 重名了       |
+--------+------+--------+
1 row in set (0.20 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191779 | 朱荷     | 重名了       |
+--------+------+--------+
1 row in set (0.20 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191779 | 朱燕     | 重名了       |
+--------+------+--------+
1 row in set (0.20 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191780 | 胡亮     | 重名了       |
+--------+------+--------+
1 row in set (0.20 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191782 | 王峰瀚       | 重名了       |
+--------+--------+--------+
1 row in set (0.20 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191790 | 江言     | 重名了       |
+--------+------+--------+
1 row in set (0.20 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191792 | 何邈     | 重名了       |
+--------+------+--------+
1 row in set (0.20 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191792 | 胡博     | 重名了       |
+--------+------+--------+
1 row in set (0.21 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191797 | 陈琪     | 重名了       |
+--------+------+--------+
1 row in set (0.21 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191798 | 江雅     | 重名了       |
+--------+------+--------+
1 row in set (0.21 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191808 | 钱荷    | 重名了       |
+--------+------+--------+
1 row in set (0.21 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191811 | 刘毅     | 重名了       |
+--------+------+--------+
1 row in set (0.21 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191811 | 曾德     | 重名了       |
+--------+------+--------+
1 row in set (0.21 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191818 | 王诚     | 重名了       |
+--------+------+--------+
1 row in set (0.21 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191824 | 李广     | 重名了       |
+--------+------+--------+
1 row in set (0.21 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191826 | 黄丽     | 重名了       |
+--------+------+--------+
1 row in set (0.22 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191827 | 刘锋     | 重名了       |
+--------+------+--------+
1 row in set (0.22 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191832 | 刘涵     | 重名了       |
+--------+------+--------+
1 row in set (0.22 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191850 | 周阳     | 重名了       |
+--------+------+--------+
1 row in set (0.22 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191850 | 周秋     | 重名了       |
+--------+------+--------+
1 row in set (0.22 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191855 | 刘莹    | 重名了       |
+--------+------+--------+
1 row in set (0.22 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191855 | 钱颖   | 重名了       |
+--------+------+--------+
1 row in set (0.22 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191859 | 邓澄    | 重名了       |
+--------+------+--------+
1 row in set (0.23 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191859 | 江秋     | 重名了       |
+--------+------+--------+
1 row in set (0.23 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191866 | 曾畅     | 重名了       |
+--------+------+--------+
1 row in set (0.23 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191874 | 黄涵    | 重名了       |
+--------+------+--------+
1 row in set (0.23 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191877 | 刘丽     | 重名了       |
+--------+------+--------+
1 row in set (0.23 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191882 | 陈琪     | 重名了       |
+--------+------+--------+
1 row in set (0.23 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191886 | 张紫荷      | 重名了       |
+--------+--------+--------+
1 row in set (0.23 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191887 | 赵俊    | 重名了       |
+--------+------+--------+
1 row in set (0.23 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191888 | 刘杰昌      | 重名了       |
+--------+--------+--------+
1 row in set (0.24 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191896 | 胡莉     | 重名了       |
+--------+------+--------+
1 row in set (0.24 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191899 | 张毅     | 重名了       |
+--------+------+--------+
1 row in set (0.24 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191899 | 黄紫燕       | 重名了       |
+--------+--------+--------+
1 row in set (0.24 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191900 | 赵秋     | 重名了       |
+--------+------+--------+
1 row in set (0.24 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191902 | 刘莹    | 重名了       |
+--------+------+--------+
1 row in set (0.24 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191911 | 朱荷     | 重名了       |
+--------+------+--------+
1 row in set (0.24 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191916 | 陈巧     | 重名了       |
+--------+------+--------+
1 row in set (0.24 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191916 | 张萱     | 重名了       |
+--------+------+--------+
1 row in set (0.25 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191917 | 周紫     | 重名了       |
+--------+------+--------+
1 row in set (0.25 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191923 | 王诚     | 重名了       |
+--------+------+--------+
1 row in set (0.25 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191923 | 曾念     | 重名了       |
+--------+------+--------+
1 row in set (0.25 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191928 | 黄亮     | 重名了       |
+--------+------+--------+
1 row in set (0.25 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191929 | 朱衍     | 重名了       |
+--------+------+--------+
1 row in set (0.25 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191932 | 吴俊    | 重名了       |
+--------+------+--------+
1 row in set (0.26 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191933 | 毛言    | 重名了       |
+--------+------+--------+
1 row in set (0.26 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191935 | 刘毅     | 重名了       |
+--------+------+--------+
1 row in set (0.26 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191938 | 曾涵     | 重名了       |
+--------+------+--------+
1 row in set (0.26 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191939 | 黄颖    | 重名了       |
+--------+------+--------+
1 row in set (0.26 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191940 | 刘紫     | 重名了       |
+--------+------+--------+
1 row in set (0.26 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191943 | 曾莉秋       | 重名了       |
+--------+--------+--------+
1 row in set (0.27 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191946 | 张紫     | 重名了       |
+--------+------+--------+
1 row in set (0.27 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191946 | 胡峰     | 重名了       |
+--------+------+--------+
1 row in set (0.27 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191947 | 陈艳     | 重名了       |
+--------+------+--------+
1 row in set (0.27 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191950 | 钱昌    | 重名了       |
+--------+------+--------+
1 row in set (0.27 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191953 | 李紫萱       | 重名了       |
+--------+--------+--------+
1 row in set (0.27 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191957 | 毛红    | 重名了       |
+--------+------+--------+
1 row in set (0.27 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191957 | 邓秋碧       | 重名了       |
+--------+--------+--------+
1 row in set (0.27 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191957 | 周邈     | 重名了       |
+--------+------+--------+
1 row in set (0.28 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191963 | 张邈     | 重名了       |
+--------+------+--------+
1 row in set (0.28 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191963 | 何阳     | 重名了       |
+--------+------+--------+
1 row in set (0.28 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191976 | 黄瀚     | 重名了       |
+--------+------+--------+
1 row in set (0.28 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191979 | 朱浩     | 重名了       |
+--------+------+--------+
1 row in set (0.28 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191979 | 江碧     | 重名了       |
+--------+------+--------+
1 row in set (0.28 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191980 | 张涵    | 重名了       |
+--------+------+--------+
1 row in set (0.28 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191984 | 何艳     | 重名了       |
+--------+------+--------+
1 row in set (0.29 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191985 | 孙莉     | 重名了       |
+--------+------+--------+
1 row in set (0.29 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191985 | 江畅     | 重名了       |
+--------+------+--------+
1 row in set (0.29 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191986 | 吴言     | 重名了       |
+--------+------+--------+
1 row in set (0.29 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191986 | 胡雅     | 重名了       |
+--------+------+--------+
1 row in set (0.29 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191989 | 何紫     | 重名了       |
+--------+------+--------+
1 row in set (0.29 sec)

+--------+--------+--------+
| xh     | xm     | 重名了       |
+--------+--------+--------+
| 191991 | 刘涵瀚       | 重名了       |
+--------+--------+--------+
1 row in set (0.29 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191991 | 赵琪     | 重名了       |
+--------+------+--------+
1 row in set (0.30 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191999 | 刘香     | 重名了       |
+--------+------+--------+
1 row in set (0.30 sec)

+--------+------+--------+
| xh     | xm   | 重名了       |
+--------+------+--------+
| 191999 | 江瀚     | 重名了       |
+--------+------+--------+
1 row in set (0.30 sec)

Query OK, 1 row affected (0.30 sec)

mysql> select * from xs2;
+--------+--------+------+
| 学号      | 姓名       | 性别    |
+--------+--------+------+
| 191100 | 钱紫巧      |    0 |
| 191100 | 张碧秋      |    0 |
| 191100 | 赵亮博       |    1 |
| 191100 | 吴红依       |    0 |
| 191100 | 朱海诚     |    1 |
| 191100 | 曾畅浩       |    1 |
| 191100 | 周衍       |    1 |
| 191100 | 周亮       |    1 |
| 191100 | 黄澄超     |    1 |
| 191100 | 刘莹艳      |    0 |
| 191100 | 刘诚畅      |    1 |
| 191100 | 赵俊      |    1 |
| 191100 | 黄涵      |    1 |
| 191100 | 黄涵瀚      |    1 |
| 191100 | 李紫萱       |    0 |
| 191100 | 周秋       |    0 |
| 191100 | 何超      |    1 |
| 191100 | 周琪       |    0 |
| 191100 | 邓蕾       |    0 |
| 191100 | 吴琪       |    0 |
| 191100 | 毛澄      |    1 |
| 191100 | 朱巧       |    0 |
| 191100 | 赵秋       |    0 |
| 191100 | 朱荷       |    0 |
| 191100 | 张莹碧      |    0 |
| 191100 | 李荷颖      |    0 |
| 191100 | 何紫雅       |    0 |
| 191100 | 王阳       |    1 |
| 191100 | 曾畅       |    1 |
| 191100 | 江雅琪       |    0 |
| 191100 | 钱巧      |    0 |
| 191100 | 毛德      |    1 |
| 191100 | 邓蕾莉       |    0 |
| 191100 | 王畅       |    1 |
| 191100 | 王紫       |    0 |
| 191100 | 钱念      |    0 |
| 191100 | 赵衍       |    1 |
| 191100 | 胡毅       |    1 |
| 191100 | 何澄昌     |    1 |
| 191101 | 刘广       |    1 |
| 191102 | 江畅       |    1 |
| 191103 | 王毅德       |    1 |
| 191104 | 钱念萱      |    0 |
| 191105 | 胡念       |    0 |
| 191106 | 陈亮       |    1 |
| 191107 | 吴巧荷      |    0 |
| 191108 | 钱琪莉      |    0 |
| 191109 | 孙莉       |    0 |
| 191110 | 孙颖      |    0 |
| 191111 | 胡雅       |    0 |
| 191112 | 何玉丽       |    0 |
| 191113 | 王琪       |    0 |
| 191114 | 吴秋       |    0 |
| 191115 | 刘巧       |    0 |
| 191116 | 张碧紫      |    0 |
| 191117 | 毛阳      |    1 |
| 191118 | 江琪       |    0 |
| 191119 | 孙萱红       |    0 |
| 191120 | 王邈       |    1 |
| 191121 | 王玉萱       |    0 |
| 191122 | 李红       |    0 |
| 191123 | 曾涵       |    1 |
| 191124 | 刘阳杰       |    1 |
| 191125 | 周德言      |    1 |
| 191126 | 朱邈澄       |    1 |
| 191127 | 吴俊      |    1 |
| 191128 | 刘言       |    1 |
| 191129 | 吴碧       |    0 |
| 191130 | 朱瀚       |    1 |
| 191131 | 吴昌       |    1 |
| 191132 | 陈德      |    1 |
| 191133 | 吴澄       |    1 |
| 191134 | 黄煦浩       |    1 |
| 191135 | 何畅博      |    1 |
| 191136 | 刘涵海       |    1 |
| 191137 | 何瀚浩     |    1 |
| 191138 | 周亮涵       |    1 |
| 191139 | 胡邈       |    1 |
| 191140 | 陈雅莲       |    0 |
| 191141 | 江澄       |    1 |
| 191142 | 张邈       |    1 |
| 191143 | 王海       |    1 |
| 191144 | 江艳       |    0 |
| 191145 | 李莉       |    0 |
| 191146 | 毛涵      |    1 |
| 191147 | 李碧莉       |    0 |
| 191148 | 何邈畅     |    1 |
| 191149 | 李莲       |    0 |
| 191150 | 毛莲荷      |    0 |
| 191151 | 陈峰      |    1 |
| 191152 | 黄莲艳       |    0 |
| 191153 | 张毅       |    1 |
| 191154 | 李颖碧      |    0 |
| 191155 | 张德      |    1 |
| 191156 | 江浩海      |    1 |
| 191157 | 赵诚邈      |    1 |
| 191158 | 陈莲香       |    0 |
| 191159 | 陈巧       |    0 |
| 191160 | 胡峰海     |    1 |
| 191161 | 孙涵澄      |    1 |
| 191162 | 周红      |    0 |
| 191163 | 孙广俊     |    1 |
| 191164 | 钱杰      |    1 |
| 191165 | 朱涵昌     |    1 |
| 191166 | 毛阳海      |    1 |
| 191167 | 刘毅杰       |    1 |
| 191168 | 曾玉依       |    0 |
| 191169 | 刘荷蕾       |    0 |
| 191170 | 刘艳       |    0 |
| 191171 | 毛碧荷     |    0 |
| 191172 | 孙念雅       |    0 |
| 191173 | 钱昌      |    1 |
| 191174 | 张依       |    0 |
| 191175 | 刘广毅       |    1 |
| 191176 | 刘毅超     |    1 |
| 191177 | 江萱香       |    0 |
| 191178 | 周亮言       |    1 |
| 191179 | 吴莉莹      |    0 |
| 191180 | 赵巧莹      |    0 |
| 191181 | 周琪琪       |    0 |
| 191182 | 毛言      |    1 |
| 191183 | 周德      |    1 |
| 191184 | 毛海      |    1 |
| 191185 | 刘丽       |    0 |
| 191186 | 江杰瀚       |    1 |
| 191187 | 胡博       |    1 |
| 191188 | 张颖紫      |    0 |
| 191189 | 何依莉       |    0 |
| 191190 | 孙艳燕       |    0 |
| 191191 | 李紫       |    0 |
| 191192 | 钱颖颖    |    0 |
| 191193 | 毛诚      |    1 |
| 191194 | 李诚       |    1 |
| 191195 | 吴峰邈       |    1 |
| 191196 | 赵莉       |    0 |
| 191197 | 江依秋       |    0 |
| 191198 | 钱萱碧      |    0 |
| 191199 | 李碧碧      |    0 |
| 191200 | 周邈       |    1 |
| 191201 | 邓萱       |    0 |
| 191202 | 何碧      |    0 |
| 191203 | 赵碧荷     |    0 |
| 191204 | 刘莲       |    0 |
| 191205 | 孙燕红       |    0 |
| 191206 | 江亮阳       |    1 |
| 191207 | 刘紫       |    0 |
| 191208 | 王碧       |    0 |
| 191209 | 刘萱依       |    0 |
| 191210 | 何博      |    1 |
| 191211 | 刘念雅       |    0 |
| 191212 | 钱毅昌      |    1 |
| 191213 | 胡玉丽       |    0 |
| 191214 | 李德广      |    1 |
| 191215 | 邓莹莲      |    0 |
| 191216 | 毛燕      |    0 |
| 191217 | 陈德杰     |    1 |
| 191218 | 李言       |    1 |
| 191219 | 周广      |    1 |
| 191220 | 陈莉红       |    0 |
| 191221 | 王毅       |    1 |
| 191222 | 毛燕秋      |    0 |
| 191223 | 吴衍亮       |    1 |
| 191224 | 张紫       |    0 |
| 191225 | 曾莉秋       |    0 |
| 191226 | 朱阳       |    1 |
| 191227 | 江阳       |    1 |
| 191228 | 何言衍       |    1 |
| 191229 | 刘亮海       |    1 |
| 191230 | 曾萱       |    0 |
| 191231 | 胡峰锋       |    1 |
| 191232 | 毛蕾      |    0 |
| 191233 | 李莲艳       |    0 |
| 191234 | 赵畅      |    1 |
| 191235 | 刘萱念       |    0 |
| 191236 | 吴畅澄      |    1 |
| 191237 | 赵昌      |    1 |
| 191238 | 陈念莹      |    0 |
| 191239 | 胡雅莉       |    0 |
| 191240 | 胡广       |    1 |
| 191241 | 何紫琪       |    0 |
| 191242 | 钱阳德      |    1 |
| 191243 | 黄秋       |    0 |
| 191244 | 吴萱碧       |    0 |
| 191245 | 张阳超       |    1 |
| 191246 | 李阳       |    1 |
| 191247 | 胡瀚       |    1 |
| 191248 | 吴澄昌      |    1 |
| 191249 | 刘涵瀚       |    1 |
| 191250 | 王俊德       |    1 |
| 191251 | 刘碧       |    0 |
| 191252 | 邓香       |    0 |
| 191253 | 张颖巧      |    0 |
| 191254 | 王畅德       |    1 |
| 191255 | 曾紫       |    0 |
| 191256 | 赵诚海     |    1 |
| 191257 | 邓紫玉       |    0 |
| 191258 | 刘莉红       |    0 |
| 191259 | 毛毅      |    1 |
| 191260 | 黄碧      |    0 |
| 191261 | 江莲莲       |    0 |
| 191262 | 孙碧       |    0 |
| 191263 | 何依雅       |    0 |
| 191264 | 陈莲丽       |    0 |
| 191265 | 胡德       |    1 |
| 191266 | 王碧莉       |    0 |
| 191267 | 李蕾蕾       |    0 |
| 191268 | 黄博      |    1 |
| 191269 | 朱玉蕾       |    0 |
| 191270 | 江碧       |    0 |
| 191271 | 曾碧香       |    0 |
| 191272 | 刘莹      |    0 |
| 191273 | 刘琪       |    0 |
| 191274 | 毛琪艳      |    0 |
| 191275 | 朱煦锋       |    1 |
| 191276 | 胡巧依       |    0 |
| 191277 | 吴澄言       |    1 |
| 191278 | 朱毅锋       |    1 |
| 191279 | 胡杰锋      |    1 |
| 191280 | 朱言       |    1 |
| 191281 | 毛俊      |    1 |
| 191282 | 黄峰广      |    1 |
| 191283 | 毛浩      |    1 |
| 191284 | 曾蕾紫       |    0 |
| 191285 | 黄瀚       |    1 |
| 191286 | 孙雅莲       |    0 |
| 191287 | 胡博昌       |    1 |
| 191288 | 何艳       |    0 |
| 191289 | 周莹      |    0 |
| 191290 | 胡紫巧       |    0 |
| 191291 | 李浩涵      |    1 |
| 191292 | 毛萱雅      |    0 |
| 191293 | 毛德衍      |    1 |
| 191294 | 孙海浩      |    1 |
| 191295 | 曾秋       |    0 |
| 191296 | 邓德      |    1 |
| 191297 | 李碧       |    0 |
| 191298 | 毛秋荷      |    0 |
| 191299 | 陈昌      |    1 |
| 191300 | 曾锋       |    1 |
| 191301 | 王玉       |    0 |
| 191302 | 江涵杰       |    1 |
| 191303 | 钱浩浩     |    1 |
| 191304 | 陈巧艳       |    0 |
| 191305 | 毛琪      |    0 |
| 191306 | 张亮       |    1 |
| 191307 | 张锋      |    1 |
| 191308 | 毛澄亮      |    1 |
| 191309 | 胡蕾       |    0 |
| 191310 | 曾雅       |    0 |
| 191311 | 周毅       |    1 |
| 191312 | 赵邈       |    1 |
| 191313 | 胡颖      |    0 |
| 191314 | 毛红      |    0 |
| 191315 | 张碧      |    0 |
| 191316 | 邓紫       |    0 |
| 191317 | 钱秋燕      |    0 |
| 191318 | 毛燕燕      |    0 |
| 191319 | 赵琪       |    0 |
| 191320 | 邓诚畅     |    1 |
| 191321 | 刘巧颖      |    0 |
| 191322 | 刘雅       |    0 |
| 191323 | 孙萱秋       |    0 |
| 191324 | 刘萱莉       |    0 |
| 191325 | 吴依       |    0 |
| 191326 | 黄亮杰       |    1 |
| 191327 | 陈荷紫      |    0 |
| 191328 | 刘毅俊     |    1 |
| 191329 | 周煦       |    1 |
| 191330 | 张紫荷      |    0 |
| 191331 | 钱艳燕      |    0 |
| 191332 | 胡燕       |    0 |
| 191333 | 赵博      |    1 |
| 191334 | 李峰       |    1 |
| 191335 | 陈涵      |    1 |
| 191336 | 江言浩      |    1 |
| 191337 | 赵澄      |    1 |
| 191338 | 邓香琪       |    0 |
| 191339 | 江毅毅       |    1 |
| 191340 | 李玉       |    0 |
| 191341 | 张丽紫       |    0 |
| 191342 | 胡蕾念       |    0 |
| 191343 | 胡莉紫       |    0 |
| 191344 | 钱杰峰     |    1 |
| 191345 | 毛丽玉      |    0 |
| 191346 | 朱超     |    1 |
| 191347 | 毛德昌     |    1 |
| 191348 | 毛瀚      |    1 |
| 191349 | 江依红       |    0 |
| 191350 | 曾碧       |    0 |
| 191351 | 何锋      |    1 |
| 191352 | 周雅莲       |    0 |
| 191353 | 胡德衍       |    1 |
| 191354 | 何邈       |    1 |
| 191355 | 毛莉      |    0 |
| 191356 | 江诚德      |    1 |
| 191357 | 曾玉       |    0 |
| 191358 | 邓秋       |    0 |
| 191359 | 吴红紫       |    0 |
| 191360 | 赵巧       |    0 |
| 191361 | 张澄瀚      |    1 |
| 191362 | 何巧紫       |    0 |
| 191363 | 吴香琪       |    0 |
| 191364 | 陈煦       |    1 |
| 191365 | 吴红巧       |    0 |
| 191366 | 刘昌       |    1 |
| 191367 | 刘超德       |    1 |
| 191368 | 胡杰       |    1 |
| 191369 | 朱琪       |    0 |
| 191370 | 王煦畅     |    1 |
| 191371 | 朱荷秋       |    0 |
| 191372 | 赵德      |    1 |
| 191373 | 张阳俊       |    1 |
| 191374 | 王超毅       |    1 |
| 191375 | 黄杰诚     |    1 |
| 191376 | 何紫丽       |    0 |
| 191377 | 邓艳琪       |    0 |
| 191378 | 毛紫      |    0 |
| 191379 | 刘萱       |    0 |
| 191380 | 钱峰浩      |    1 |
| 191381 | 邓丽莉       |    0 |
| 191382 | 张博言      |    1 |
| 191383 | 邓燕萱       |    0 |
| 191384 | 朱广       |    1 |
| 191385 | 江丽香       |    0 |
| 191386 | 钱莹蕾     |    0 |
| 191387 | 朱紫碧      |    0 |
| 191388 | 何毅煦       |    1 |
| 191389 | 何博锋      |    1 |
| 191390 | 张莹莹     |    0 |
| 191391 | 周巧琪       |    0 |
| 191392 | 何德言      |    1 |
| 191393 | 钱亮      |    1 |
| 191394 | 张超      |    1 |
| 191395 | 吴荷雅       |    0 |
| 191396 | 钱艳      |    0 |
| 191397 | 钱涵言      |    1 |
| 191398 | 李琪       |    0 |
| 191399 | 吴锋煦       |    1 |
| 191400 | 李浩       |    1 |
| 191401 | 吴蕾琪       |    0 |
| 191402 | 吴涵     |    1 |
| 191403 | 孙念念       |    0 |
| 191404 | 江秋       |    0 |
| 191405 | 胡峰       |    1 |
| 191406 | 江颖      |    0 |
| 191407 | 刘雅香       |    0 |
| 191408 | 王莲       |    0 |
| 191409 | 王峰瀚       |    1 |
| 191410 | 何丽       |    0 |
| 191411 | 李煦       |    1 |
| 191412 | 黄俊      |    1 |
| 191413 | 吴澄亮       |    1 |
| 191414 | 陈亮峰       |    1 |
| 191415 | 孙巧红      |    0 |
| 191416 | 朱碧       |    0 |
| 191417 | 江煦       |    1 |
| 191418 | 曾博       |    1 |
| 191419 | 邓言畅      |    1 |
| 191420 | 李萱雅       |    0 |
| 191421 | 江艳雅       |    0 |
| 191422 | 黄峰      |    1 |
| 191423 | 王红紫       |    0 |
| 191424 | 孙蕾       |    0 |
| 191425 | 陈俊昌      |    1 |
| 191426 | 黄峰亮      |    1 |
| 191427 | 刘诚       |    1 |
| 191428 | 孙衍       |    1 |
| 191429 | 江红       |    0 |
| 191430 | 孙澄涵      |    1 |
| 191431 | 王丽碧       |    0 |
| 191432 | 邓阳杰       |    1 |
| 191433 | 江莉莲       |    0 |
| 191434 | 吴杰       |    1 |
| 191435 | 江海       |    1 |
| 191436 | 王超       |    1 |
| 191437 | 周紫丽       |    0 |
| 191438 | 曾蕾琪       |    0 |
| 191439 | 朱衍       |    1 |
| 191440 | 陈秋念       |    0 |
| 191441 | 刘丽巧       |    0 |
| 191442 | 陈雅蕾       |    0 |
| 191443 | 钱蕾      |    0 |
| 191444 | 刘雅紫       |    0 |
| 191445 | 陈莉       |    0 |
| 191446 | 陈瀚       |    1 |
| 191447 | 黄超昌      |    1 |
| 191448 | 吴念荷       |    0 |
| 191449 | 钱荷      |    0 |
| 191450 | 钱燕      |    0 |
| 191451 | 张涵      |    1 |
| 191452 | 王依       |    0 |
| 191453 | 王蕾       |    0 |
| 191454 | 刘衍超      |    1 |
| 191455 | 曾颖      |    0 |
| 191456 | 邓邈       |    1 |
| 191457 | 周依       |    0 |
| 191458 | 张亮涵       |    1 |
| 191459 | 张莉       |    0 |
| 191460 | 何秋       |    0 |
| 191461 | 刘紫巧       |    0 |
| 191462 | 何玉颖      |    0 |
| 191463 | 黄萱       |    0 |
| 191464 | 刘瀚畅     |    1 |
| 191465 | 张海浩      |    1 |
| 191466 | 曾念       |    0 |
| 191467 | 江言       |    1 |
| 191468 | 赵邈昌       |    1 |
| 191469 | 黄瀚海     |    1 |
| 191470 | 黄诚博     |    1 |
| 191471 | 胡亮       |    1 |
| 191472 | 钱玉荷      |    0 |
| 191473 | 朱玉       |    0 |
| 191474 | 刘雅蕾       |    0 |
| 191475 | 刘念       |    0 |
| 191476 | 何毅       |    1 |
| 191477 | 陈莉巧       |    0 |
| 191478 | 胡红       |    0 |
| 191479 | 张秋       |    0 |
| 191480 | 张颖      |    0 |
| 191481 | 钱颖     |    0 |
| 191482 | 刘海       |    1 |
| 191483 | 毛超瀚      |    1 |
| 191484 | 毛海浩      |    1 |
| 191485 | 曾颖巧      |    0 |
| 191486 | 江雅       |    0 |
| 191487 | 陈念红       |    0 |
| 191488 | 钱浩      |    1 |
| 191489 | 毛畅      |    1 |
| 191490 | 何艳紫       |    0 |
| 191491 | 曾丽丽       |    0 |
| 191492 | 邓亮       |    1 |
| 191493 | 黄言       |    1 |
| 191494 | 何衍德      |    1 |
| 191495 | 钱雅莉      |    0 |
| 191496 | 胡畅昌       |    1 |
| 191497 | 钱涵昌      |    1 |
| 191498 | 胡萱       |    0 |
| 191499 | 钱衍邈      |    1 |
| 191500 | 赵紫       |    0 |
| 191501 | 黄海博      |    1 |
| 191502 | 钱杰言      |    1 |
| 191503 | 黄红香      |    0 |
| 191504 | 周阳       |    1 |
| 191505 | 李澄瀚       |    1 |
| 191506 | 江毅瀚       |    1 |
| 191507 | 江琪燕       |    0 |
| 191508 | 王诚博      |    1 |
| 191509 | 刘依秋       |    0 |
| 191510 | 赵峰      |    1 |
| 191511 | 邓莲巧       |    0 |
| 191512 | 吴畅      |    1 |
| 191513 | 周煦诚       |    1 |
| 191514 | 黄燕萱       |    0 |
| 191515 | 孙紫莲       |    0 |
| 191516 | 刘畅阳       |    1 |
| 191517 | 王亮德       |    1 |
| 191518 | 何俊      |    1 |
| 191519 | 毛香琪      |    0 |
| 191520 | 曾澄       |    1 |
| 191521 | 孙邈       |    1 |
| 191522 | 陈莹莲      |    0 |
| 191523 | 赵杰广     |    1 |
| 191524 | 曾阳       |    1 |
| 191525 | 周念巧       |    0 |
| 191526 | 曾红红       |    0 |
| 191527 | 张依雅       |    0 |
| 191528 | 毛亮畅      |    1 |
| 191529 | 周玉萱       |    0 |
| 191530 | 李秋       |    0 |
| 191531 | 陈亮言       |    1 |
| 191532 | 何莉       |    0 |
| 191533 | 孙荷荷      |    0 |
| 191534 | 吴言       |    1 |
| 191535 | 张萱       |    0 |
| 191536 | 孙涵煦      |    1 |
| 191537 | 刘瀚       |    1 |
| 191538 | 曾澄亮       |    1 |
| 191539 | 陈畅      |    1 |
| 191540 | 江莲秋       |    0 |
| 191541 | 钱莹     |    0 |
| 191542 | 孙毅衍       |    1 |
| 191543 | 黄玉蕾       |    0 |
| 191544 | 周瀚       |    1 |
| 191545 | 孙阳       |    1 |
| 191546 | 江超       |    1 |
| 191547 | 何红颖     |    0 |
| 191548 | 王萱念       |    0 |
| 191549 | 黄亮       |    1 |
| 191550 | 吴诚       |    1 |
| 191551 | 刘瀚博     |    1 |
| 191552 | 江瀚       |    1 |
| 191553 | 刘言亮       |    1 |
| 191554 | 孙雅秋       |    0 |
| 191555 | 周诚      |    1 |
| 191556 | 曾香莹      |    0 |
| 191557 | 王诚昌      |    1 |
| 191558 | 孙邈峰       |    1 |
| 191559 | 胡超锋       |    1 |
| 191560 | 何俊亮      |    1 |
| 191561 | 刘紫燕       |    0 |
| 191562 | 曾瀚邈       |    1 |
| 191563 | 孙德言       |    1 |
| 191564 | 何依       |    0 |
| 191565 | 赵荷依      |    0 |
| 191566 | 周颖巧      |    0 |
| 191567 | 王诚       |    1 |
| 191568 | 刘俊       |    1 |
| 191569 | 何亮锋       |    1 |
| 191570 | 胡畅海       |    1 |
| 191571 | 李巧蕾       |    0 |
| 191572 | 何亮畅       |    1 |
| 191573 | 刘香       |    0 |
| 191574 | 毛萱      |    0 |
| 191575 | 张莹      |    0 |
| 191576 | 钱毅      |    1 |
| 191577 | 曾言涵      |    1 |
| 191578 | 孙昌       |    1 |
| 191579 | 朱浩       |    1 |
| 191580 | 陈博阳      |    1 |
| 191581 | 李碧红      |    0 |
| 191582 | 刘瀚俊     |    1 |
| 191583 | 毛杰      |    1 |
| 191584 | 王琪红       |    0 |
| 191585 | 朱燕燕       |    0 |
| 191586 | 张瀚杰     |    1 |
| 191587 | 陈丽萱       |    0 |
| 191588 | 胡巧       |    0 |
| 191589 | 李亮诚       |    1 |
| 191590 | 赵蕾颖      |    0 |
| 191591 | 钱衍畅     |    1 |
| 191592 | 吴紫莲       |    0 |
| 191593 | 黄颖      |    0 |
| 191594 | 陈毅       |    1 |
| 191595 | 孙蕾莹      |    0 |
| 191596 | 王峰诚       |    1 |
| 191597 | 周雅依       |    0 |
| 191598 | 吴衍       |    1 |
| 191599 | 曾涵海       |    1 |
| 191600 | 何玉       |    0 |
| 191601 | 胡雅紫       |    0 |
| 191602 | 何浩      |    1 |
| 191603 | 刘亮       |    1 |
| 191604 | 刘莉       |    0 |
| 191605 | 何广瀚      |    1 |
| 191606 | 刘燕       |    0 |
| 191607 | 江博昌       |    1 |
| 191608 | 钱俊      |    1 |
| 191609 | 曾艳荷      |    0 |
| 191610 | 江燕       |    0 |
| 191611 | 黄澄      |    1 |
| 191612 | 邓艳艳       |    0 |
| 191613 | 钱畅超      |    1 |
| 191614 | 赵涵      |    1 |
| 191615 | 江杰超      |    1 |
| 191616 | 赵艳燕       |    0 |
| 191617 | 刘俊瀚       |    1 |
| 191618 | 邓荷雅      |    0 |
| 191619 | 朱秋紫       |    0 |
| 191620 | 周巧莲       |    0 |
| 191621 | 张诚      |    1 |
| 191622 | 黄萱燕       |    0 |
| 191623 | 陈香琪       |    0 |
| 191624 | 何香玉       |    0 |
| 191625 | 邓依       |    0 |
| 191626 | 刘澄瀚       |    1 |
| 191627 | 李香萱       |    0 |
| 191628 | 周莉玉       |    0 |
| 191629 | 邓澄德     |    1 |
| 191630 | 周颖念      |    0 |
| 191631 | 黄峰德      |    1 |
| 191632 | 曾峰瀚       |    1 |
| 191633 | 朱博     |    1 |
| 191634 | 江丽       |    0 |
| 191635 | 胡玉香       |    0 |
| 191636 | 陈碧碧     |    0 |
| 191637 | 毛玉      |    0 |
| 191638 | 朱锋       |    1 |
| 191639 | 何阳       |    1 |
| 191640 | 邓念颖      |    0 |
| 191641 | 邓博      |    1 |
| 191642 | 刘毅       |    1 |
| 191643 | 吴莹      |    0 |
| 191644 | 黄广言      |    1 |
| 191645 | 周紫       |    0 |
| 191646 | 赵丽玉       |    0 |
| 191647 | 朱峰       |    1 |
| 191648 | 胡紫紫       |    0 |
| 191649 | 周巧香       |    0 |
| 191650 | 赵邈超     |    1 |
| 191651 | 李广       |    1 |
| 191652 | 黄博俊      |    1 |
| 191653 | 江荷       |    0 |
| 191654 | 毛广      |    1 |
| 191655 | 曾琪碧       |    0 |
| 191656 | 孙毅       |    1 |
| 191657 | 李德煦       |    1 |
| 191658 | 刘澄       |    1 |
| 191659 | 赵萱       |    0 |
| 191660 | 王衍       |    1 |
| 191661 | 张丽       |    0 |
| 191662 | 钱瀚      |    1 |
| 191663 | 毛莹丽     |    0 |
| 191664 | 毛萱蕾      |    0 |
| 191665 | 刘德诚      |    1 |
| 191666 | 曾香巧       |    0 |
| 191667 | 何巧秋       |    0 |
| 191668 | 周海      |    1 |
| 191669 | 吴锋       |    1 |
| 191670 | 何煦瀚       |    1 |
| 191671 | 胡丽念       |    0 |
| 191672 | 吴煦       |    1 |
| 191673 | 邓燕       |    0 |
| 191674 | 陈澄      |    1 |
| 191675 | 张博毅      |    1 |
| 191676 | 孙蕾巧       |    0 |
| 191677 | 曾丽碧       |    0 |
| 191678 | 吴锋亮       |    1 |
| 191679 | 陈博亮      |    1 |
| 191680 | 刘锋       |    1 |
| 191681 | 曾荷颖      |    0 |
| 191682 | 曾广俊     |    1 |
| 191683 | 朱浩畅      |    1 |
| 191684 | 吴蕾念       |    0 |
| 191685 | 王煦       |    1 |
| 191686 | 胡俊       |    1 |
| 191687 | 刘锋博     |    1 |
| 191688 | 曾峰       |    1 |
| 191689 | 曾莲紫       |    0 |
| 191690 | 刘俊广       |    1 |
| 191691 | 刘蕾艳       |    0 |
| 191692 | 胡诚毅       |    1 |
| 191693 | 何依莹      |    0 |
| 191694 | 朱红香       |    0 |
| 191695 | 周亮德       |    1 |
| 191696 | 朱亮海       |    1 |
| 191697 | 吴澄邈       |    1 |
| 191698 | 张雅       |    0 |
| 191699 | 江香       |    0 |
| 191700 | 李涵诚      |    1 |
| 191701 | 毛念巧      |    0 |
| 191702 | 李毅畅     |    1 |
| 191703 | 胡邈亮       |    1 |
| 191704 | 曾德       |    1 |
| 191705 | 邓浩      |    1 |
| 191706 | 钱杰澄     |    1 |
| 191707 | 曾紫琪       |    0 |
| 191708 | 赵莲琪       |    0 |
| 191709 | 吴念丽       |    0 |
| 191710 | 周海德      |    1 |
| 191711 | 刘红香       |    0 |
| 191712 | 邓衍涵      |    1 |
| 191713 | 胡涵       |    1 |
| 191714 | 胡海       |    1 |
| 191715 | 何莉雅       |    0 |
| 191716 | 黄超      |    1 |
| 191717 | 陈衍       |    1 |
| 191718 | 朱澄       |    1 |
| 191719 | 何念莹      |    0 |
| 191720 | 钱海诚      |    1 |
| 191721 | 黄念       |    0 |
| 191722 | 陈锋博    |    1 |
| 191723 | 曾俊博       |    1 |
| 191724 | 赵毅       |    1 |
| 191725 | 陈言涵      |    1 |
| 191726 | 孙涵      |    1 |
| 191727 | 黄秋紫       |    0 |
| 191728 | 江毅杰       |    1 |
| 191729 | 黄昌      |    1 |
| 191730 | 吴莉       |    0 |
| 191731 | 毛亮博      |    1 |
| 191732 | 刘言俊      |    1 |
| 191733 | 陈颖      |    0 |
| 191734 | 江阳亮       |    1 |
| 191735 | 刘玉碧       |    0 |
| 191736 | 毛念紫      |    0 |
| 191737 | 胡莉       |    0 |
| 191738 | 刘杰       |    1 |
| 191739 | 吴玉蕾       |    0 |
| 191740 | 胡峰煦       |    1 |
| 191741 | 钱碧艳      |    0 |
| 191742 | 王俊       |    1 |
| 191743 | 曾艳红      |    0 |
| 191744 | 周荷萱      |    0 |
| 191745 | 王峰       |    1 |
| 191746 | 周荷      |    0 |
| 191747 | 江蕾碧      |    0 |
| 191748 | 黄紫燕       |    0 |
| 191749 | 吴艳紫       |    0 |
| 191750 | 朱燕       |    0 |
| 191751 | 曾念蕾       |    0 |
| 191752 | 吴琪莹      |    0 |
| 191753 | 陈琪       |    0 |
| 191754 | 吴杰广      |    1 |
| 191755 | 黄涵邈      |    1 |
| 191756 | 张艳碧      |    0 |
| 191757 | 赵念紫       |    0 |
| 191758 | 周蕾雅       |    0 |
| 191759 | 李瀚煦       |    1 |
| 191760 | 何峰      |    1 |
| 191761 | 胡杰邈       |    1 |
| 191762 | 赵亮言       |    1 |
| 191763 | 陈玉艳       |    0 |
| 191764 | 张毅瀚       |    1 |
| 191765 | 陈浩      |    1 |
| 191766 | 何燕巧       |    0 |
| 191767 | 胡丽丽       |    0 |
| 191768 | 邓德澄     |    1 |
| 191769 | 毛艳玉      |    0 |
| 191770 | 吴紫       |    0 |
| 191771 | 孙雅燕       |    0 |
| 191772 | 陈浩阳      |    1 |
| 191773 | 吴玉       |    0 |
| 191774 | 钱锋      |    1 |
| 191775 | 朱衍超      |    1 |
| 191776 | 陈玉依       |    0 |
| 191777 | 张畅昌      |    1 |
| 191778 | 朱昌涵       |    1 |
| 191779 | 朱颖荷      |    0 |
| 191780 | 张莲颖      |    0 |
| 191781 | 何紫       |    0 |
| 191782 | 钱海      |    1 |
| 191783 | 钱萱      |    0 |
| 191784 | 赵红巧      |    0 |
| 191785 | 李煦阳       |    1 |
| 191786 | 吴红       |    0 |
| 191787 | 江邈       |    1 |
| 191788 | 何红      |    0 |
| 191789 | 何昌亮      |    1 |
| 191790 | 赵海      |    1 |
| 191791 | 陈艳念       |    0 |
| 191792 | 吴依琪       |    0 |
| 191793 | 周蕾       |    0 |
| 191794 | 邓海昌      |    1 |
| 191795 | 毛瀚衍      |    1 |
| 191796 | 周畅      |    1 |
| 191797 | 刘颖巧      |    0 |
| 191798 | 邓澄      |    1 |
| 191799 | 周依念       |    0 |
| 191800 | 钱莉雅      |    0 |
| 191801 | 黄阳       |    1 |
| 191802 | 江燕荷       |    0 |
| 191803 | 毛紫秋      |    0 |
| 191804 | 黄丽       |    0 |
| 191805 | 胡亮博       |    1 |
| 191806 | 陈燕荷       |    0 |
| 191807 | 胡锋       |    1 |
| 191808 | 孙瀚广     |    1 |
| 191809 | 朱莲燕       |    0 |
| 191810 | 王博       |    1 |
| 191811 | 周杰      |    1 |
| 191812 | 李亮       |    1 |
| 191813 | 刘涵       |    1 |
| 191814 | 江紫燕       |    0 |
| 191815 | 曾浩       |    1 |
| 191816 | 钱澄德     |    1 |
| 191817 | 李昌       |    1 |
| 191818 | 钱依      |    0 |
| 191819 | 江畅澄       |    1 |
| 191820 | 朱紫       |    0 |
| 191821 | 朱畅亮     |    1 |
| 191822 | 周峰      |    1 |
| 191823 | 胡衍       |    1 |
| 191824 | 刘巧巧       |    0 |
| 191825 | 孙超      |    1 |
| 191826 | 王煦阳       |    1 |
| 191827 | 刘浩       |    1 |
| 191828 | 王广       |    1 |
| 191829 | 江蕾       |    0 |
| 191830 | 黄广昌      |    1 |
| 191831 | 刘杰昌      |    1 |
| 191832 | 李涵      |    1 |
| 191833 | 黄紫紫       |    0 |
| 191834 | 陈玉       |    0 |
| 191835 | 周颖莲      |    0 |
| 191836 | 黄莉丽       |    0 |
| 191837 | 钱紫艳      |    0 |
| 191838 | 刘峰衍       |    1 |
| 191839 | 陈锋畅    |    1 |
| 191840 | 刘杰博      |    1 |
| 191841 | 赵蕾红      |    0 |
| 191842 | 孙邈畅     |    1 |
| 191843 | 朱衍阳       |    1 |
| 191844 | 刘莉紫       |    0 |
| 191845 | 李昌杰       |    1 |
| 191846 | 毛广言      |    1 |
| 191847 | 张巧香       |    0 |
| 191848 | 王莹      |    0 |
| 191849 | 周俊海      |    1 |
| 191850 | 陈艳       |    0 |
| 191851 | 毛衍      |    1 |
| 191852 | 邓红      |    0 |
| 191853 | 刘德俊      |    1 |
| 191854 | 吴雅雅       |    0 |
| 191855 | 王秋莲       |    0 |
| 191856 | 何煦亮       |    1 |
| 191857 | 朱澄昌      |    1 |
| 191858 | 赵颖香      |    0 |
| 191859 | 陈毅毅       |    1 |
| 191860 | 李香       |    0 |
| 191861 | 毛燕荷      |    0 |
| 191862 | 江萱       |    0 |
| 191863 | 朱昌       |    1 |
| 191864 | 江莉       |    0 |
| 191865 | 黄燕莉       |    0 |
| 191866 | 孙荷念       |    0 |
| 191867 | 赵燕碧       |    0 |
| 191868 | 王燕       |    0 |
| 191869 | 胡念莲       |    0 |
| 191870 | 刘俊毅       |    1 |
| 191871 | 吴巧       |    0 |
| 191872 | 毛玉碧      |    0 |
| 191873 | 胡德浩      |    1 |
| 191874 | 刘秋紫       |    0 |
| 191875 | 毛博澄      |    1 |
| 191876 | 朱诚       |    1 |
| 191877 | 胡煦诚       |    1 |
| 191878 | 孙萱       |    0 |
| 191879 | 赵言       |    1 |
| 191880 | 朱海俊     |    1 |
| 191881 | 朱紫紫       |    0 |
| 191882 | 曾衍       |    1 |
| 191883 | 张莲念       |    0 |
| 191884 | 何荷      |    0 |
| 191885 | 钱诚      |    1 |
| 191886 | 李瀚       |    1 |
| 191887 | 李广毅       |    1 |
| 191888 | 吴念蕾       |    0 |
| 191889 | 何邈海     |    1 |
| 191890 | 刘邈       |    1 |
| 191891 | 江莹      |    0 |
| 191892 | 朱亮德       |    1 |
| 191893 | 朱昌言       |    1 |
| 191894 | 吴萱莲       |    0 |
| 191895 | 邓超      |    1 |
| 191896 | 钱燕莉      |    0 |
| 191897 | 吴秋莉       |    0 |
| 191898 | 朱锋毅       |    1 |
| 191899 | 曾畅昌       |    1 |
| 191900 | 朱昌超       |    1 |
| 191901 | 胡玉       |    0 |
| 191902 | 江萱雅       |    0 |
| 191903 | 毛阳涵      |    1 |
| 191904 | 何诚      |    1 |
| 191905 | 周颖      |    0 |
| 191906 | 陈广亮      |    1 |
| 191907 | 朱煦邈       |    1 |
| 191908 | 江锋涵     |    1 |
| 191909 | 毛红紫      |    0 |
| 191910 | 何言阳       |    1 |
| 191911 | 邓莲琪       |    0 |
| 191912 | 黄莲琪       |    0 |
| 191913 | 刘煦       |    1 |
| 191914 | 钱澄邈      |    1 |
| 191915 | 张莉秋       |    0 |
| 191916 | 毛香艳      |    0 |
| 191917 | 吴杰言       |    1 |
| 191918 | 江阳诚       |    1 |
| 191919 | 何萱颖      |    0 |
| 191920 | 江峰       |    1 |
| 191921 | 王丽       |    0 |
| 191922 | 毛碧念      |    0 |
| 191923 | 王峰涵     |    1 |
| 191924 | 胡杰博      |    1 |
| 191925 | 钱德昌     |    1 |
| 191926 | 刘萱萱       |    0 |
| 191927 | 曾昌邈       |    1 |
| 191928 | 黄海      |    1 |
| 191929 | 赵杰      |    1 |
| 191930 | 钱莲巧      |    0 |
| 191931 | 黄锋浩      |    1 |
| 191932 | 刘萱雅       |    0 |
| 191933 | 钱衍言      |    1 |
| 191934 | 李峰广       |    1 |
| 191935 | 刘秋       |    0 |
| 191936 | 周香       |    0 |
| 191937 | 吴依莉       |    0 |
| 191938 | 邓秋碧       |    0 |
| 191939 | 曾俊       |    1 |
| 191940 | 邓广      |    1 |
| 191941 | 吴燕       |    0 |
| 191942 | 张超涵      |    1 |
| 191943 | 曾红       |    0 |
| 191944 | 王博浩       |    1 |
| 191945 | 胡香香       |    0 |
| 191946 | 黄雅紫       |    0 |
| 191947 | 胡依       |    0 |
| 191948 | 李念       |    0 |
| 191949 | 刘衍言       |    1 |
| 191950 | 曾亮       |    1 |
| 191951 | 何香       |    0 |
| 191952 | 孙萱燕       |    0 |
| 191953 | 周依香       |    0 |
| 191954 | 陈雅       |    0 |
| 191955 | 吴丽红       |    0 |
| 191956 | 曾诚       |    1 |
| 191957 | 赵莲莹      |    0 |
| 191958 | 朱言俊      |    1 |
| 191959 | 王亮       |    1 |
| 191960 | 刘丽香       |    0 |
| 191961 | 李博      |    1 |
| 191962 | 江亮毅       |    1 |
| 191963 | 陈念玉       |    0 |
| 191964 | 何涵      |    1 |
| 191965 | 周锋      |    1 |
| 191966 | 曾言       |    1 |
| 191967 | 朱念秋       |    0 |
| 191968 | 毛紫萱      |    0 |
| 191969 | 刘锋畅     |    1 |
| 191970 | 邓诚杰     |    1 |
| 191971 | 周燕荷       |    0 |
| 191972 | 江念       |    0 |
| 191973 | 朱超博     |    1 |
| 191974 | 朱锋海     |    1 |
| 191975 | 朱雅紫       |    0 |
| 191976 | 孙杰       |    1 |
| 191977 | 刘颖      |    0 |
| 191978 | 黄香       |    0 |
| 191979 | 江衍昌      |    1 |
| 191980 | 刘萱红       |    0 |
| 191981 | 王澄博      |    1 |
| 191982 | 孙锋畅     |    1 |
| 191983 | 邓邈诚       |    1 |
| 191984 | 刘诚昌      |    1 |
| 191985 | 胡昌       |    1 |
| 191986 | 何艳念       |    0 |
| 191987 | 孙广超     |    1 |
| 191988 | 钱琪莹     |    0 |
| 191989 | 江琪巧       |    0 |
| 191990 | 胡紫       |    0 |
| 191991 | 赵念       |    0 |
| 191992 | 刘玉琪       |    0 |
| 191993 | 毛博德      |    1 |
| 191994 | 孙煦瀚       |    1 |
| 191995 | 胡香碧       |    0 |
| 191996 | 刘巧蕾       |    0 |
| 191997 | 吴邈       |    1 |
| 191998 | 毛杰煦      |    1 |
| 191999 | 何亮言       |    1 |
+--------+--------+------+
938 rows in set (0.00 sec)

mysql> select * from xs2 where 姓名='江翰';
Empty set (0.00 sec)

mysql> select * from xs2 where 姓名='刘丽';
+--------+------+------+
| 学号      | 姓名     | 性别    |
+--------+------+------+
| 191185 | 刘丽     |    0 |
+--------+------+------+
1 row in set (0.00 sec)