#include "stdio.h"
#include "winsock2.h"
#include "mysql.h"
#include <tchar.h>
#pragma comment(lib,"libmysql.lib")
//http://copynull.tistory.com/14
const char *host = "서버주소";
const char *user = "ID";
const char *pw = "PW";
const char *db = "DB명";
int _tmain(int argc, TCHAR* argv[]){
MYSQL *connection = NULL;
MYSQL conn;
MYSQL_RES *sql_result;
MYSQL_ROW sql_row;
if (mysql_init(&conn) == NULL){
printf("mysql_init() error!");
}
connection = mysql_real_connect(&conn, host, user, pw, db, 3306, (const char*)NULL, 0);
if (connection == NULL){
printf("%d 에러 : %s , %d\n" , mysql_errno(&conn),mysql_error(&conn));
return 1;
}
else{
printf("연결 성공 \n");
if (mysql_select_db(&conn, db))
{
printf("%d에러 : %s , %d\n ",mysql_errno(&conn),mysql_error(&conn));
return 1;
}
char *query = "select *from 테이블명";
int state = 0;
state = mysql_query(connection, query);
if (state == 0){
sql_result = mysql_store_result(connection);
while ((sql_row = mysql_fetch_row(sql_result)) != NULL){
printf("%s %s %s %s \n",sql_row[0],sql_row[1],sql_row[2],sql_row[3]);
}
mysql_free_result(sql_result);
}
mysql_close(connection);
}
return 0;
}
http://stackoverflow.com/questions/11247699/lnk2019-unresolved-external-symbol-main-referenced-in-function-tmaincrtstar
What is your project type? If it's a "Win32 project", your entry point should be (w)WinMain. If it's a "Win32 Console Project", then it should be (w)main. The name _tmain is #defined to be either mainor wmain depending on whether UNICODE is defined or not.
If it's a DLL, then DllMain.
The project type can be seen under project properties, Linker, System, Subsystem. It would say either "Console" or "Windows".
Note that the entry point name varies depending on whether UNICODE is defined or not. In VS2008, it's defined by default.
The proper prototype for main is either
int _tmain(int argc, _TCHAR* argv[])
or
int _tmain()
Make sure it's one of those.
EDIT:
If you're getting an error on _TCHAR, place an
#include <tchar.h>
If you think the issue is with one of the headers, go to the properties of the file with main(), and under Preprocessor, enable generating of the preprocessed file. Then compile. You'll get a file with the same name a .i extension. Open it, and see if anything unsavory happened to the main() function. There can be rogue #defines in theory...
EDIT2:
With UNICODE defined (which is the default), the linker expects the entry point to be wmain(), not main(). _tmain has the advantage of being UNICODE-agnostic - it translates to either main or wmain.
Some time ago, there was a reason to maintain both an ANSI build and a Unicode build. Unicode support was sorely incomplete in Windows 95/98/Me. The primary APIs were ANSI, and Unicode versions existed here and there, but not pervasively. Also, the VS debugger had trouble displaying Unicode strings. In the NT kernel OSes (that's Windows 2000/XP/Vista/7/8), Unicode support is primary, and ANSI functions are added on top. So ever since VS2005, the default upon project creation is Unicode. That means - wmain. They could not keep the same entry point name because the parameter types are different. _TCHAR is #defined to be either char or wchar_t. So _tmain is either main(int argc, char **argv) or wmain(int argc, wchar_t **argv).
The reason you were getting an error at _tmain at some point was probably because you did not change the type of argv to _TCHAR**.
If you're not planning to ever support ANSI (probably not), you can reformulate your entry point as
int wmain(int argc, wchar_t *argv[])
and remove the tchar.h include line.
