wiki.raudys.com

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
reikia instaliuoti mysql biblioteka kad galima butu programuoti mysql per c/c++ 
<code>
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install libmysqlclient-dev
</code>

http://www.raspberry-projects.com/pi/programming-in-c/databases-programming-in-c/mysql/setup-mysql-c-access

tiesiog instaliuoti mysql klienta kuris leidzia jungtis prie kitos bazes
  sudo apt-get install mysql-client


<code c>
#include <stdio.h>
#include <stdlib.h>
#include <signal.h>
 
#include <mysql/mysql.h>
 
#include <pigpio.h>
 
/* 
gcc -Wall -pthread -o test_mysql test_mysql.c -lpigpio -O3 `mysql_config --cflags` `mysql_config --libs`
sudo ./test_mysql
*/

 
int main(int argc, char *argv[])
{
  if (gpioInitialise() < 0) return -1;

  MYSQL *con = mysql_init(NULL);

  if (con == NULL) 
  {
      fprintf(stderr, "%s\n", mysql_error(con));
      exit(1);
  }

  if (mysql_real_connect(con, "xxx.lt", "algo_xxxx", "xxxxx", 
          "algo_aistis", 0, NULL, 0) == NULL) 
  {
      fprintf(stderr, "%s\n", mysql_error(con));
      mysql_close(con);
      exit(1);
  }  

  if (mysql_query(con, "insert into temperature (ts, value, location) values (LOCALTIMESTAMP(), 10, 'HOME_NORTH');")) 
  {
      fprintf(stderr, "%s\n", mysql_error(con));
      mysql_close(con);
      exit(1);
  }

  mysql_close(con);

  return 0;   
}
</code>