void insertuseinformation()//输入用户信息
{
    system("cls");
    while (1)
    {
        Pos(40, 12); printf("请输入账号：");
        gets_s(user.name);
        sprintf(szSqlText, "insert into 204_snake(usernum) values ('%s'),user.name");
        if (mysql_query(conn, szSqlText))
        {
            Pos(40, 10); printf("添加用户失败.\n");
            getch();
        }
        else
        {
            Pos(40, 9); printf("账号输入成功");
            Pos(40, 15); printf("请进入游戏.");
            getch();
        }
        break;
    }
}


定义的结构体为：
typedef struct User
{
    char name[15];
    int grades;
}Users;
User user;


在mysql中建的表为
  名称：usernum      类型：varchar          长度：15

尝试用mysql_query()插入