tail --follow /var/log/kope.log

Mysql desde C

jueves 24 septiembre 2009 11:33:13, C,

Compilar con:

gcc -I/usr/include/mysql archivo.c -lmysqlclient -lsocket -lnsl -lm -lz

#include <mysql.h>
#include <stdio.h>

int main (void)
{
   MYSQL *conn;
   MYSQL_RES *res;
   MYSQL_ROW row;

   char *server   = "servidor.mysql.com";
   char *user     = "usuario";
   char *password = "password";
   char *database = "nombreBaseDatos";
   
   conn = mysql_init (NULL);
   
   /* Connect to database */
   if (!mysql_real_connect (conn, server, user, password, database, 0, NULL, 0))
   {
      fprintf (stderr, "%s
", mysql_error (conn));
      return(0);
   }

   /* send SQL query */
   if (mysql_query (conn, "SELECT * FROM tabla"))
   {
      fprintf (stderr, "%s
", mysql_error(conn));
      return(0);
   }

   res = mysql_use_result (conn);
   
   /* output fields 1 and 2 of each row */
   while ((row = mysql_fetch_row (res)) != NULL)
      printf("%s %s
", row[1], row[2]);

   /* Release memory used to store results and close connection */
   mysql_free_result (res);
   mysql_close (conn);
}