MySQL .Íâ¼üÔ¼Êø
InnoDBÒ²Ö§³ÖÍâ¼üÔ¼Êø¡£InnoDBÖжÔÍâ¼üÔ¼Êø¶¨ÒåµÄÓï·¨¿´ÆðÀ´ÈçÏ£º
[CONSTRAINT symbol] FOREIGN KEY [id] (index_col_name, ...)
REFERENCES tbl_name (index_col_name, ...)
[ON DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION}]
[ON UPDATE {RESTRICT | CASCADE | SET NULL | NO ACTION}]
Íâ¼ü¶¨Òå·þ´ÓÏÂÁÐÇé¿ö£º
· ËùÓÐtables±ØÐëÊÇInnoDBÐÍ£¬ËüÃDz»ÄÜÊÇÁÙʱ±í¡£
· ÔÚÒýÓñíÖУ¬±ØÐëÓÐÒ»¸öË÷Òý£¬Íâ¼üÁÐÒÔͬÑùµÄ˳Ðò±»ÁÐÔÚÆäÖÐ×÷ΪµÚÒ»ÁС£ÕâÑùÒ»¸öË÷ÒýÈç¹û²»´æÔÚ£¬Ëü±ØÐëÔÚÒýÓñíÀï±»×Ô¶¯´´½¨¡£
· ÔÚÒýÓñíÖУ¬±ØÐëÓÐÒ»¸öË÷Òý£¬±»ÒýÓõÄÁÐÒÔͬÑùµÄ˳Ðò±»ÁÐÔÚÆäÖÐ×÷ΪµÚÒ»ÁС£
· ²»Ö§³Ö¶ÔÍâ¼üÁеÄË÷Òýǰ׺¡£ÕâÑùµÄºó¹ûÖ®Ò»ÊÇBLOBºÍTEXTÁв»±»°üÀ¨ÔÚÒ»¸öÍâ¼üÖУ¬ÕâÊÇÒòΪ¶ÔÕâЩÁеÄË÷Òý±ØÐë×ÜÊÇ°üº¬Ò»¸öǰ׺³¤¶È¡£
· Èç¹ûCONSTRAINTsymbol±»¸ø³ö£¬ËüÔÚÊý¾Ý¿âÀï±ØÐëÊÇΨһµÄ¡£Èç¹ûËüûÓб»¸ø³ö£¬InnoDB×Ô¶¯´´½¨Õâ¸öÃû×Ö¡£
InnoDB¾Ü¾øÈκÎÊÔ×ÅÔÚ×Ó±í´´½¨Ò»¸öÍâ¼üÖµ¶ø²»Æ¥ÅäÔÚ¸¸±íÖеĺòÑ¡¼üÖµµÄINSERT»òUPDATE²Ù×÷¡£Ò»¸ö¸¸±íÓÐһЩƥÅäµÄÐеÄ×Ó±í£¬InnoDB¶ÔÈκÎÊÔͼ¸üлòɾ³ý¸Ã¸¸±íÖкòÑ¡¼üÖµµÄUPDATE»òDELETE²Ù×÷ÓÐËù¶¯×÷£¬Õâ¸ö¶¯×÷È¡¾öÓÚÓÃFOREIGN KEY×Ó¾äµÄON UPDATEºÍON DETETE×Ó¾äÖ¸¶¨µÄreferential action¡£µ±Óû§ÊÔͼ´ÓÒ»¸ö¸¸±íɾ³ý»ò¸üÐÂÒ»ÐÐ֮ʱ£¬ÇÒÔÚ×Ó±íÖÐÓÐÒ»¸ö»ò¶à¸öÆ¥ÅäµÄÐУ¬InnoDB¸ù¾ÝÒª²ÉÈ¡µÄ¶¯×÷ÓÐÎå¸öÑ¡Ôñ£º
· CASCADE: ´Ó¸¸±íɾ³ý»ò¸üÐÂÇÒ×Ô¶¯É¾³ý»ò¸üÐÂ×Ó±íÖÐÆ¥ÅäµÄÐС£ON DELETE CASCADEºÍON UPDATE CASCADE¶¼¿ÉÓá£ÔÚÁ½¸ö±íÖ®¼ä£¬Äã²»Ó¦¶¨ÒåÈô¸ÉÔÚ¸¸±í»ò×Ó±íÖеÄͬһÁвÉÈ¡¶¯×÷µÄON UPDATE CASCADE×Ӿ䡣
· SET NULL: ´Ó¸¸±íɾ³ý»ò¸üÐÂÐУ¬²¢ÉèÖÃ×Ó±íÖеÄÍâ¼üÁÐΪNULL¡£Èç¹ûÍâ¼üÁÐûÓÐÖ¸¶¨NOT NULLÏÞ¶¨´Ê£¬Õâ¾ÍÊÇΨһºÏ·¨µÄ¡£ON DELETE SET NULLºÍON UPDATE SET NULL×Ӿ䱻֧³Ö¡£
·  
Ïà¹ØÎĵµ£º
mysqlÊÇÒ»¸öÓÅÐãµÄ¿ªÔ´Êý¾Ý¿â£¬ËüÏÖÔÚµÄÓ¦Ó÷dz£µÄ¹ã·º£¬Òò´ËºÜÓбØÒª¼òµ¥µÄ½éÉÜÒ»ÏÂÓÃpython²Ù×÷mysqlÊý¾Ý¿âµÄ·½·¨¡£python²Ù×÷Êý¾Ý¿âÐèÒª°²×°Ò»¸öµÚÈý·½µÄÄ£¿é£¬ÔÚhttp://mysql-python.sourceforge.net/
ÓÐÏÂÔغÍÎĵµ¡£
ÓÉÓÚpythonµÄÊý¾Ý¿âÄ£¿éÓÐרÃŵÄÊý¾Ý¿âÄ£¿éµÄ¹æ·¶£¬ËùÒÔ£¬Æäʵ²»¹ÜʹÓÃÄÄÖÖÊý¾ ......
µ¼³öÊÇ,ûÓÐÖ¸¶¨±àÂë
·½·¨Ò» phpmyadmin´¦Àí·½Ê½
¼ì²éphp-mbstringÊÇ·ñÓпÉ×°,ûÓа²×°ÉÏ yum -y install php-mbstring
´ò¿ªphpmyadmin Öе¼³ö,ÔÙ´Óphpmyadmin µ¼ÈëÊÇÑ¡È¡¶þÖƽø(binary)
Èç¹û»¹²»ÐÐ,ÔÚmy.cnf mysqldÖмÓÈë default-character=ÄãµÄ±àÂë, ÖØÆômysql ÔÙÊÔ ......
MySQL5.X¶¼ÒѾ·¢²¼ºÃ¾ÃÁË£¬µ«ÊÇ»¹ÓкܶàÈËÈÏΪMySQLÊDz»Ö§³ÖÊÂÎñ´¦ÀíµÄ£¬Õâ²»µÃ²»¹ÖËûÃÇÊǹª¹ÑÎŵģ¬Æäʵ£¬Ö»ÒªÄãµÄMySQL°æ±¾
Ö§³ÖBDB»òInnoDB±íÀàÐÍ£¬ÄÇôÄãµÄMySQL¾Í¾ßÓÐÊÂÎñ´¦ÀíµÄÄÜÁ¦¡£ÕâÀïÃ棬ÓÖÒÔInnoDB±íÀàÐÍÓõÄ×î¶à£¬ËäÈ»ºóÀ´·¢ÉúÁËÖîÈçOracleÊÕ
¹ºInnoDBµÈÁîMySQL²»Ë¬µÄÊÂÇ飬µ«ÄÇЩÉÌÒµÉϵĶ·ÕùÓë¼¼ÊõÎ޹أ ......
mysql_affected_rows() ·µ»Ø±»×îеÄUPDATE, DELETE»òINSERT²éѯӰÏìµÄÐÐÊý¡£
mysql_close() ¹Ø±ÕÒ»¸ö·þÎñÆ÷Á¬½Ó¡£
mysql_connect() Á¬½ÓÒ»¸öMySQL·þÎñÆ÷¡£¸Ãº¯Êý²»ÍƼö£»Ê¹ÓÃmysql_real_connect()´úÌæ¡£
mysql_change_user() ¸Ä±äÔÚÒ»¸ö´ò¿ªµÄÁ¬½ÓÉϵÄÓû§ºÍÊý¾Ý¿â¡£
mysql_create_db() ´´½¨Ò ......
¿´MySQL²Î¿¼ÊÖ²á ·¢ÏÖCREATE TABLE ʱÓжàÖÖÊý¾Ý¿â´æ´¢ÒýÇ棺
TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM }
ÍøÉϲéÁËϾÝ˵MyISAM¡¢InnoDBÁ½ÖÖÒýÇæ³£ÓÃ
´óÖÁÇø±ðÈçÏÂ[²»ÖªÊÇ·ñ׼ȷ]£º
¸ß¼¶´¦Àí:
MyISAMÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDBÀàÐÍÖ§³Ö¡£
Ö´ÐÐËÙ¶È:
MyISAMÀàÐ͵ıíÇ¿µ÷µÄÊÇÐ ......