Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

mysqlÓï¾äÓÅ»¯ÎÊÌâ ´ó¼Ò¸øÓÅ»¯¸öSQLÓï¾ä

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. ......

mysqlÄ£ºý²éѯÈçºÎ²éѯÁ½¸ö¹Ø¼ü×Ö

ÎÒÓõÄlikeÄ£ºý²éѯ£¬±ÈÈçmysqlµÄnameÖÐÓС°csdnÂÛ̳ϵͳ¡±Õ⼸¸ö×Ö£¬ÈçºÎÔÚ <input>Öвéѯ¡°csdn ϵͳ¡±Ò²ÄܳöÀ´Õâ¸ö¡°csdnÂÛ̳ϵͳ¡±£¬ÎÒÏÖÔÚÊDz顰csdn¡±»òÕß¡°ÏµÍ³¡±¶¼¿ÉÒÔ¡£Ð»Ð»¸÷λÁË£¡²»ÖªµÀÎÒÕâô±í´ï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ