It is also a problem of C operation MYSQL: undefined reference to '_mysql_init' etc.

rustler

After reading some old posts, but still can't get it, always prompt:
undefined reference to '_mysql_init'
undefined reference to '_mysql_real_connection'
undefined reference to '_mysql_error'
undefined reference to '_mysql_real_query'
...
and many more
The environment I use is:
WINDOWS XP SP2
cygwin
gcc3.4.4
MYSQL is Windows version 5.0
Works fine with JAVA.

My compilation is:
gcc -o main.exe main.c -I / usr / include / mysql -lmysqlclient

I have COPY the include file under mysql to / usr / include / mysql
mysqlclient.lib under lib / opt is also COPY to / usr / lib.

Please give me some advice. Thank you very much!
Here is the source code


The source code is from another post of COPY
#include <mysql / mysql.h>
#include <stdio.h>

int main () {
   MYSQL * mysql;
   MYSQL_RES * res;
   MYSQL_ROW row;
   char * query;
   int t, r;

   mysql_init (mysql);
   if (! mysql_real_connect (mysql, "localhost", "root",
        "loveyou", "spider", 0, NULL, 0))
   {
       printf ("Error connecting to database:% s\n", mysql_error (mysql));
   }
   else printf ("Connected ...\n");

   query = "select * from spider_work_unsite";

   t = mysql_real_query (mysql, query, (unsigned int) strlen (query));
   if (t)
   {
      printf ("Error making query:% s\n",
              mysql_error (mysql));
   }
   else printf ("Query made ...\n");
   res = mysql_use_result (mysql);
   for (r = 0; r <= mysql_field_count (mysql); r ++) {
           row = mysql_fetch_row (res);
           if (row <0) break;
           for (t = 0; t <mysql_num_fields (res); t ++) {
                   printf ("% s", row [t]);
           }
           printf ("\n");
   }
   mysql_close (mysql);
}

lklklk

The path to the library could not be found, or your include path is incorrect. Please check if your include path includes your include file

hzxszmh

I have COPY the include file under mysql to / usr / include / mysql
mysqlclient.lib under lib / opt is also COPY to / usr / lib.
How could the windows directory look like this? What about the drive letter?
Obviously the directory settings are wrong

momo11xiao

Let me show you the way. ?

orangedj

-I / usr / include / mysql There are spaces in the middle? ?

unicorn027

Or path problem

picky222

-I /usr/include mysql
-L /usr/lib/mysql
-lmysqlclient

picky222

Library file not found

柳绿长街

Feeling is a matter of path

kill31

1. The following is the result of studying mysql 5.0.22, describing and using standard c++ performance
Shows the process of simple operation of the database using MySQLC API functions;
The example program is debugged on VC6 (VC7.1) + windows 2000;
The example program was debugged on red hat linux 9, red fc6

http://blog.csdn.net/kill31/archive/2006/12/14/1443031.aspx