c++µ÷ÓÃmysql½Ó¿ÚÒÔ¼°´æ´¢¹ý³Ì
mysqlÔÚsdkÖÐΪcÓïÑÔÌṩÁËһЩ·ÃÎʽӿڣ¬ÎÒÃÇ¿ÉÒÔʹÓÃÕâЩ½Ó¿ÚÁ¬½Ó²¢·ÃÎÊmysqlÊý¾Ý¿â£¬µ±È»Ò²¿ÉÒÔµ÷ÓÃmysqlµÄ´æ´¢¹ý³Ì¡£
Àý×Ó£º
Ê×ÏÈÏÂÔØmysqlµÄsdk£¬½âѹºÃÒÔºó£¬ÀïÃæ°üº¬Ò»¸öinclude,ºÍlibÎļþ¼Ð¡£ÎÒÃÇÔÚ×Ô¼ºµÄ¹¤³ÌÖаüº¬ÕâÁ½¸öÎļþ¼ÐµÄĿ¼£¬²¢ÇÒÉèÖúÃÁ¬½Ó¿âÑ¡Ïî¼´¿É¡£ ÎÒÃÇÏȽ¨Á¢Ò»¸ö¹¤³Ì£¬ÔËÐÐÏ¿´¿´£¬ÔÙ¿´ÆäÖеĴúÂë¡£
1. ÕâÀïÎÒÃÇʹÓÃvs2003½¨Á¢Ò»¸ö¿ÕµÄwindow console¹¤³Ì£¬Ìí¼ÓÒ»¸öcppÔ´Îļþ¡£
2. ¿½±´×îºóÃæµÄÔ´´úÂëµ½cppÎļþÖС£
3. ÉèÖúù¤³Ì·¾¶£ºproject --> properity --> c/c++ÏÂgeneralÑ¡ÏîÖÐAdditional include directoriesÑ¡ÏîÌí¼ÓÉÏÃæ˵µÄincludeĿ¼¡£ project --> properity --> linkerÏÂgeneralÑ¡ÏîÖÐAdditional library directoriesÖÐÌí¼ÓÉÏÃæµÄlibĿ¼¡£project --> properity --> linkerÏÂinputÑ¡ÏîÖÐÌí¼Ólibmysql.libÎļþ¡£ÕâÑùÎÒÃǵŤ³Ì¾ÍÉèÖÃÍê±Ï¡£
4. ÏÂÃæ±àÒë-Á¬½Ó-ÔËÐС£ÔÚ´°¿ÚÖпÉÒÔ¿´µ½½á¹û¡£
×ܽ᣺
1. mysqlÌṩmysql_query()À´ÔÚcÓïÑÔÖÐʹÓÃsqlÓï¾äÀ´·ÃÎÊÊý¾Ý¿â¡£Í¬Àí£¬ÎÒÃÇ¿ÉÒÔʹÓøýӿÚÖ´ÐÐcall processname()Õâ¸öÓï·¨À´µ÷ÓÃmysqlµÄ´æ´¢¹ý³Ì¡£´úÂëÖÐÒ²ÊÇÕâôʹÓõġ£
2. ÕâÀïÎÒÃÇÐèÒªÌáÇ°ÔÚmysqlÊý¾Ý¿âÖд´½¨Ò»¸ö´æ´¢¹ý³Ì£¬¾ßÌåµÄ´´½¨·½·¨£¬ÔÚÎÄÕ¡¾mysql´æ´¢¹ý³Ì¼ò½é ¡¿ÖÐÓнéÉÜ¡£
3. °üº¬mysql.hÐèÒª°üº¬window.h²Å¿ÉÒÔÕý³£±àÒë¡£
¸½
Êý¾Ý¿â˵Ã÷£º
¸ÃÀý×ÓÖУ¬ÎÒÃÇÒѾÔÚtestÊý¾Ý¿âÖн¨Á¢Ò»¸öshop±í£¬ÆäÖÐÓÐÈý¸ö×ֶΣ¬article int(4), dealer char(20), price double(16,2)¡£ ´æ´¢¹ý³ÌΪÔÚshop±íÖÐÔö¼ÓÒ»Ìõ¼Ç¼¡£
mysql´æ´¢¹ý³Ì´úÂ룺
CREATE DEFINER=`root`@`localhost` PROCEDURE `AddInfo`(`_article` int(4), `_dealer` char(20), `_price` double(16,2) )
BEGIN
set @result = 0;
insert into shop values( _article, _dealer, _price );
 
Ïà¹ØÎĵµ£º
1¡¢C/C++³ÌÐòÔ±Çë×¢Ò⣬²»ÄÜÔÚcaseÓï¾ä²»Îª¿Õʱ“ÏòÏÂÖ´ÐД¡£
2¡¢ÖµÀàÐͺÍÒýÓÃÀàÐÍÖ®¼äµÄÇø±ð£ºC#µÄ»ù±¾ÀàÐÍ£¨int£¬charµÈ£©¶¼ÊÇÖµÀàÐÍ£¬ÊÇÔÚÕ»Öд´½¨µÄ¡£¶ø¶ÔÏóÊÇÒýÓÃÀàÐÍ£¬´´½¨ÓÚ¶ÑÖУ¬ÐèҪʹÓùؼü×Önew¡£
3¡¢ÔÚC#ÖÐͨ¹ýʵÀý·ÃÎʾ²Ì¬·½·¨»ò³ÉÔ±±äÁ¿ÊDz»ºÏ·¨µÄ£¬»áÉú³É±àÒëÆ÷´íÎó¡£µ«ÊÇÎÒÃÇ¿ÉÒÔͨ¹ýÉùÃ÷ËûÃÇ ......
Ò»Ö±ÏëдһЩ±È½ÏCºÍC++Éè¼ÆÓë±à³Ì·ç¸ñµÄÎÄ×Ö£¬ÕýºÃ½üÀ´¹¤×÷ÈÎÎñ²»¶à£¬Äܹ»ÓÐʱ¼äÖØÐÂÕûÀíÒ»ÏÂ×Ô¼ºËùѧµÄ¶«¶«£¬ÓÚÊDZã¾ö¶¨¿ªÊ¼Ð´Õâ¸öÌâÄ¿£¬¶øÄ¿µÄ½ö½öÖ»ÊÇ´òËãÄܾÍÕâ¸ö»°ÌâºÍ´ó¼ÒÌÖÂÛÌÖÂÛ£¬Å×שÒýÓñ¡¢Ôö³¤¸öÈ˵ļûʶ¡£
Ê×ÏÈÏë˵Ã÷һϣ¬¸öÈËÊÇC++Éè¼Æ¡¢±à³Ì·ç¸ñµÄ¼á¶¨Óµ»¤Õߣ¬ËùÒÔÎҵĹ۵ãÄÑÃâ´øÓиöÈ˵ÄÆ«ºÃ£¬Èç¹ûÄú²»ÔÞÍ ......
1.¼ì²éÒÔÇ°°²×°µÄMySQL,жÔØ¡£
rpm -qa|grep -i mysql
rpm -e XXXXX
×¢Èç¹û³öÏÖÁ½ÌõÏàͬµÄ£¬ÔòʹÓÃrpm -e --allmatches
2.°²×°rpm°ü¡£
rpm -ivh MySQL-server-community-5.1.37-0.rhel5.x86_64.rpm
rpm -ivh MySQL-shared-community-5.1.37-0.rhel5.x86_64.rpm
rpm -ivh MySQL-devel-community-5.1.37-0.rhel5.x86_6 ......
Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Çóƽ¾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇƽ¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚƽ¾ùÖµ¸ ......
ÊÔÑé1
ÊÂÎñ1£º
#!/usr/bin/python
import time
import MySQLdb;
conn = MySQLdb.connect(host="localhost",port=3306,user="root",passwd="asdf",db="test",unix_socket="/data/mysql_3306/mysql.sock")
cursor = conn.cursor()
cursor.execute("select * from test")
while str!="1":
str = r ......