Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......

MYSQL°²×°Ê§°Ü

ÎÒÒÔǰ°²×°ÁËÒ»´Î£¬ºóÀ´Ð¶ÔØÁË£¬ÏÖÔÚÔÙ°²×°µÄʱºò£¬Ìáʾ´íÎó£ºError 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it. 
¿ ......

mysql like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......

cÓïÑÔÈçºÎÁ¬½ÓMYSQL£¿

´ó¼ÒºÃ:
ÎÒÊǸãCµÄ, ÏÖÔÚÏëÓÃC Á¬½ÓMYSQL,µ«ÊÇÔõôҲÁ¬½Ó²»ÁË,ÎҵĴúÂëÈçÏÂ:
#include <stdio.h>
#include "C:\Program Files\MySQL\MySQL Server 5.0\include\mysql.h"
......

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ