update - select query

2001-04-02 Thread mysql m mysql
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

Re: How compile a C/C++ program which use API for mysql?

2001-04-02 Thread mysql m mysql
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