使用MySQL資料庫將漢字轉換成拼音的一個C語言小程式

環境：

mysql：mysql-5.1.65

centos：centos 6.5

編譯命令：

gcc -o chinesetopinyin chinesetopinyin.c -L/usr/lib/mysql -lmysqlclient -I/usr/include/mysql

源代碼：

 1 #include <mysql/mysql.h>
 2 #include <stdio.h>
 3 #include <string.h>
 4 
 5 void ChineseToPinyin(char *pChinese, char *pPinyin)
 6 {
 7     MYSQL pMysql;
 8     MYSQL_RES *pRes;
 9     MYSQL_ROW Row;
10     char rgQuery[1024];
11     char rgQueryTemp[1024];
12     int iRet;
13     unsigned int i = 0;
14     
15     sprintf(rgQueryTemp, "select pinyin from chinese_to_pinyin where chinese='%s'", pChinese);
16     strcpy(rgQuery, rgQueryTemp);
17 
18     mysql_init(&pMysql);
19     if (!mysql_real_connect(&pMysql, "localhost", "root", "password", "user", 0, NULL, 0))
20     {
21         printf("Error connecting to database:%s\n", mysql_error(&pMysql));
22     }
23     
24     iRet = mysql_query(&pMysql, rgQuery);
25     if (iRet)
26     {
27         printf("error making rgQuery:%s\n", mysql_error(&pMysql));
28     }
29     else 
30     {
31         pRes = mysql_store_result(&pMysql);
32         if (pRes)
33         {
34             if (mysql_num_rows(pRes))
35             {
36                 while ((Row = mysql_fetch_row(pRes)))
37                 {
38                     for (i = 0; i < mysql_num_fields(pRes); i++)
39                     {
40                         strcpy(pPinyin, (Row[i] != NULL) ? Row[i] : pChinese);
41                     }
42                 }                
43             }
44             else
45             {
46                 strcpy(pPinyin, pChinese);
47             }            
48         }
49 
50         mysql_free_result(pRes);
51     }
52 
53     mysql_close(&pMysql);    
54 }
55 
56 int main(int argc, char *argv[])
57 {
58     char rgChinese[1024];
59     char rgPinyin[1024];
60     int i;
61     int iLength = 0;
62     
63     if (argc <= 1)
64     {
65         printf("too little argument!\n");
66     }
67 
68     iLength = strlen(argv[1]);
69     printf("iLength = %d\n", iLength);
70     
71     for (i = 0; i < iLength; i = i + 3)
72     {
73         char rgPinyinTemp[512];
74         strcpy(&rgChinese[0], &argv[1][i]);
75         strcpy(&rgChinese[1], &argv[1][i + 1]);
76         strcpy(&rgChinese[2], &argv[1][i + 2]);
77         rgChinese[3] = '\0';
78         printf("rgChinese = %s\n", rgChinese);
79         ChineseToPinyin(rgChinese, rgPinyinTemp);
80         strcat(rgPinyin, rgPinyinTemp);
81         rgPinyinTemp[0] = '\0';
82         rgChinese[0] = '\0';
83     }
84     
85     printf("%s:%s\n", argv[1], rgPinyin);
86 
87     return 0;
88 }

資料庫漢字與拼音對照表：

use xxx;
create table if not exists chinese_to_pinyin (
chinese varchar(512),
pinyin varchar(512)
);

insert into chinese_to_pinyin(chinese,pinyin) values ('阿','a');
insert into chinese_to_pinyin(chinese,pinyin) values ('啊','a');
insert into chinese_to_pinyin(chinese,pinyin) values ('吖','a');
insert into chinese_to_pinyin(chinese,pinyin) values ('嗄','a');
insert into chinese_to_pinyin(chinese,pinyin) values ('腌','a');
insert into chinese_to_pinyin(chinese,pinyin) values ('錒','a');
insert into chinese_to_pinyin(chinese,pinyin) values ('愛','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('埃','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('礙','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('矮','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('挨','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('唉','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('哎','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('哀','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('皚','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('癌','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('藹','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('艾','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('隘','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('捱','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('噯','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('嗌','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('嬡','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('璦','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('曖','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('砹','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('鎄','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('靄','ai');
insert into chinese_to_pinyin(chinese,pinyin) values ('安','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('按','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('暗','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('岸','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('案','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('俺','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('氨','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('胺','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('鞍','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('諳','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('垵','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('揞','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('犴','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('庵','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('桉','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('銨','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('鵪','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('黯','an');
insert into chinese_to_pinyin(chinese,pinyin) values ('昂','ang');
insert into chinese_to_pinyin(chinese,pinyin) values ('骯','ang');
insert into chinese_to_pinyin(chinese,pinyin) values ('盎','ang');
insert into chinese_to_pinyin(chinese,pinyin) values ('凹','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('奧','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('敖','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('熬','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('翱','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('襖','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('傲','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('懊','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('澳','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('坳','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('拗','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('嗷','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('嶴','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('廒','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('遨','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('媼','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('驁','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('獒','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('聱','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('螯','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('鏊','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('鰲','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('鏖','ao');
insert into chinese_to_pinyin(chinese,pinyin) values ('把','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('八','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('吧','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('巴','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('拔','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('霸','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('罷','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('爸','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('壩','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('芭','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('捌','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('扒','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('叭','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('笆','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('疤','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('跋','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('靶','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('耙','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('茇','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('菝','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('岜','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('灞','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('鈀','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('粑','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('鮁','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('魃','ba');
insert into chinese_to_pinyin(chinese,pinyin) values ('百','bai');
insert into chinese_to_pinyin(chinese,pinyin) values ('白','bai');
insert into chinese_to_pinyin(chinese,pinyin) values ('敗','bai');
insert into chinese_to_pinyin(chinese,pinyin) values ('擺','bai');
insert into chinese_to_pinyin(chinese,pinyin) values ('柏','bai');
insert into chinese_to_pinyin(chinese,pinyin) values ('佰','bai');
insert into chinese_to_pinyin(chinese,pinyin) values ('拜','bai');
insert into chinese_to_pinyin(chinese,pinyin) values ('稗','bai');
insert into chinese_to_pinyin(chinese,pinyin) values ('捭','bai');
insert into chinese_to_pinyin(chinese,pinyin) values ('掰','bai');
insert into chinese_to_pinyin(chinese,pinyin) values ('辦','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('半','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('板','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('班','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('般','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('版','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('拌','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('搬','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('斑','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('扳','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('伴','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('頒','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('扮','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('瓣','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('絆','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('阪','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('阪','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('鈑','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('瘢','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('癍','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('舨','ban');
insert into chinese_to_pinyin(chinese,pinyin) values ('幫','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('棒','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('邦','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('榜','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('梆','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('膀','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('綁','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('磅','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('蚌','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('鎊','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('傍','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('謗','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('蒡','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('浜','bang');
insert into chinese_to_pinyin(chinese,pinyin) values ('報','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('保','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('包','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('剝','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('薄','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('胞','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('暴','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('寶','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('飽','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('抱','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('爆','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('堡','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('苞','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('褒','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('雹','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('豹','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('鮑','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('葆','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('孢','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('煲','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('鴇','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('褓','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('趵','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('齙','bao');
insert into chinese_to_pinyin(chinese,pinyin) values ('北','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('被','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('倍','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('備','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('背','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('輩','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('貝','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('杯','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('卑','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('悲','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('碑','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('鋇','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('狽','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('憊','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('焙','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('孛','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('陂','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('邶','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('埤','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('萆','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('蓓','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('唄','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('悖','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('碚','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('鵯','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('褙','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('鐾','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('鞴','bei');
insert into chinese_to_pinyin(chinese,pinyin) values ('本','ben');
insert into chinese_to_pinyin(chinese,pinyin) values ('奔','ben');
insert into chinese_to_pinyin(chinese,pinyin) values ('苯','ben');
insert into chinese_to_pinyin(chinese,pinyin) values ('笨','ben');
insert into chinese_to_pinyin(chinese,pinyin) values ('畚','ben');
insert into chinese_to_pinyin(chinese,pinyin) values ('坌','ben');
insert into chinese_to_pinyin(chinese,pinyin) values ('賁','ben');
insert into chinese_to_pinyin(chinese,pinyin) values ('錛','ben');
insert into chinese_to_pinyin(chinese,pinyin) values ('泵','beng');
insert into chinese_to_pinyin(chinese,pinyin) values ('崩','beng');
insert into chinese_to_pinyin(chinese,pinyin) values ('綳','beng');
insert into chinese_to_pinyin(chinese,pinyin) values ('甭','beng');
insert into chinese_to_pinyin(chinese,pinyin) values ('蹦','beng');
insert into chinese_to_pinyin(chinese,pinyin) values ('迸','beng');
insert into chinese_to_pinyin(chinese,pinyin) values ('嘣','beng');
insert into chinese_to_pinyin(chinese,pinyin) values ('甏','beng');
insert into chinese_to_pinyin(chinese,pinyin) values ('比','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('必','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('避','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('閉','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('闢','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('筆','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('壁','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('臂','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('畢','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('彼','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('逼','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('幣','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('鼻','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('蔽','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('鄙','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('碧','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('蓖','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('斃','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('毖','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('庇','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('痹','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('敝','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('弊','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('陛','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('匕','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('俾','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('蓽','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('荸','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('薜','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('吡','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('嗶','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('狴','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('庳','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('愎','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('潷','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('濞','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('弼','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('妣','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('婢','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('嬖','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('璧','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('畀','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('鉍','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('秕','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('裨','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('篳','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('箅','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('篦','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('舭','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('襞','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('蹕','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('髀','bi');
insert into chinese_to_pinyin(chinese,pinyin) values ('變','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('邊','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('便','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('編','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('遍','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('辯','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('扁','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('辨','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('鞭','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('貶','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('卞','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('辮','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('匾','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('弁','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('苄','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('忭','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('汴','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('緶','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('飈','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('煸','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('砭','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('碥','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('窆','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('褊','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('蝙','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('籩','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('鯿','bian');
insert into chinese_to_pinyin(chinese,pinyin) values ('表','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('標','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('彪','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('膘','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('婊','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('驃','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('杓','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('颮','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('飆','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('鏢','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('鑣','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('瘭','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('裱','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('鰾','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('髟','biao');
insert into chinese_to_pinyin(chinese,pinyin) values ('別','bie');
insert into chinese_to_pinyin(chinese,pinyin) values ('鱉','bie');
insert into chinese_to_pinyin(chinese,pinyin) values ('憋','bie');
insert into chinese_to_pinyin(chinese,pinyin) values ('癟','bie');
insert into chinese_to_pinyin(chinese,pinyin) values ('蹩','bie');
insert into chinese_to_pinyin(chinese,pinyin) values ('賓','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('彬','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('斌','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('瀕','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('濱','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('擯','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('儐','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('豳','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('繽','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('玢','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('檳','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('殯','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('臏','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('鑌','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('髕','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('鬢','bin');
insert into chinese_to_pinyin(chinese,pinyin) values ('並','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('病','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('兵','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('柄','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('冰','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('丙','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('餅','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('秉','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('炳','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('稟','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('邴','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('摒','bing');
insert into chinese_to_pinyin(chinese,pinyin) values ('波','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('播','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('伯','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('撥','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('博','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('勃','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('駁','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('玻','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('泊','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('菠','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('缽','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('搏','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('鉑','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('箔','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('帛','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('舶','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('脖','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('膊','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('渤','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('亳','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('啵','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('餑','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('檗','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('擘','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('礴','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('鈸','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('鵓','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('簸','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('跛','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('踣','bo');
insert into chinese_to_pinyin(chinese,pinyin) values ('不','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('部','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('步','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('布','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('補','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('捕','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('卜','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('哺','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('埠','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('簿','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('怖','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('卟','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('逋','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('瓿','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('晡','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('鈈','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('鈽','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('醭','bu');
insert into chinese_to_pinyin(chinese,pinyin) values ('擦','ca');
insert into chinese_to_pinyin(chinese,pinyin) values ('嚓','ca');
insert into chinese_to_pinyin(chinese,pinyin) values ('礤','ca');
insert into chinese_to_pinyin(chinese,pinyin) values ('採','cai');
insert into chinese_to_pinyin(chinese,pinyin) values ('才','cai');
insert into chinese_to_pinyin(chinese,pinyin) values ('材','cai');
insert into chinese_to_pinyin(chinese,pinyin) values ('菜','cai');
insert into chinese_to_pinyin(chinese,pinyin) values ('財','cai');
insert into chinese_to_pinyin(chinese,pinyin) values ('裁','cai');
insert into chinese_to_pinyin(chinese,pinyin) values ('彩','cai');
insert into chinese_to_pinyin(chinese,pinyin) values ('猜','cai');
insert into chinese_to_pinyin(chinese,pinyin) values ('睬','cai');
insert into chinese_to_pinyin(chinese,pinyin) values ('踩','cai');
insert into chinese_to_pinyin(chinese,pinyin) values ('蔡','cai');
insert into chinese_to_pinyin(chinese,pinyin) values ('參','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('殘','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('蠶','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('燦','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('餐','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('慚','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('慘','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('孱','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('驂','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('璨','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('粲','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('黲','can');
insert into chinese_to_pinyin(chinese,pinyin) values ('藏','cang');
insert into chinese_to_pinyin(chinese,pinyin) values ('倉','cang');
insert into chinese_to_pinyin(chinese,pinyin) values ('蒼','cang');
insert into chinese_to_pinyin(chinese,pinyin) values ('艙','cang');
insert into chinese_to_pinyin(chinese,pinyin) values ('滄','cang');
insert into chinese_to_pinyin(chinese,pinyin) values ('草','cao');
insert into chinese_to_pinyin(chinese,pinyin) values ('槽','cao');
insert into chinese_to_pinyin(chinese,pinyin) values ('操','cao');
insert into chinese_to_pinyin(chinese,pinyin) values ('糙','cao');
insert into chinese_to_pinyin(chinese,pinyin) values ('曹','cao');
insert into chinese_to_pinyin(chinese,pinyin) values ('嘈','cao');
insert into chinese_to_pinyin(chinese,pinyin) values ('漕','cao');
insert into chinese_to_pinyin(chinese,pinyin) values ('螬','cao');
insert into chinese_to_pinyin(chinese,pinyin) values ('艚','cao');
insert into chinese_to_pinyin(chinese,pinyin) values ('測','ce');
insert into chinese_to_pinyin(chinese,pinyin) values ('策','ce');
insert into chinese_to_pinyin(chinese,pinyin) values ('側','ce');
insert into chinese_to_pinyin(chinese,pinyin) values ('冊','ce');
insert into chinese_to_pinyin(chinese,pinyin) values ('廁','ce');
insert into chinese_to_pinyin(chinese,pinyin) values ('惻','ce');
insert into chinese_to_pinyin(chinese,pinyin) values ('岑','cen');
insert into chinese_to_pinyin(chinese,pinyin) values ('涔','cen');
insert into chinese_to_pinyin(chinese,pinyin) values ('層','ceng');
insert into chinese_to_pinyin(chinese,pinyin) values ('蹭','ceng');
insert into chinese_to_pinyin(chinese,pinyin) values ('查','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('差','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('插','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('察','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('茶','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('叉','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('茬','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('碴','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('搽','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('岔','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('詫','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('猹','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('餷','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('汊','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('奼','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('杈','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('楂','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('槎','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('檫','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('鍤','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('鑔','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('衩','cha');
insert into chinese_to_pinyin(chinese,pinyin) values ('柴','chai');
insert into chinese_to_pinyin(chinese,pinyin) values ('拆','chai');
insert into chinese_to_pinyin(chinese,pinyin) values ('豺','chai');
insert into chinese_to_pinyin(chinese,pinyin) values ('儕','chai');
insert into chinese_to_pinyin(chinese,pinyin) values ('釵','chai');
insert into chinese_to_pinyin(chinese,pinyin) values ('瘥','chai');
insert into chinese_to_pinyin(chinese,pinyin) values ('蠆','chai');
insert into chinese_to_pinyin(chinese,pinyin) values ('產','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('鏟','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('闡','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('攙','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('摻','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('蟬','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('饞','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('讒','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('纏','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('顫','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('囅','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('諂','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('蕆','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('廛','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('懺','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('潺','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('澶','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('羼','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('嬋','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('驏','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('覘','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('禪','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('鐔','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('蟾','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('躔','chan');
insert into chinese_to_pinyin(chinese,pinyin) values ('長','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('常','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('場','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('廠','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('唱','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('腸','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('昌','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('倡','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('償','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('暢','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('猖','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('嘗','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('敞','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('倀','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('鬯','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('萇','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('菖','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('徜','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('悵','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('惝','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('閶','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('娼','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('嫦','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('昶','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('氅','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('鯧','chang');
insert into chinese_to_pinyin(chinese,pinyin) values ('朝','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('超','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('潮','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('巢','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('抄','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('鈔','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('嘲','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('吵','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('炒','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('怊','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('晁','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('耖','chao');
insert into chinese_to_pinyin(chinese,pinyin) values ('車','che');
insert into chinese_to_pinyin(chinese,pinyin) values ('徹','che');
insert into chinese_to_pinyin(chinese,pinyin) values ('撤','che');
insert into chinese_to_pinyin(chinese,pinyin) values ('扯','che');
insert into chinese_to_pinyin(chinese,pinyin) values ('掣','che');
insert into chinese_to_pinyin(chinese,pinyin) values ('澈','che');
insert into chinese_to_pinyin(chinese,pinyin) values ('坼','che');
insert into chinese_to_pinyin(chinese,pinyin) values ('硨','che');
insert into chinese_to_pinyin(chinese,pinyin) values ('陳','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('沉','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('稱','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('襯','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('塵','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('臣','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('晨','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('郴','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('辰','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('忱','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('趁','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('傖','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('諶','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('讖','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('抻','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('嗔','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('宸','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('琛','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('櫬','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('磣','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('齔','chen');
insert into chinese_to_pinyin(chinese,pinyin) values ('成','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('程','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('稱','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('城','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('承','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('乘','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('呈','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('撐','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('誠','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('橙','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('懲','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('澄','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('逞','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('騁','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('秤','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('丞','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('埕','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('噌','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('棖','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('檉','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('塍','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('瞠','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('鋮','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('鐺','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('裎','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('蟶','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('酲','cheng');
insert into chinese_to_pinyin(chinese,pinyin) values ('持','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('尺','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('齒','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('吃','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('赤','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('池','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('遲','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('翅','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('斥','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('恥','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('痴','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('匙','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('弛','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('馳','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('侈','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('熾','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('傺','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('坻','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('墀','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('茌','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('叱','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('哧','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('啻','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('嗤','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('彳','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('飭','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('媸','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('敕','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('眵','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('鴟','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('瘛','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('褫','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('蚩','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('螭','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('笞','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('篪','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('豉','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('踟','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('魑','chi');
insert into chinese_to_pinyin(chinese,pinyin) values ('蟲','chong');
insert into chinese_to_pinyin(chinese,pinyin) values ('充','chong');
insert into chinese_to_pinyin(chinese,pinyin) values ('沖','chong');
insert into chinese_to_pinyin(chinese,pinyin) values ('崇','chong');
insert into chinese_to_pinyin(chinese,pinyin) values ('寵','chong');
insert into chinese_to_pinyin(chinese,pinyin) values ('茺','chong');
insert into chinese_to_pinyin(chinese,pinyin) values ('忡','chong');
insert into chinese_to_pinyin(chinese,pinyin) values ('憧','chong');
insert into chinese_to_pinyin(chinese,pinyin) values ('銃','chong');
insert into chinese_to_pinyin(chinese,pinyin) values ('舂','chong');
insert into chinese_to_pinyin(chinese,pinyin) values ('艟','chong');
insert into chinese_to_pinyin(chinese,pinyin) values ('抽','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('仇','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('臭','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('酬','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('疇','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('躊','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('稠','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('愁','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('籌','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('綢','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('瞅','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('醜','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('儔','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('幬','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('惆','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('瘳','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('讎','chou');
insert into chinese_to_pinyin(chinese,pinyin) values ('出','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('處','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('除','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('初','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('礎','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('觸','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('楚','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('鋤','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('儲','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('櫥','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('廚','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('躇','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('雛','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('滁','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('矗','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('搐','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('亍','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('芻','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('怵','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('憷','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('絀','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('杵','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('楮','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('樗','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('褚','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('蜍','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('躕','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('黜','chu');
insert into chinese_to_pinyin(chinese,pinyin) values ('揣','chuai');
insert into chinese_to_pinyin(chinese,pinyin) values ('搋','chuai');
insert into chinese_to_pinyin(chinese,pinyin) values ('啜','chuai');
insert into chinese_to_pinyin(chinese,pinyin) values ('膪','chuai');
insert into chinese_to_pinyin(chinese,pinyin) values ('踹','chuai');
insert into chinese_to_pinyin(chinese,pinyin) values ('傳','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('船','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('穿','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('串','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('川','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('椽','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('喘','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('舛','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('遄','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('巛','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('氚','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('釧','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('舡','chuan');
insert into chinese_to_pinyin(chinese,pinyin) values ('床','chuang');
insert into chinese_to_pinyin(chinese,pinyin) values ('創','chuang');
insert into chinese_to_pinyin(chinese,pinyin) values ('窗','chuang');
insert into chinese_to_pinyin(chinese,pinyin) values ('闖','chuang');
insert into chinese_to_pinyin(chinese,pinyin) values ('瘡','chuang');
insert into chinese_to_pinyin(chinese,pinyin) values ('幢','chuang');
insert into chinese_to_pinyin(chinese,pinyin) values ('愴','chuang');
insert into chinese_to_pinyin(chinese,pinyin) values ('吹','chui');
insert into chinese_to_pinyin(chinese,pinyin) values ('垂','chui');
insert into chinese_to_pinyin(chinese,pinyin) values ('錘','chui');
insert into chinese_to_pinyin(chinese,pinyin) values ('炊','chui');
insert into chinese_to_pinyin(chinese,pinyin) values ('捶','chui');
insert into chinese_to_pinyin(chinese,pinyin) values ('陲','chui');
insert into chinese_to_pinyin(chinese,pinyin) values ('棰','chui');
insert into chinese_to_pinyin(chinese,pinyin) values ('槌','chui');
insert into chinese_to_pinyin(chinese,pinyin) values ('春','chun');
insert into chinese_to_pinyin(chinese,pinyin) values ('純','chun');
insert into chinese_to_pinyin(chinese,pinyin) values ('醇','chun');
insert into chinese_to_pinyin(chinese,pinyin) values ('椿','chun');
insert into chinese_to_pinyin(chinese,pinyin) values ('唇','chun');
insert into chinese_to_pinyin(chinese,pinyin) values ('淳','chun');
insert into chinese_to_pinyin(chinese,pinyin) values ('蠢','chun');
insert into chinese_to_pinyin(chinese,pinyin) values ('蒓','chun');
insert into chinese_to_pinyin(chinese,pinyin) values ('鶉','chun');
insert into chinese_to_pinyin(chinese,pinyin) values ('蝽','chun');
insert into chinese_to_pinyin(chinese,pinyin) values ('戳','chuo');
insert into chinese_to_pinyin(chinese,pinyin) values ('綽','chuo');
insert into chinese_to_pinyin(chinese,pinyin) values ('輟','chuo');
insert into chinese_to_pinyin(chinese,pinyin) values ('踔','chuo');
insert into chinese_to_pinyin(chinese,pinyin) values ('齪','chuo');
insert into chinese_to_pinyin(chinese,pinyin) values ('此','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('次','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('刺','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('磁','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('雌','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('詞','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('茨','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('疵','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('辭','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('慈','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('瓷','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('賜','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('茈','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('呲','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('祠','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('鶿','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('糍','ci');
insert into chinese_to_pinyin(chinese,pinyin) values ('從','cong');
insert into chinese_to_pinyin(chinese,pinyin) values ('叢','cong');
insert into chinese_to_pinyin(chinese,pinyin) values ('聰','cong');
insert into chinese_to_pinyin(chinese,pinyin) values ('蔥','cong');
insert into chinese_to_pinyin(chinese,pinyin) values ('囪','cong');
insert into chinese_to_pinyin(chinese,pinyin) values ('匆','cong');
insert into chinese_to_pinyin(chinese,pinyin) values ('蓯','cong');
insert into chinese_to_pinyin(chinese,pinyin) values ('淙','cong');
insert into chinese_to_pinyin(chinese,pinyin) values ('驄','cong');
insert into chinese_to_pinyin(chinese,pinyin) values ('琮','cong');
insert into chinese_to_pinyin(chinese,pinyin) values ('璁','cong');
insert into chinese_to_pinyin(chinese,pinyin) values ('湊','cou');
insert into chinese_to_pinyin(chinese,pinyin) values ('楱','cou');
insert into chinese_to_pinyin(chinese,pinyin) values ('輳','cou');
insert into chinese_to_pinyin(chinese,pinyin) values ('腠','cou');
insert into chinese_to_pinyin(chinese,pinyin) values ('粗','cu');
insert into chinese_to_pinyin(chinese,pinyin) values ('促','cu');
insert into chinese_to_pinyin(chinese,pinyin) values ('醋','cu');
insert into chinese_to_pinyin(chinese,pinyin) values ('簇','cu');
insert into chinese_to_pinyin(chinese,pinyin) values ('蔟','cu');
insert into chinese_to_pinyin(chinese,pinyin) values ('徂','cu');
insert into chinese_to_pinyin(chinese,pinyin) values ('猝','cu');
insert into chinese_to_pinyin(c