MySQLÖн«Êý¾Ý¿â´´½¨µ½Ö¸¶¨Ä¿Â¼µÄÓï¾ä
RT£¬·ÇĬÈϵÄdataĿ¼
Çó¾È£¡
Ð޸IJÎÊýdatadirÖ¸Ïò¿ÉÒÔÂú×ãÄãµÄÒªÇóÂð£¿
Èç¹û²»Ðеϰ£¬ÄÇ¿¼ÂÇÓÃÁ´½ÓÎļþĿ¼µÄģʽ°É
linux / unix Ï¿ÉÒÔµ¥¶ÀÖ¸¶¨Ã¿¸ö±íµÄĿ¼£¬µ«WINDOWSÖв»¿ÉÒÔ¡£
LINUX/UNIX ÏÂÄã¿ÉÒÔÓÃ
create table xxxx () DATA DIRECTORY = 'absolute path to directory'
ÔÚÅäÖÃÎļþ¸ü¸Ä
my.cnf »òÕßmy.ini
ÐÞ¸Ädatadir="path"
create table tbl
(
)
DATA DIRECTORY = 'data_dir' INDEX DIRECTORY = 'index_dir'
Õâ¸öÓ¦¸Ã²»´æÔÚlinuxºÍwindows»·¾³µÄÎÊÌâ¡£±ê×¼sql¾ÍÊÇÕâô˵µÄ¡£
¾ßÌå¿É²Î¼û£º
http://dev.mysql.com/doc/refman/5.1/en/create-table.html
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......