ת£º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ÖпÉͨ¹ý×ֶεÄAUTO_INCREMENTÊôÐÔÀ´×Ô¶¯Éú³É¡£MySQLÖ§³Ö¶àÖÖÊý¾Ý±í£¬Ã¿ÖÖÊý¾Ý±íµÄ×ÔÔöÊôÐÔ¶¼ÓÐËù²»Í¬¡£
ISAM±í
Èç¹û°ÑÒ»¸öNULL²åÈëµ½Ò»¸öAUTO_INCREMENTÊý¾ÝÁÐÀïÈ¥£¬MySQL½«×Ô¶¯Éú³ÉÏÂÒ»¸öÐòÁбàºÅ¡£±àºÅ´Ó1¿ªÊ¼£¬²¢1Ϊ»ùÊýµÝÔö¡£
µ±²åÈë¼Ç¼ʱ£¬Ã»ÓÐΪAUTO_INCREMENTÃ÷È ......
»ù´¡²¿·Ö
Ò»¡¢MySQL »ñµÃµ±Ç°ÈÕÆÚʱ¼ä º¯Êý
1.1 »ñµÃµ±Ç°ÈÕÆÚ+ʱ¼ä£¨date + time£©º¯Êý£ºnow()
mysql> select now();
+---------------------+
| now() |
+----------------- ......
ÓÒ¼üÎҵĵçÄÔ->ÊôÐÔ->¸ß¼¶->»·¾³±äÁ¿
¿ÉÒÔ¿´µ½ÓÐÓû§±äÁ¿ºÍϵͳ±äÁ¿
ÔÚÕâÀïÎÒÃÇ¿ÉÒÔ½øÐÐÐ޸Ļ·¾³±äÁ¿
±ÈÈç˵ÎÒÃǰ²×°ÁËMySQL·þÎñÆ÷£¬Ïë½øÈëMySQLµÄÃüÁîÐеϰ¾Í±ØÐëÔËÐÐcmd
Èç¹ûûÓÐÉèÖû·¾³±äÁ¿µÄ»°ÎÒÃDZØÐë½øÈëMySQLµÄ°²×°Â·¾¶²ÅÄÜʹÓÃmysql -u root -pÕâ¸öÃüÁî
ÕâÑù»á¸øÎÒÃÇ´øÀ´ºÜ¶àÂé·³£¬ÕâʱºòÎÒÃÇÏëÔ ......
du -sh * ²é¿´µ±Ç°Ä¿Â¼ÏµÄÎļþ¼Ð´óС
du ÃüÁî
ÓÃ;
¸ÅÊö´ÅÅÌʹÓá£
Óï·¨
du [ -a | -s ] [ -k ] [ -m ] [ -g ][ -l ] [ -r ] [ -x ] [ -H | -L ][ File ... ]
ÃèÊö
duÃüÁîÏÔʾÓÃÓÚÎļþµÄ¿éµÄÊýÁ¿¡£Èç¹ûÖ¸¶¨µÄFile²ÎÊýʵ¼ÊÉÏÊÇÒ»¸öĿ¼£¬¾ÍÒª±¨¸æ¸ÃĿ¼ÄÚµÄËùÓÐÎļþ¡£Èç¹ûûÓÐÌṩ File²ÎÊý£¬duÃüÁîÊ¹Ó ......
ÏëÖªµÀµ½Linux·ÖÇø·½°¸µÄÕæÏàô£¬ÏëÖªµÀLinux·ÖÇø·½°¸ÖвØÓеÄÄÚÔÚ°ÂÒåô£¬Ö»ÓÐÎÒÀ´¸ø´ó¼ÒÈ«Ãæ½²½â½éÉÜLinux·ÖÇø·½°¸
×îÐÂLinux·ÖÇø·½°¸
ÎҵķþÎñÆ÷ÊÇ500G¡£×îÖØÒªµÄÊÇ/var·ÖÇøÒ»¶¨Òª´ó(²»ÂÛpostfixÓʼþ£¬»¹ÊÇLAMPµÄWEB ·þÎñÆ÷µÈ£©¡£×îºÃÊÇ400GÒÔÉÏ¡£¾ßÌåµÄ/boot Ö»Òª100M¾Í×ã¹»ÁË¡£ÏÂÃæÊÇÎҵķÖÇø·½°¸£ºÓ²ÅÌ500G
·þ ......