»¹ÊǹØÓÚc++Á¬½ÓmysqlµÄÎÊÌâ,Çó½â!!
#pragma comment( lib, "libmysql.lib");
Çë½Ì¸ßÊÖ°ï½âÊÍÒ»ÏÂÀ¨ºÅÄÚµÄÿ¸ö²ÎÊýÊÇʲôÒâ˼¡£
ÒÔÏÂÕâ¶Î´úÂë³ö´í¡£
#include <winsock2.h>
#include <iostream>
#include "mysql.h"
//#pragma comment( lib, "libmysql.lib");
using namespace std;
int main(char **args){
MYSQL mysql;
mysql_init(&mysql);
if (mysql_real_connect(&mysql,"localhost","root","ok","test",3306,0,0))
{
cout < <"ok" < <endl;
return 0;
}
else
{
int i = mysql_errno(&mysql);
constchar * s = mysql_error(&mysql);
cout < < s < <endl;
return 0;
}
error LNK2019: ÎÞ·¨½âÎöµÄÍⲿ·ûºÅ _mysql_real_connect@32£¬¸Ã·ûºÅÔÚº¯Êý _main Öб»ÒýÓà (Îļþ1.obj)
error LNK2019: ÎÞ·¨½âÎöµÄÍⲿ·ûºÅ _mysql_init@4£¬¸Ã·ûºÅÔÚº¯Êý _main Öб»ÒýÓà (Îļþ1.obj)
fatal error LNK1120: 2 ¸öÎÞ·¨½âÎöµÄÍⲿÃüÁî E:\×ÊÁÏ\C++\1\Debug\1.exe
ʲôÔÒòÄØ???ÎÒÒѾÓÐmysql api¿âÁË¡£µ«ÊDz»ÖªµÀÈçºÎÈ«²¿µ¼½øÏîÄ¿
ÓõÄʲô±àÒëÆ÷£¿ÎÒÓÃgcc±àÒëʱ»¹Òª¼ÓÉÏ-LÑ¡Ï
ÎÒÓõÄÊÇvs2005¿ª·¢¹¤¾ß
//#pragma comment( lib, "libmysql.lib");
×¢Ê͵ô¸ÉÂð£¿
ÎÒ²»Ì«Çå³þÕâ¸öÊÇ×öʲôÓð¡¡£ËùÒÔ×¢ÊÍÏÈ
ÎÒÓиölib/opt/libmysql.dllÎļþÔÚ×ÀÃæÉÏ£¬Õâ¸ödllÆðµ½Ê²Ã´×÷ÓÃÄØ£¿È
Ïà¹ØÎÊ´ð£º
ÓÃc/c++¶¨Î»É¾³ýÒ»ÐеÄÎÊÌâ¡£
ÎÊÌâ±³¾°£º
ËùÐèÊý¾ÝÏ൱´ó¡£aÓëbÎļþ¾ùΪһ×éÎļþ£¨a1£¬a2¡£¬b1£¬b2¡£©£¬aÎļþÓÐ×î´óÊý¾ÝÐÐÊý£¨Èç5000£©£¬ÒÔÐеÄÐÎʽ£¬´ÓaÎļþÖжÁÈ¡Êý¾Ý£¬½«aÖв»ÄÜ´¦ÀíµÄÊý¾Ý·ÅÔÚbÎ ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......