WindowsÏÂÓÃGCCÁ¬½ÓMySQLÊý¾Ý¿â
Ò»¸öÍøÓÑÔÚ̳×ÓÉÏÎʵ½µÄÎÊÌ⣬˵ÓÃMinGW GCC±àÒëÔËÐÐÒ»¸öÁ¬½ÓMySQLÊý¾Ý¿âµÄ³ÌÐòʱÓöµ½´íÎó£º
undefined reference to `mysql_init@4'
undefined reference to `mysql_real_connect@32'
undefined reference to `mysql_close@4'
ÎÒËìÈ¥MySQL¹ÙÍøÏÂÁ˸ö×îеÄWindows C Connector£¬È»ºó°´Õý³£Ë¼Â·Ð´Á˸ö×î¼òµ¥µÄÁ¬½Ó²âÊÔ³ÌÐò£¬¹ûÈ»³öÏÖÁËͬÑùµÄ´íÎó¡£
ºóÀ´ÔÚÍøÉϲéÁËÏ£¬Ò²¿´ÁËÏÂMysql¹ÙÍøÉϱðÈ˵ÄÌÖÂÛ£¬¾Ý³ÆMySQL¹Ù·½ÏÂÔØµÄWindows C¿ª·¢°üÖ»ÄÜÔÉú̬֧³ÖCL±àÒëÆ÷£¬¶øÓÃGCCÒ²²¢·Ç²»¿É£¬Ö»ÊÇÐèÒª×öһЩ¶îÍâµÄ¹¤×÷¡£ÏȽ«ºóÀ´ÊÔÑé³É¹¦µÄ²½Öè±Ê¼ÇÓÚ´Ë£¬Ö÷Òª²Î¿¼ÓÐhttp://dev.mysql.com/doc/refman/5.0/en/windows-client-compiling.html¡£
ÏÈÏÂÔØÒ»ÏÂMinGW¹¤¾ß°ü£¬ÏÂÔØµØÖ·ÊÇhttp://prdownloads.sourceforge.net/mingw/mingw-utils-0.2.tar.gz?download
½âѹ£¬½«´Ë¹¤¾ß°üÖеÄbinĿ¼¼ÓÈëϵͳ»·¾³±äÁ¿µÄPath±äÁ¿¡£
ÔÚMysql¿ª·¢°üµÄlibĿ¼Ï£¬¼´libmysql.libºÍlibmysql.dllµÄËùÔÚĿ¼£¬ÔËÐÐ
reimp -d libmysql.lib
µÃµ½µ¼³öÎļþLIBMYSQL.def£¬
È»ºóÔÚ´ËĿ¼ÔËÐÐMinGW GCC±¾Éí×Ô´øµÄÃüÁî
dlltool -k -d libmysql.def -l libmysql.a
µÃµ½ÎÒÃÇ×îºóÐèÒªÁ´½ÓµÄ¿âÎļþlibmysql.a¡£
ÔÚMysql¿ª·¢°üµÄĿ¼ÏÂ(¼´ÓëincludeºÍlibͬ¼¶)н¨ÎÒÃǵIJâÊÔÎļþmain.c£¬²âÊÔÔ´ÂëÈçÏ£º
#include <stdio.h>
#include <winsock2.h>
#include "mysql.h"
int main()
{
MYSQL mysql;
mysql_init(&mysql);
if(!mysql_real_connect(&mysql, "localhost", "root", "admin", "demo", 3306, NULL, 0))
{
printf("\nconnect error!");
}
else
{
printf("\nconnect success!\n");
}
mysql_close(&mysql);
return 0;
}
ÔÚÔ´ÎļþËùÔÚ·¾¶ÔËÐбàÒëÃüÁ
gcc -Iinclude -Llib main.c -llibmysql
¼´±àÒë³É¹¦¡£Êý¾Ý¿âÒàÁ¬½Ó³É¹¦¡£
²âÊÔ»·¾³£º
²Ù×÷ϵͳ£ºWindows XP Prefessional sp2
Êý¾Ý¿â°æ±¾£ºMySQL-5.0.22-commu
Ïà¹ØÎĵµ£º
ÏÔʾ¡¢ÉèÖÃ×Ô¶¯Ìá½» show variable like 'autocommit' set autocommit=1 or 0
ÉèÖÃÈÕÖ¾£º
ÔÚ/etc/mysql/my.cnfÖÐÉèÖÃÈçÏ¿ÉÔÙslow.logÖÐÊä³öÔËÐÐʱ¼ä³¬¹ýÒ»ÃëµÄsqlÓï¾ä
[mysqld]
log-slow-queries = /tmp/slow.log
long_query_time = 1
ÉèÖÃÈÕÖ¾Êä³öÔËÐг¬¹ý1ÃëµÄsqlÓï¾ä set global long_query_ti ......
1.ʹÓÃINSERT²åÈë¶àÌõ¼Ç¼
¿´µ½Õâ¸ö±êÌâÒ²Ðí´ó¼Ò»áÎÊ£¬ÕâÓÐʲôºÃ˵µÄ£¬µ÷Óöà´ÎINSERTÓï¾ä²»¾Í¿ÉÒÔ²åÈë¶àÌõ¼Ç¼ÁËÂð!µ«Ê¹ÓÃÕâÖÖ·½·¨ÒªÔö¼Ó·þÎñÆ÷µÄ¸ººÉ£¬ÒòΪ£¬
Ö´ÐÐÿһ´ÎSQL·þÎñÆ÷¶¼ÒªÍ¬Ñù¶ÔSQL½øÐзÖÎö¡¢ÓÅ»¯µÈ²Ù×÷¡£ÐÒºÃMySQLÌṩÁËÁíÒ»ÖÖ½â¾ö·½°¸£¬¾ÍÊÇʹÓÃÒ»ÌõINSERTÓï¾äÀ´²åÈë¶àÌõ¼Ç¼¡£Õâ²¢
²»ÊDZê×¼µÄSQL ......
mysqlÖÐINSTRº¯ÊýµÄÓ÷¨
INSTR(×Ö¶ÎÃû, ×Ö·û´®)
Õâ¸öº¯Êý·µ»Ø×Ö·û´®ÔÚijһ¸ö×ֶεÄÄÚÈÝÖеÄλÖÃ, ûÓÐÕÒµ½×Ö·û´®·µ»Ø0£¬·ñÔò·µ»ØÎ»Ö㨴Ó1¿ªÊ¼£©
SELECT * from tblTopic ORDER BY INSTR( topicTitle, 'ha' ) > 0 DESC
SELECT INSTR( topicTitle, 'ha' ) from tblTopic
mysqlÖÐʹÓÃinstrÅäºÏINÅÅÐò
½«instr½á¹û×÷Î ......
1¡¢±à¼MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÅäÖÃÎļþ£º
windows»·¾³ÖУº%MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)_installdir%\my.ini¡¡//Ò»°ãÔÚMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)°²×°Ä¿Â¼ÏÂÓÐmy.ini¼´MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄÅäÖÃÎļþ¡£
linux»·¾³ÖУº/etc/my.cnf
ÔÚ[MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)d]ÅäÖöÎÌí¼ÓÈçÏÂÒ»ÐУº
skip-grant-tables
......
Unixʱ¼ä´Á×îСµ¥Î»ÊÇÃ룬¿ªÊ¼Ê±¼äΪ¸ñÁÖÍþÖαê׼ʱ¼ä1970-01-01 00:00:00
ConvertIntDateTime·½·¨µÄ»ù±¾Ë¼Â·ÊÇͨ¹ý»ñÈ¡±¾µØÊ±Çø±íʾUnixk¿ªÊ¼Ê±¼ä£¬¼ÓÉÏUnixʱ¼äÖµ£¨¼´¹ýÈ¥µÄÃëÊý£©.
ConvertDateTimeInt·½·¨µÄ»ù±¾Ë¼Â·ÊÇͨ¹ý¿Ì¶ÈÊý²î£¬Ôٰѿ̶ÈÊýת»»ÎªÃëÊý£¬µ±È»ÒªËµÃ÷µÄÊÇ£¬ÎÒÕâÀï·µ»ØµÄÊÇdoubleÀàÐÍ£¬ÒâÒåÉϲ¢·ÇÊÇÕæ ......