sqlite 及其编译问题_sqlite undefine refrence to winmain-优快云博客

本文链接：https://blog.youkuaiyun.com/Tree_in_sea/article/details/100597449

在Ubuntu系统中编译sqlite时遇到了链接错误，如`undefined reference to `sqlite3_open'`等。尝试通过添加链接库路径 `-L /usr/local/lib` 和包含头文件的路径 `-I /usr/local/include/` 以及静态链接 `-static` 解决问题。最终成功编译生成了sqlexe可执行文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ubuntu@sky:~/sqlite$ gcc sql_get_table.c

/tmp/cc6DoZtO.o: In function `main':

sql_get_table.c:(.text+0x73): undefined reference to `sqlite3_open'

sql_get_table.c:(.text+0x8a): undefined reference to `sqlite3_errmsg'

sql_get_table.c:(.text+0x165): undefined reference to `sqlite3_get_table'

sql_get_table.c:(.text+0x203): undefined reference to `sqlite3_free_table'

sql_get_table.c:(.text+0x215): undefined reference to `sqlite3_close'

collect2: ld returned 1 exit status

ubuntu@sky:~/sqlite$

ubuntu@sky:~/sqlite$ gcc -o sqlexe -L /usr/local/lib -I /usr/local/include/ -static sqlexe.c -lsqlite3

/usr/lib/gcc/i686-linux-gnu/4.6/../../../../lib/libsqlite3.a(sqlite3.o): In function `pthreadMutexTry':

(.text+0x10b6d): undefined reference to `pthread_mutex_trylock'

/usr/lib/gcc/i686-linux-gnu/4.6/../../../../lib/libsqlite3.a(sqlite3.o): In function `pthreadMutexFree':

(.text+0x10b9e): undefined reference to `pthread_mutex_destroy'