百家姓sql语句_sql.txt

CREATE TABLE `tSurName` (
  `id` mediumint(6) unsigned NOT NULL AUTO_INCREMENT,
  `SurName` char(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=505 DEFAULT CHARSET=utf8mb4;

insert into tSurName(SurName) values('ÕÔ');
insert into tSurName(SurName) values('Ç®');
insert into tSurName(SurName) values('Ëï');
insert into tSurName(SurName) values('Àî');
insert into tSurName(SurName) values('ÖÜ');
insert into tSurName(SurName) values('Îâ');
insert into tSurName(SurName) values('Ö£');
insert into tSurName(SurName) values('Íõ');
insert into tSurName(SurName) values('·ë');
insert into tSurName(SurName) values('³Â');
insert into tSurName(SurName) values('ñÒ');
insert into tSurName(SurName) values('ÎÀ');
insert into tSurName(SurName) values('½¯');
insert into tSurName(SurName) values('Éò');
insert into tSurName(SurName) values('º«');
insert into tSurName(SurName) values('Ñî');
insert into tSurName(SurName) values('Öì');
insert into tSurName(SurName) values('ÇØ');
insert into tSurName(SurName) values('ÓÈ');
insert into tSurName(SurName) values('Ðí');
insert into tSurName(SurName) values('ºÎ');
insert into tSurName(SurName) values('ÂÀ');
insert into tSurName(SurName) values('Ê©');
insert into tSurName(SurName) values('ÕÅ');

insert into tSurName(SurName) values('¿×');
insert into tSurName(SurName) values('²Ü');
insert into tSurName(SurName) values('ÑÏ');
insert into tSurName(SurName) values('»ª');
insert into tSurName(SurName) values('½ð');
insert into tSurName(SurName) values('κ');
insert into tSurName(SurName) values('ÌÕ');
insert into tSurName(SurName) values('½ª');
insert into tSurName(SurName) values('ÆÝ');
insert into tSurName(SurName) values('л');
insert into tSurName(SurName) values('×Þ');
insert into tSurName(SurName) values('Ó÷');
insert into tSurName(SurName) values('°Ø');
insert into tSurName(SurName) values('Ë®');
insert into tSurName(SurName) values('ñ¼');
insert into tSurName(SurName) values('ÕÂ');
insert into tSurName(SurName) values('ÔÆ');
insert into tSurName(SurName) values('ËÕ');
insert into tSurName(SurName) values('ÅË');
insert into tSurName(SurName) values('¸ð');
insert into tSurName(SurName) values('ÞÉ');
insert into tSurName(SurName) values('·¶');
insert into tSurName(SurName) values('Åí');
insert into tSurName(SurName) values('ÀÉ');
insert into tSurName(SurName) values('³');
insert into tSurName(SurName) values('Τ');
insert into tSurName(SurName) values('²ý');
insert into tSurName(SurName) values('Âí');
insert into tSurName(SurName) values('Ãç');
insert into tSurName(SurName) values('·ï');