Utiliser l'API MySQL dans vos programmes

MYSQL_ROW row;
unsigned int num_fields;
unsigned int i;

num_fields = mysql_num_fields(result);
while ((row = mysql_fetch_row(result)))
{
   unsigned long *lengths;
   lengths = mysql_fetch_lengths(result);
   for(i = 0; i < num_fields; i++)
   {
       printf("[%.*s] ", (int) lengths[i], row[i] ? row[i] : "NULL");
   }
   printf("\n");
}

//Déclaration du pointeur de structure de type MYSQL
    MYSQL mysql;
/* où est le pointeur ?*/

//Déclaration des pointeurs de structure
            MYSQL_RES *result = NULL;
            MYSQL_ROW *row = NULL;

/*...*/

while ((row = mysql_fetch_row(result)))

/* Pour info mysql_fetch_row renvoi MYSQL_ROW et non pas MYSQL_ROW *, donc ça colle pas... */

#include <stdio.h>
#include <stdlib.h>
#include <winsock.h>
#include <mysql/mysql.h>



int main()
{
    MYSQL mysql;
    char pseudo[100];
    char mdp[100];
    char domaine[100];
    char bbd[100];
    
        mysql_init(&mysql);
        mysql_options(&mysql,MYSQL_READ_DEFAULT_GROUP,"option");
        printf("             ------------------------------------\n");
        printf("             Consultation de la base de donnee !\n");
        printf("             ------------------------------------\n");
        printf("\n\nPour vous connectez au serveur, entrez vos identifiants !\n");
        printf("\nVotre nom de domaine :");
        scanf("%s",&domaine);
        printf("\nIdentifiant :");
        scanf("%s",&pseudo);
        printf("\nMot de passe :");
        scanf("%s",&mdp);
        printf("\nNom de la base de donnee :");
        scanf("%s",&bbd);
        printf("\n\nConnection en cour !\n\n");
        printf("Recapitulatif de connection :\n");
        printf("-----------------------------\n");
        printf("%s     -> %s     -> %s   ->  %s",pseudo,domaine,mdp,bbd);
        printf("\n\nMerci de patienter...\n");
        
        
            if(mysql_real_connect(&mysql,domaine,pseudo,mdp,bbd,0,NULL,0))
            {
       
             printf("\nConnexion a la BDD reussit !\n");
             system("pause");
             mysql_close(&mysql);
            }
            else
            {
             printf("\n\n    ! --------------------------------------------------------- !\n");
             printf("\n    !  Une erreur s'est produite lors de la connexion a la BDD  !\n");
             printf("\n    ! --------------------------------------------------------- !\n\n");
            }

    system("pause");
    return 0;
}