mysql 拼音查询汉字_mysql中汉字拼音检索

use   mydb;

DROP   TABLE   IF   EXISTS   `hz2py`;

CREATE   TABLE   `hz2py`   (

`PY`   char(1)   character   set   utf8   NOT   NULL,

`HZ`   char(1)   NOT   NULL   default   '',

PRIMARY   KEY     (`PY`)

)   ENGINE=InnoDB   DEFAULT   CHARSET=gbk;

INSERT   INTO   `hz2py`   (`PY`,`HZ`)   VALUES

('A','骜'),

('B','簿'),

('C','错'),

('D','鵽'),

('E','樲'),

('F','鳆'),

('G','腂'),

('H','夻'),

('J','攈'),

('K','穒'),

('L','鱳'),

('M','旀'),

('N','桛'),

('O','沤'),

('P','