format PE Console
entry start 

include "%fasminc%\win32a.inc"
include "%fasminc%\macro\if.inc"



section ".data" data readable writeable 



szPause     db "PAUSE",0
szUser        db "root",0
szPass db 0
szHost  db "localhost",0      ;hostname
szDB       db "fasmdb",0
mysql        dd ?    ;pointer to a mysql struct. 
result  dd ?    ;pointer to a mysql query result
row dd ?    ;
szTestq    db "testq.sql",0 ;file with sql insert values
szStr        db "%s",10,13,0
szStrStrStr db "%s, %s, %s",10,13,0
szReadOnly db "r",0

szOk_connect db "MySql connection established",0
szOk_createt db "Table 'testq' was created ok",0
szOk_import  db "Values from testq.sql where imported into the database. Making query",10,13,0



szError_connect db "Fatal Error: Couldn't connect to MySql Server. Check if DataBase 'fasmdb' exits",0
szError_createt db "Error: Couldn't create Table 'testq', probably already exists",0  
szError_file db "Error: Couldn't open testq.sql",0
szError_query db "Bad query",0

pFile       dd 0
sztest  db "!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!",0
Buffer     db 255 dup ?  


szSql_createtable db "CREATE TABLE  testq (ID INT NOT NULL AUTO_INCREMENT ,NAME CHAR(32) ,VALUE INT, UNIQUE(ID));",0
szSql_select db "SELECT * FROM testq;",0

section ".code" code readable executable 
start: 
    push sztest
 ;init mysql struct
  invoke  mysql_init, NULL
    mov     [mysql],eax     
    
    ;connect to sql server
      invoke  mysql_real_connect, [mysql], szHost, szUser, szPass, szDB, NULL, NULL, NULL
 .if eax <> [mysql]
            cinvoke printf, szStr, szError_connect
      .else
               cinvoke printf, szStr, szOk_connect
 .endif
      
    ;select the DataBase 'fasmbd'
     invoke mysql_select_db, [mysql], szDB
       
    ;create the 'testq' table
 invoke mysql_query, [mysql], szSql_createtable
      .if eax <> 0
          cinvoke printf, szStr, szError_createt
      .else
               cinvoke printf, szStr, szOk_createt
 .endif
      
    ;open testq.sql
     cinvoke fopen, szTestq, szReadOnly
  mov     [pFile], eax
        .if eax = 0
         cinvoke printf, szStr, szError_file
         jmp     __exit
      .endif
      
    ;insert values from testq.sql into table testq  
    .repeat
             cinvoke fgets, Buffer, 255, [pFile]
         invoke mysql_query, [mysql], Buffer
         cinvoke feof, [pFile]
       .until eax <> 0   ;until end of file
  cinvoke printf, szStr, szOk_import
  
    
    ;making query to testq for all data.
        invoke mysql_query, [mysql], szSql_select
   
    ;store the result of the query, also check mysql_store_result
       invoke mysql_use_result, [mysql]
    mov     [result], eax
       .if eax = 0
         cinvoke printf, szStr, szError_query
        .else
               ;get the first row of the valid query
               invoke mysql_fetch_row, [result]
            .repeat
                     mov     [row], eax
                  ;print the value of the row ID, NAME, VALUE
                 cinvoke printf, szStrStrStr, [eax],[eax+4],[eax+8]
                  invoke mysql_fetch_row, [result]
            .until eax = 0
              ;free the result struct
             invoke mysql_free_result, [result]
          
    .endif
      
__exit:
     cinvoke system, szPause
     invoke  mysql_close, [mysql]
        invoke  ExitProcess,0



section ".idata" import data readable writeable 

library kernel32, "kernel32.dll",\ 
       user32,"user32.dll",\ 
   msvcrt, "msvcrt.dll",\
   libmysql, "libmysql.dll"

include "%fasminc%\api\kernel32.inc"
include "%fasminc%\api\user32.inc"
include "%fasminc%\api\msvcrt.inc"
include "%fasminc%\api\libmysql.inc"
    

Very interesting. Is there some "libmysql.dll" reference?
I personally prefer sqlite when I need some database engine, but mysql is OK when you need true client-server architecture.

feels like php and js

mysql_query($link,'SELECT * FROM users WHERE userid=1');$res=mysql_fetch_row($link);$user_Id_INT= $res['userid'];$userName =$res['username'];    

AFAIK the returned data is returned into a string buffer and you have to separate it yourself.

in php you just write the name of the column to retrieve the value. for example

Code:

mysql_query($link,'SELECT * FROM users WHERE userid=1');
$res=mysql_fetch_row($link);
$user_Id_INT= $res['userid'];
$userName =$res['username'];