i need to update a row of a table taking the values of a "select ... from table1,
table2 where table1.row=table2.row group by row" query.
say:
desc source_table;
key int(10) FK
column_source timestamp
desc table_to_update;
key int(10)
column_to_update datet
u just have to tell the compiler where ur mysql header (mysql.h) and shared library
(libmysqlclient.so) are located, e.g.:
gcc -L/usr/local/lib/mysql -lmysqlclient -I/usr/local/include/mysql -o a.out
yourprogram.c
... in this case mysql.h is in the directory /usr/local/include/mysql, and the