Consulta en MariaDB
Publicado por Matias (1 intervención) el 10/07/2015 06:24:56
Buenas, mi consulta es como obtener los nombres de usuario que tengan la cadena 'nh' én su
nombre
nombre
Valora esta pregunta
0
Iniciar sesiónCrear cuenta
Crear cuentaCrear cuenta
select * from tabla where campo like "%nh%"
/*http://www.cs.wichita.edu/~chang/lecture/cs742/program/how-mysql-c-api.htmlhttp://epweb2.ph.bham.ac.uk/user/hillier/course3cpp/howto/https://gcc.gnu.org/onlinedocs/cpp/Macros.htmlhttps://www.programiz.com/c-programming/c-preprocessor-macroshttps://www.cs.yale.edu/homes/aspnes/pinewiki/C(2f)Macros.htmlhttp://web.cse.ohio-state.edu/~sivilotti.1/teaching/3903.recent/lectures/*//*-------CreateDB.c---------*//*MYSQL *mysql_init(MYSQL *mysql)MYSQL *mysql_real_connect(MYSQL *mysql, const char *host, const char*user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned int client_flag)char *mysql_error(MYSQL *mysql)int mysql_create_db(MYSQL *mysql, const char *db)*/#ifdef WIN32 #include <windows.h> #include <winsock.h> #pragma warning (disable: 4514 4786) #pragma warning( push, 3 )#endif#include <stdio.h>#include "mysql.h"int main(int argc, char **argv) {
MYSQL connHand;
char *server = "localhost"; /* direccion del servidor 127.0.0.1, localhost o direccion ip */
char *user = "root"; /* usuario para consultar la base de datos */
char *password = ""; /* contraseña para el usuario en cuestion */
char *database = "dbcenso"; /* nombre de la base de datos a consultar */
printf("\n\n\tCopyright Lai Anei Kiska\n\t\t mongotaitang.com.ar/lanc/");
printf("\n\t\laian890@gmail.com \n\t\tPhone: (011) 4365-8496\n");
if ( mysql_init(&connHand ) == NULL ) {
printf("\nFailed to initate MySQL connection");
exit(1);
} /* * * now you can call any MySQL API function you like * */if (!mysql_real_connect(&connHand, server, user, password, NULL,0,NULL,0)) {
printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(&connHand));
exit(1);
} /*success*/if ( mysql_create_db(&connHand, "DhakaStockExchangeGame" )==0)
printf( "Database Created\n");
else
printf( "Failed to create new database. Error: %s\n", mysql_error(&connHand));
mysql_close(&connHand);
}/*-------DeleteDB.c---------*//*MYSQL *mysql_init(MYSQL *mysql)MYSQL *mysql_real_connect(MYSQL *mysql, const char *host, const char*user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned int client_flag)char *mysql_error(MYSQL *mysql)int mysql_drop_db(MYSQL *mysql, const char *db)*/#ifdef WIN32 #include <windows.h> #include <winsock.h> #pragma warning (disable: 4514 4786) #pragma warning( push, 3 )#endif#include <stdio.h>#include "mysql.h"#ifndef WIN32 #include <unistd.h>#endifint main(int argc, char **argv) {
MYSQL mysql;
printf("\n\n\tCopyright Aftab Jahan Subedar\n\t\t mongotaitang.com.ar/lanc/");
printf("\n\t\laian890@gmail.com \n\t\tPhone:+88027519050\n");
if (mysql_init(&mysql)==NULL) {
printf("\nFailed to initate MySQL connection");
exit(1);
} /*now you can call any MySQL API function you like*/if (!mysql_real_connect(&mysql,"subedartech.sytes.net","jahan","shoja_passwd",NULL,0,NULL,0))
{printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(&mysql));
exit(1);
}if (mysql_drop_db(&mysql, "dbcenso" )==0) /*success*/
printf( "Database Deleted\n");
else
printf( "Failed to delete database. Error: %s\n", mysql_error(&mysql));
mysql_close(&mysql);
}Creating Tables
/*-------CreateTable.c---------*/#include <stdio.h>#include <string.h>#include "mysql.h"/*========================================================================*/int mysql_exec_sql(MYSQL *mysql,const char *create_definition) {
return mysql_real_query(mysql,create_definition,strlen(create_definition));
}int main(int argc, char **argv) {
MYSQL mysql;
char ccSQL[1000]={0x00};
printf("\n\tLai Anei Kiska \n\t\t mongotaitang.com.ar/lanc/");
printf("\n\t\laian890@gmail.com\n");
if ( mysql_init(&mysql)==NULL) {
printf("\nFailed to initate MySQL connection");
return(1);
}if (!mysql_real_connect(&mysql,"localhost","root","",NULL,0,NULL,0)) {
printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(&mysql));
return(1);
}if(mysql_select_db(&mysql,"test")==0)
printf( "Database Selected\n");
else
printf( "Failed to connect to Database: Error: %s\n",
mysql_error(&mysql));
strcat(ccSQL,"CREATE TABLE TDOCUMENTOS ( ");
strcat(ccSQL,"DOC_TIPO SMALLINT NOT NULL, ");
strcat(ccSQL,"DOC_FECUPTE VARCHAR(060) NOT NULL, ");
strcat(ccSQL,"DOC_DESCRIP VARCHAR(060) NOT NULL, ");
strcat(ccSQL,"DOC_ABREVIA CHAR (006) NOT NULL, ");
strcat(ccSQL,"PRIMARY KEY( DOC_TIPO ) )");
printf( "%s\n", ccSQL );
if ( mysql_exec_sql(&mysql,ccSQL )==0)
printf( "Table Created\n");
else
printf( "Failed to create table: Error: %s\n",
mysql_error(&mysql));
mysql_close(&mysql);
}/* |----------------------------------------------------- | "CREATE TABLE TDOCUMENTOS ( " | "DOC_TIPO SMALLINT NOT NULL, " | "DOC_FECUPTE VARCHAR(060) NOT NULL, " | "DOC_DESCRIP VARCHAR(060) NOT NULL, " | "DOC_ABREVIA CHAR (006) NOT NULL, " | "PRIMARY KEY( DOC_TIPO ) )" |----------------------------------------------------- */Editing
Tables
/*-------EditTable.c---------*//*========================================================================*/#include <stdio.h>#include <string.h>#include "mysql.h"/*========================================================================*/int mysql_exec_sql(MYSQL *mysql,const char *create_definition) {
return mysql_real_query(mysql,create_definition,strlen(create_definition));
}int main(int argc, char **argv) {
MYSQL mysql;
char ccSQL[1000]={0x00};
printf("\n\tLai Anei Kiska \n\t mongotaitang.com.ar/lanc/");
printf("\n\t\ laian890@gmail.com\n");
if ( mysql_init(&mysql)==NULL) {
printf("\nFailed to initate MySQL connection");
return(1);
}if (!mysql_real_connect(&mysql,"localhost","root","",NULL,0,NULL,0)) {
printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(&mysql));
return(1);
}if(mysql_select_db(&mysql,"test")==0)
printf( "Database Selected\n");
else
printf( "Failed to connect to Database: Error: %s\n",
mysql_error(&mysql));
strcat(ccSQL,"Alter TABLE TDOCUMENTOS ");
strcat(ccSQL,"MODIFY DOC_FECUPTE VARCHAR(008) NOT NULL");
printf( "%s\n", ccSQL );
if ( mysql_exec_sql(&mysql,ccSQL )==0)
printf( "Table Altered\n");
else
printf( "Failed to connect to edit table: Error: %s\n", mysql_error(&mysql));
mysql_close(&mysql);
}/* |----------------------------------------------------------------- | "CREATE TABLE TDOCUMENTOS ( " | "DOC_TIPO SMALLINT NOT NULL, " | "DOC_FECUPTE VARCHAR(060) NOT NULL, " | "DOC_DESCRIP VARCHAR(060) NOT NULL, " | "DOC_ABREVIA CHAR (006) NOT NULL, " | "PRIMARY KEY( DOC_TIPO ) )" |----------------------------------------------------------------- | "Alter TABLE TDOCUMENTOS " | "MODIFY DOC_FECUPTE VARCHAR(008) NOT NULL" |----------------------------------------------------------------- */Deleting
Tables
/*-------DeleteTable.c---------*//*========================================================================*/#include <stdio.h>#include <string.h>#include "mysql.h"/*========================================================================*/int mysql_exec_sql(MYSQL *mysql,const char *create_definition) {
return mysql_real_query(mysql,create_definition,strlen(create_definition));
}int main(int argc, char **argv) {
MYSQL mysql;
char ccSQL[1000]={0x00};
printf("\n\tLai Anei Kiska \n\t mongotaitang.com.ar/");
printf("\n\t\ laian890@gmail.com\n");
if ( mysql_init(&mysql)==NULL) {
printf("\nFailed to initate MySQL connection");
return(1);
}if (!mysql_real_connect(&mysql,"localhost","root","",NULL,0,NULL,0)) {
printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(&mysql));
return(1);
}if(mysql_select_db(&mysql,"test")==0)
printf( "Database Selected\n");
else
printf( "Failed to connect to Database: Error: %s\n",
mysql_error(&mysql));
strcat(ccSQL,"DROP TABLE TDOCUMENTOS ");
printf( "%s\n", ccSQL );
if ( mysql_exec_sql(&mysql,ccSQL )==0)
printf( "Tabla Eliminada\n");
else
printf( "Failed to connect to edit table: Error: %s\n", mysql_error(&mysql));
mysql_close(&mysql);
}/* |----------------------------------------------------------------- | "CREATE TABLE TDOCUMENTOS ( " | "DOC_TIPO SMALLINT NOT NULL, " | "DOC_FECUPTE VARCHAR(060) NOT NULL, " | "DOC_DESCRIP VARCHAR(060) NOT NULL, " | "DOC_ABREVIA CHAR (006) NOT NULL, " | "PRIMARY KEY( DOC_TIPO ) )" |----------------------------------------------------------------- | "Alter TABLE TDOCUMENTOS " | "MODIFY DOC_FECUPTE VARCHAR(008) NOT NULL" |----------------------------------------------------------------- | "DROP TABLE TDOCUMENTOS " |----------------------------------------------------------------- */Creating
Index
/*-------CreateIndex.c---------*//*========================================================================*/#include <stdio.h>#include <string.h>#include "mysql.h"/*========================================================================*/int mysql_exec_sql(MYSQL *mysql,const char *create_definition) {
return mysql_real_query(mysql,create_definition,strlen(create_definition));
}int main(int argc, char **argv) {
MYSQL mysql;
char ccSQL[1000]={0x00};
printf("\n\tLai Anei Kiska \n\t mongotaitang.com.ar/");
printf("\n\t\ laian890@gmail.com\n");
if ( mysql_init(&mysql)==NULL) {
printf("\nFailed to initate MySQL connection");
return(1);
}if (!mysql_real_connect(&mysql,"localhost","root","",NULL,0,NULL,0)) {
printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(&mysql));
return(1);
}if(mysql_select_db(&mysql,"test")==0)
printf( "Database Selected\n");
else
printf( "Failed to connect to Database: Error: %s\n",
mysql_error(&mysql));
strcat(ccSQL,"CREATE INDEX DOC_TIPOS ON TDOCUMENTOS( DOC_TIPO )");
printf( "%s\n", ccSQL );
if ( mysql_exec_sql(&mysql,ccSQL )==0)
printf( "Indice creado en forma satisfactoria\n");
else
printf( "Failed to connect to edit table: Error: %s\n", mysql_error(&mysql));
mysql_close(&mysql);
}/* |----------------------------------------------------------------- | "CREATE TABLE TDOCUMENTOS ( " | "DOC_TIPO SMALLINT NOT NULL, " | "DOC_FECUPTE VARCHAR(060) NOT NULL, " | "DOC_DESCRIP VARCHAR(060) NOT NULL, " | "DOC_ABREVIA CHAR (006) NOT NULL, " | "PRIMARY KEY( DOC_TIPO ) )" |----------------------------------------------------------------- | "Alter TABLE TDOCUMENTOS " | "MODIFY DOC_FECUPTE VARCHAR(008) NOT NULL" |----------------------------------------------------------------- | "DROP TABLE TDOCUMENTOS " |----------------------------------------------------------------- | "CREATE INDEX DOC_TIPOS ON TDOCUMENTOS( DOC_TIPO )" |----------------------------------------------------------------- */Deleting
Index
/*-------DeleteIndex.c---------*//*========================================================================*/#include <stdio.h>#include <string.h>#include "mysql.h"/*========================================================================*/int mysql_exec_sql(MYSQL *mysql,const char *create_definition) {
return mysql_real_query(mysql,create_definition,strlen(create_definition));
}int main(int argc, char **argv) {
MYSQL mysql;
char ccSQL[1000]={0x00};
printf("\n\tLai Anei Kiska \n\t mongotaitang.com.ar/");
printf("\n\t\ laian890@gmail.com\n");
if ( mysql_init(&mysql)==NULL) {
printf("\nFailed to initate MySQL connection");
return(1);
}if (!mysql_real_connect(&mysql,"localhost","root","",NULL,0,NULL,0)) {
printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(&mysql));
return(1);
}if(mysql_select_db(&mysql,"test")==0)
printf( "Database Selected\n");
else
printf( "Failed to connect to Database: Error: %s\n",
mysql_error(&mysql));
strcat(ccSQL,"DROP INDEX DOC_TIPOS ON TDOCUMENTOS ");
printf( "%s\n", ccSQL );
if ( mysql_exec_sql(&mysql,ccSQL )==0)
printf( "Indice eliminado en forma satisfactoria\n");
else
printf( "Failed to connect to edit table: Error: %s\n", mysql_error(&mysql));
mysql_close(&mysql);
}/* |----------------------------------------------------------------- | "CREATE TABLE TDOCUMENTOS ( " | "DOC_TIPO SMALLINT NOT NULL, " | "DOC_FECUPTE VARCHAR(060) NOT NULL, " | "DOC_DESCRIP VARCHAR(060) NOT NULL, " | "DOC_ABREVIA CHAR (006) NOT NULL, " | "PRIMARY KEY( DOC_TIPO ) )" |----------------------------------------------------------------- | "Alter TABLE TDOCUMENTOS " | "MODIFY DOC_FECUPTE VARCHAR(008) NOT NULL" |----------------------------------------------------------------- | "DROP TABLE TDOCUMENTOS " |----------------------------------------------------------------- | "CREATE INDEX DOC_TIPOS ON TDOCUMENTOS( DOC_TIPO )" |----------------------------------------------------------------- | "DROP INDEX DOC_TIPOS ON TDOCUMENTOS" |----------------------------------------------------------------- *//* *====================================================================== * * Data Manipulation Examples * ************************** * *====================================================================== */Adding records to table
/*-------AddRecords.c---------*//*========================================================================*/#include <stdio.h>#include <string.h>#include "mysql.h"/*========================================================================*/int mysql_exec_sql(MYSQL *mysql,const char *create_definition) {
return mysql_real_query(mysql,create_definition,strlen(create_definition));
}int main(int argc, char **argv) {
MYSQL mysql;
char ccSQL[1000]={0x00};
printf("\n\tLai Anei Kiska \n\t mongotaitang.com.ar/");
printf("\n\t\ laian890@gmail.com\n");
if ( mysql_init(&mysql)==NULL) {
printf("\nFailed to initate MySQL connection");
return(1);
}if (!mysql_real_connect(&mysql,"localhost","root","",NULL,0,NULL,0)) {
printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(&mysql));
return(1);
}if(mysql_select_db(&mysql,"test")==0)
printf( "Database Selected\n");
else
printf( "Failed to connect to Database: Error: %s\n",
mysql_error(&mysql));
strcat(ccSQL,"INSERT INTO TDOCUMENTOS VALUES ( 001,'20190720','DOCUMENTOS NACIONAL DE IDENTIDAD','D.N.I.')");
printf( "%s\n", ccSQL );
if ( mysql_exec_sql(&mysql,ccSQL )==0)
printf( "INSERT OK!\n");
else
printf( "Failed to connect to edit table: Error: %s\n", mysql_error(&mysql));
mysql_close(&mysql);
}/* |----------------------------------------------------------------- | "CREATE TABLE TDOCUMENTOS ( " | "DOC_TIPO SMALLINT NOT NULL, " | "DOC_FECUPTE VARCHAR(060) NOT NULL, " | "DOC_DESCRIP VARCHAR(060) NOT NULL, " | "DOC_ABREVIA CHAR (006) NOT NULL, " | "PRIMARY KEY( DOC_TIPO ) )" |----------------------------------------------------------------- | "Alter TABLE TDOCUMENTOS " | "MODIFY DOC_FECUPTE VARCHAR(008) NOT NULL" |----------------------------------------------------------------- | "DROP TABLE TDOCUMENTOS " |----------------------------------------------------------------- | "CREATE INDEX DOC_TIPOS ON TDOCUMENTOS( DOC_TIPO )" |----------------------------------------------------------------- | "DROP INDEX DOC_TIPOS ON TDOCUMENTOS" |----------------------------------------------------------------- | "INSERT INTO TDOCUMENTOS VALUES ( 001,'20190720','DOCUMENTOS NACIONAL DE IDENTIDAD','D.N.I.'" |----------------------------------------------------------------- */delete all record
/*========================================================================*/#include <stdio.h>#include <string.h>#include "mysql.h"/*========================================================================*/int mysql_exec_sql(MYSQL *mysql,const char *create_definition) {
return mysql_real_query(mysql,create_definition,strlen(create_definition));
}int main(int argc, char **argv) {
MYSQL mysql;
char ccSQL[1000]={0x00};
printf("\n\tLai Anei Kiska \n\t mongotaitang.com.ar/");
printf("\n\t\ laian890@gmail.com\n");
if ( mysql_init(&mysql)==NULL) {
printf("\nFailed to initate MySQL connection");
return(1);
}if (!mysql_real_connect(&mysql,"localhost","root","",NULL,0,NULL,0)) {
printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(&mysql));
return(1);
}if(mysql_select_db(&mysql,"test")==0)
printf( "Database Selected\n");
else
printf( "Failed to connect to Database: Error: %s\n",
mysql_error(&mysql));
strcat(ccSQL,"DELETE FROM TDOCUMENTOS");
printf( "%s\n", ccSQL );
if ( mysql_exec_sql(&mysql,ccSQL )==0)
printf( "DELETE OK!\n");
else
printf( "Failed to connect to edit table: Error: %s\n", mysql_error(&mysql));
mysql_close(&mysql);
}/* |----------------------------------------------------------------- | "CREATE TABLE TDOCUMENTOS ( " | "DOC_TIPO SMALLINT NOT NULL, " | "DOC_FECUPTE VARCHAR(060) NOT NULL, " | "DOC_DESCRIP VARCHAR(060) NOT NULL, " | "DOC_ABREVIA CHAR (006) NOT NULL, " | "PRIMARY KEY( DOC_TIPO ) )" |----------------------------------------------------------------- | "Alter TABLE TDOCUMENTOS " | "MODIFY DOC_FECUPTE VARCHAR(008) NOT NULL" |----------------------------------------------------------------- | "DROP TABLE TDOCUMENTOS " |----------------------------------------------------------------- | "CREATE INDEX DOC_TIPOS ON TDOCUMENTOS( DOC_TIPO )" |----------------------------------------------------------------- | "DROP INDEX DOC_TIPOS ON TDOCUMENTOS" |----------------------------------------------------------------- | "INSERT INTO TDOCUMENTOS VALUES ( 001,'20190720','DOCUMENTOS NACIONAL DE IDENTIDAD','D.N.I.'" |----------------------------------------------------------------- */finding records from table
/*-------FindRecordsStatic.c---------*//*========================================================================*/#include <stdio.h>#include <string.h>#include "mysql.h"/*========================================================================*/int mysql_exec_sql(MYSQL *mysql,const char *create_definition) {
return mysql_real_query(mysql,create_definition,strlen(create_definition));
}int main(int argc, char **argv) {
MYSQL mysql;
MYSQL_RES *result;MYSQL_ROW row;
unsigned int num_fields;
unsigned int i;
char ccSQL[1000]={0x00};
printf("\n\t Lai Anei Kiska \n\t mongotaitang.com.ar");
printf("\n\t\ laian890@gmail.com\n");
if ( mysql_init(&mysql)==NULL) {
printf("\nFailed to initate MySQL connection");
return(1);
}if (!mysql_real_connect(&mysql,"localhost","root","",NULL,0,NULL,0)) {
printf( "Failed to connect to MySQL: Error: %s\n", mysql_error(&mysql));
return(1);
}if(mysql_select_db(&mysql,"test")==0)
printf( "Database Selected\n");
else
printf( "Failed to connect to Database: Error: %s\n",
mysql_error(&mysql));
strcat(ccSQL,"SELECT DOC_TIPO, DOC_DESCRIP, DOC_ABREVIA FROM TDOCUMENTOS");
printf( "%s\n", ccSQL );
if (mysql_exec_sql(&mysql,ccSQL)==0) {
printf( "%ld Record Found\n",(long) mysql_affected_rows(&mysql));
result = mysql_store_result(&mysql);
if (result) {
num_fields = mysql_num_fields(result);
unsigned long *lengths = mysql_fetch_lengths(result);
while ((row = mysql_fetch_row(result))) {
for (i = 0; i < num_fields; i++) {
printf("[%.*s] ", (int)lengths[i], row[i] ? row[i] : "NULL");
}printf("\n");
}mysql_free_result(result) ;
} else {
if(mysql_field_count(&mysql) > 0) {
printf( "Error getting records: %s\n", mysql_error(&mysql));
} } }else
printf( "Failed to connect to edit table: Error: %s\n", mysql_error(&mysql));
mysql_close(&mysql);
}/* |----------------------------------------------------------------- | "CREATE TABLE TDOCUMENTOS ( " | "DOC_TIPO SMALLINT NOT NULL, " | "DOC_FECUPTE VARCHAR(060) NOT NULL, " | "DOC_DESCRIP VARCHAR(060) NOT NULL, " | "DOC_ABREVIA CHAR (006) NOT NULL, " | "PRIMARY KEY( DOC_TIPO ) )" |----------------------------------------------------------------- | "Alter TABLE TDOCUMENTOS " | "MODIFY DOC_FECUPTE VARCHAR(008) NOT NULL" |----------------------------------------------------------------- | "DROP TABLE TDOCUMENTOS " |----------------------------------------------------------------- | "CREATE INDEX DOC_TIPOS ON TDOCUMENTOS( DOC_TIPO )" |----------------------------------------------------------------- | "DROP INDEX DOC_TIPOS ON TDOCUMENTOS" |----------------------------------------------------------------- | "INSERT INTO TDOCUMENTOS VALUES ( 001,'20190720','DOCUMENTOS NACIONAL DE IDENTIDAD','D.N.I.'" |----------------------------------------------------------------- | "SELECT DOC_TIPO, DOC_DESCRIP, DOC_ABREVIA FROM TDOCUMENTOS" |----------------------------------------------------------------- */CGI Examples
JPEG OUTPUT FROM JPEG FIELD
/********************************************************************* g++ -o /usr/local/www/cgi-bin/jpeg_mysql.cgi jpeg_mysql_cgi_test.c-I/usr/local/include -L/usr/local/lib/mysql -lc -lmysqlclient ********************************************************************* */#include <stdio.h>/*#include <sys/types.h>#include <sys/stat.h> fstat#include <sys/uio.h>#include <string.h>*/#include <unistd.h>#include <fcntl.h>#include <stdlib.h>/*get env*/#include <mysql/mysql.h>#include <syslog.h>/*syslog*/#include <stdarg.h>#define HTTP_STR "HTTP/1.1 200 OK\n"#define HTTP_SERVER "Server: Subedar Technologies\n"#define HTTP_CONTENT "Content-type: image/jpeg\n\n"int main(int argc, char *argv[]){char *query="SELECT JPEG FROM Snaps ORDER BY ID DESC LIMIT
1"; MYSQL mysql; mysql_init(&mysql); if(!mysql_real_connect(&mysql,"","your_login_name","your_mysql_password","your_database",0,NULL,0)) {syslog(LOG_CONS,"%s->%s","MySQL Connect
Error:",mysql_error(&mysql)); mysql_close(&mysql); exit(0); } if(mysql_query(&mysql,query)) {syslog(LOG_CONS,"%s->%s","MySQL Query
Eorror:",mysql_error(&mysql)); mysql_close(&mysql); exit(0); } MYSQL_RES *result; result = mysql_use_result(&mysql); if (result) // there are rows { /* retrieve rows, then call mysql_free_result(result)*/ MYSQL_ROW row; if((row = mysql_fetch_row(result))) { unsigned long *lengths =mysql_fetch_lengths(result); if(lengths[0] > 0) { write(STDOUT_FILENO, HTTP_CONTENT,strlen(HTTP_CONTENT)); write(STDOUT_FILENO,row[0],lengths[0]); } } mysql_free_result(result); } mysql_close(&mysql); exit(0);}Z:\Paradox\Programs\pdxwin32.exe -O c:\Ozoia78\L400.cfg -P C:\TEMP -W c:\Ozoia78\Local\ Gamanu.fdl -QGRANT ALL PRIVILEGES ON ATLAS.* TO '/' "
@Echo Off
Rem Compile options file directory path.Set LD_LIBRARY_PATH=C:\MinGW\lib\;C:\MinGW\local\lib\;c:\Mariadb\lib\
Set DIRLIB=C:\Mariadb\lib
Set INCMGW=C:\MinGW\Include
Set INCSQL=C:\Mariadb\include\mysql
Rem Win32 (MinGW) dynamically loaded DLL search path.
Set PATH=C:\MinGW;C:\MinGW\bin;C:\MinGW\local\bin;c:\Mariadb\bin;c:\Mariadb\lib;%PATH%
Rem Temporary files directory path.Set TEMP=%TEMP%
Set CODC=%1.c
Set CODO=%1.o
Set CODE=%1.exe
Rem C:\MinGW\bin\gcc test.c -o test -Wl,-v
Rem C:\MinGW\bin\gcc -c %CODC% -o %CODO%
@Echo On
Rem C:\MinGW\bin\gcc %CODC% -o %CODE% --verbose
echo ===================================================================
echo -I%INCMGW% -I%INCSQL%
echo ===================================================================
rem C:\MinGW\bin\gcc -I%INCMGW% -I%INCSQL% %CODC% -o %CODE% -lpdcurses -lpdcurses_dll --verbose
C:\MinGW\bin\gcc -I%INCMGW% -I%INCSQL% -L%DIRLIB% -L%LD_LIBRARY_PATH% %CODC% -o %CODE% -lmysql --verbose