MYSQL FK INDEX
ÎÒÓÃmyeclipseÔÚ´´½¨ fkµÄʱºò£¬·¢ÏÖDDLÀïÃæË³´ø´´½¨ÁËÒ»¸öindex
ÎÒÏëÎʵÄÊÇ£¬²»´´½¨index£¬¶øÖ±½Ó´´½¨fk£¬¿ÉÐÐô£¿
´´½¨fk´øÒ»¸öindex£¬Õâ¸öindexµÄ×÷ÓÃÊÇʲô?
Êý¾Ý¿â mysql 5¡£0 fk£ºforeign key
indexÊÇË÷ÒýµÄÒâ˼£¬fkµÄÈ«³ÆÊÇÍâ¼üË÷Òý,fk¾ÍÊÇË÷ÒýµÄÒ»ÖÖ¡£
¿ÉÒÔ¡£ FK ±¾Éí¾ÍÊǸöË÷ÒýÁË¡£
Ò»°ãÀ´ËµÄã´´½¨FK£¬³£¼ûµÄ²éѯ¾ÍÊÇ
select ... from a ,b where a.key=b.fk
ÕâÖÖ²éѯ£¬Ò»°ãÀ´ËµÐèÒªË÷ÒýÀ´¼Ó¿ìËÙ¶È¡£
лл¡£¡£¡£´ËÍâ 2Â¥¡£¡£ÄãÖ»ÐèÒª¸æËßÎÒ foreign key is an index ¡£¾ÍºÃÁË¡£¡£²»ÐèÒª·Òë¡£¡£¡£·ÒëÖ®ºó»á¸ü¼Ó»ìÂҵġ£
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
ÎÒÓÃÒ»¸öÑ»·ÍùÊý¾Ý¿âÀïÃæ´æÎļþ£¬±¾À´¿ÉÒÔ×÷ΪÎļþ´æ·ÅÊý¾Ý¿âÀïÃæÖ»·ÅÎļþµÄλÖõ쬵«ÊÇûÓа취×âµÄ·þÎñÆ÷ÍøÒ³¿Õ¼ä´óСÓÐÏÞÖÆÊý¾Ý¿âûÓÐÏÞÖÆ¡£Óï¾äÊÇÕâÑùµÄ
public static final DataBase.MAXSIZE=102 ......
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
mysql>create book(
->id varchar(20) not null,g
->
ÒÔÉÏÊÇÔÚmysqlÃüÁîÐÐÀïµÄ²Ù×÷
ÔÚÉÏÃæÖÐÎÒÔÚµ¹ÊýµÚ¶þÐжà´òÁËÒ»¸ö×ÖĸgÈ»ºó°´Á˻سµ¼ü£¬ÇëÎÊ´Óµ¹ÊýµÚÒ»ÐÐÔõô ......