ת£ºLinuxϽøÐÐMYSQLµÄC++±à³ÌÆð²½ÊÖ¼Ç
LinuxϽøÐÐMYSQLµÄC++±à³ÌÆð²½ÊÖ¼Ç
Ê×ÏȰ²×°±ØÐèµÄ¿ª·¢°ü
sudo apt-get install gcc g++ libgcc1 libg++ make gdb
°²×°MYSQLµÄCÓïÑÔ¿ª·¢°ü
sudo apt-get install libmysql++-dev libmysql++2c2a libmysqlclient15-dev libmysqlclient15off
°ÑlibÎļþ¿½±´µ½¹«ÓÃ
sudo cp /usr/lib/mysql/* /usr/lib/
½¨Á¢Ò»¸öÐÂÎļþtest.cpp
nano test.cpp
ÊäÈëÄÚÈÝ
#include <stdio.h>
#include <stdlib.h>
#include "/usr/include/mysql/mysql.h"
int main() {
MYSQL mysql;
mysql_init(&mysql);
}
ctrl+O±£´æctrl+xÍ˳ö¡£
È»ºó±àÒë
g++ -lmysqlclient test.cpp -o test
ÔËÐÐ
./test
Èç¹ûʲô¶¼Ã»Ìáʾ£¬Ã»´íÎ󣬾Í˵Ã÷³É¹¦ÁË¡£
¾ÍÊÇÕâÑù¡£¶÷¡£»¹ÊÇÂú¡£¡£¡£¼òµ¥µÄ˵¡£
Ïà¹ØÎĵµ£º
»ù´¡²¿·Ö
Ò»¡¢MySQL »ñµÃµ±Ç°ÈÕÆÚʱ¼ä º¯Êý
1.1 »ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date + time£©º¯Êý£ºnow()
mysql> select now();
+---------------------+
| now() |
+----------------- ......
×÷Õߣºandyao
ÔÎÄlink: http://andyao.javaeye.com/admin/show/144033
×ªÔØÇëÁôÃû
1. ¼ò½é
ÔÚWebÓ¦ÓóÌÐòÌåϵ¼Ü¹¹ÖУ¬Êý¾Ý³Ö¾Ã²ã£¨Í¨³£ÊÇÒ»¸ö¹ØÏµÊý¾Ý¿â£©ÊǹؼüµÄºËÐIJ¿·Ö£¬Ëü¶ÔϵͳµÄÐÔÄÜÓзdz£ÖØÒªµÄÓ°Ïì¡£MySQLÊÇĿǰʹÓÃ×î¶àµÄ¿ªÔ´Êý¾Ý¿â£¬µ«ÊÇMySQLÊý¾Ý¿âµÄĬÈÏÉèÖÃÐÔÄܷdz£µÄ²î£¬½ö½öÊÇÒ»¸öÍæ¾ßÊý¾Ý¿â¡£Òò´ËÔÚ ......
ÒÔÏÂת×Ô£ºhttp://www.lerich.com/viewthread.php?tid=640
Ö÷»úΪWindowsXPϵͳ£¬VMwareÐéÄâ»úÀï°²×°Linux²Ù×÷ϵͳ¡£°²×°ÍêVMwareºó£¬Ö÷»úµÄÍøÂçÁ¬½ÓÀïÃæ³öÏÖÁËÁ½¸öеÄÁ¬½Ó£¬¼´VMware Network Adapter VMnet1ºÍVMware Network Adapter VMnet8Èçͼ¡£ÐéÄâ»úÀï°²×°µÄϵͳ¾ÍÊÇ¿¿ÕâÁ½¸öÐéÄâÍø¿¨À´ÁªÍøµÄ¡££¨ÈçÏÂͼ£©
Ö÷»úÉÏÀ ......
Èç¹ûÄãºÜÏëÖªµÀÕû¸ö²Ù×÷ϵͳÄÚµÄÿ¸öĿ¼ÄÚ¶¼ÓÐЩʲô£¬Ö´ÐÐÃüÁ
cd / && tree >> ~/filesystem.tree
Õ⽫ÊÇÒ»¸ö¶à´ï8MµÄÎļþ£¬ÀïÃæ»áÃèÊöÕû¸öÎļþϵͳµÄĿ¼¼°ÆäÎļþ½á¹¹£¬ÏÖÔÚ¾ÍÕûÌå¶øÑÔÀ´¸ÅÊöһϣº
Ò»¼¶»ù±¾Ä¿Â¼½á¹¹£º
/
Îļþϵͳ¸ùĿ¼£¬Î»ÓÚÕû¸öÎļþϵͳµÄ×î¶¥¼¶
/boot
´æ·Å×ÅÆ ......
ÏëÖªµÀµ½Linux·ÖÇø·½°¸µÄÕæÏàô£¬ÏëÖªµÀLinux·ÖÇø·½°¸ÖвØÓеÄÄÚÔÚ°ÂÒåô£¬Ö»ÓÐÎÒÀ´¸ø´ó¼ÒÈ«Ãæ½²½â½éÉÜLinux·ÖÇø·½°¸
×îÐÂLinux·ÖÇø·½°¸
ÎҵķþÎñÆ÷ÊÇ500G¡£×îÖØÒªµÄÊÇ/var·ÖÇøÒ»¶¨Òª´ó(²»ÂÛpostfixÓʼþ£¬»¹ÊÇLAMPµÄWEB ·þÎñÆ÷µÈ£©¡£×îºÃÊÇ400GÒÔÉÏ¡£¾ßÌåµÄ/boot Ö»Òª100M¾Í×ã¹»ÁË¡£ÏÂÃæÊÇÎҵķÖÇø·½°¸£ºÓ²ÅÌ500G
·þ ......