将数据写入mysql,该如何解决

将数据写入mysql
c语言操作mysql数据库 
定义一个整型变量a；如何将a的值写回数据库
query = "update test.user set score=’50‘ where id='lisi' ";
这样可以 但我想将50改成变量a的值 该怎么修改

[解决办法]

[解决办法]
char query[300];
snprintf(query,sizeof(query), "update test.user set score='%d' where id=\"%s\" " , a, "lisi" );
[解决办法]
char query[300];
int score = 50;
char id[50] = "lisi";
sprintf(query, "update test.user set score='%d' where id='%s'" , score, id);