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

ʹÓà MySQL Workbench ¿ÉÊÓ»¯µÄÉè¼Æ MySQL Êý¾Ý¿â

MySQL Workbench ÊÇ MySQL ×î½üÊͷŵĿÉÊÓÊý¾Ý¿âÉè¼Æ¹¤¾ß¡£Õâ¸ö¹¤¾ßÊÇÉè¼Æ MySQL Êý¾Ý¿âµÄרÓù¤¾ß¡£
ÄãÔÚ MySQL Workbench Öн¨Á¢µÄ±»³Æ֮ΪÎïÀíÊý¾ÝÄ£ÐÍ¡£Ò»¸öÎïÀíÊý¾ÝÄ£ÐÍÊÇÕë¶ÔÒ»¸öÌض¨ RDBMS ²úÆ·µÄÊý¾ÝÄ£ÐÍ£»±¾ÎÄÖеÄÄ£Ðͽ«¾ßÓÐһЩ MySQL µÄ¶ÀÌع淶¡£ÎÒÃÇ¿ÉÒÔʹÓÃËüÉú³É£¨forward-engineer£©Êý¾Ý¿â¶ÔÏ󣬳ýÁË°üº¬±íºÍÁУ¨×ֶΣ©Í⣬Ҳ¿ÉÒÔ°üº¬ÊÓͼ¡£
MySQL Workbench ÓµÓкܶàµÄ¹¦ÄܺÍÌØÐÔ£»ÕâƪÓÉ Djoni Darmawikarta дµÄÎÄÕÂͨ¹ýÒ»¸öʾÀýÕ¹ÏÖÁËÆäÖеÄһЩ¡£ÎÒÃǽ«Õë¶ÔÒ»¸ö¶©µ¥ÏµÍ³½¨Á¢Ò»¸öÎïÀíÊý¾ÝÄ£ÐÍ£¬ÕâÀïµÄ¶©µ¥ÏµÍ³¿ÉÒÔÊÇÏúÊÛµ¥Ò²¿ÉÒÔÊǶ©µ¥£¬²¢ÇÒʹÓà forward-engineer£¨ÕýÏòÒýÇ棩 ½«ÎÒÃǵÄÄ£ÐÍÉú³ÉΪһ¸ö MySQL Êý¾Ý¿â¡£
ÎÒÃǵÄʾÀýÖÐʹÓà MySQL Workbench ´´½¨µÄÎïÀíÄ£ÐÍ¿´ÉÏÈ¥¾ÍÏñÏÂͼÕâÑù£º
 
´´½¨¶©µ¥·½°¸(ORDER Schema)
Ê×ÏÈÈÃÎÒÃÇÀ´´´½¨Ò»¸ö±£´æ¶©µ¥ÎïÀíÄ£Ð͵ķ½°¸¡£µã»÷ + °´Å¥£¨ºìÉ«±ê×¢µÄµØ·½£©
¸ü¸Äеķ½°¸Ä¬ÈÏÃû³ÆΪ¶©µ¥¡£×¢Ò⣬µ±Äã¼üÈë·½°¸Ãûʱ£¬ÔÚ Physical Schemata ÉϵıêÇ©ÃûÒ²»áËæÖ®¸Ä±ä——ÕâÊÇÒ»¸öºÜºÃµÄÌØÐÔ¡£
 
¶©µ¥·½°¸±»Ôö¼Óµ½Ä¿Â¼£¨Catalog£©ÖÐ (ͼÖкìɫȦסµÄ²¿·Ö)¡£
 
ÖØÃüÃû·½°¸ºó¹Ø±Õ schema ´°¿Ú
´´½¨¶©µ¥±í
ÎÒÃÇÏÖÔÚ´´½¨¶©µ¥Ä£ÐÍÖеÄÈý¸ö±í£ºORDER ±íÒÔ¼°ËüµÄÁ½¸ö×Ó±í SALES_ORDER ºÍPURCHASE_ORDER¡£Ê×ÏÈ£¬È·ÐÅÄãÒѾ­Ñ¡ÔñÁË ORDER ·½°¸µÄ±êÇ©£¬ÕâÑù£¬ÎÒÃÇ´´½¨µÄ±í²Å»á°üº¬ÓÚÕâ¸ö·½°¸¡£
 
ÎÒÃǽ«Òª´´½¨µÄ±íÊÇ×÷Ϊ EER ͼ±íչʾµÄ(EER = Enhanced Entity Relationship)¡£ËùÒÔ£¬Ë«»÷ Add Diagram °´Å¥¡£
 
µ¥»÷ Table ͼ±ê£¬È»ºóÒƶ¯Êó±êµ½ EER Diagram ÇøÓò£¬ÔÚÄãÏë·ÅÖõÚÒ»¸ö±íµÄλÖÃÉϵ¥»÷Êó±ê¡£
 
¶ÔÓÚÆäËûÁ½¸ö±í£¬Öظ´ÉÏÃæµÄ²Ù×÷¡£Äã¿ÉÒÔͨ¹ýÍÏקÀ´Òƶ¯±íµÄλÖá£
ÏÂÒ»²½£¬ÎÒÃÇÒª¶Ô table1 ×öһЩ²Ù×÷£¬ÕâЩ²Ù×÷ÊÇͨ¹ý Workbench µÄ±í±à¼­Æ÷Íê³ÉµÄ¡£Òª´ò¿ª±í±à¼­Æ÷£¬Ö»ÐèÓÒ¼üÑ¡Ôñ table1 ²¢Ñ¡Ôñ Edit Table ²Ëµ¥¡£
 
½ÓÏÂÀ´£¬Ôö¼ÓÁУ¨×ֶΣ©¡£Ñ¡Ôñ Columns ±êÇ©¡£½«ÁÐÃû(×Ö¶ÎÃû) idORDER ¸ü¸ÄΪ ORDER_NO.
 
ÔÚÏÂÀ­Áбí¿òÖÐÑ¡ÔñÊý¾ÝÀàÐÍ INT ¡£
ÎÒÃÇÏ£Íû ORDER_NO ÁеÄÖµ¿ÉÒÔ±» MySQL Êý¾Ý¿â×Ô¶¯¿ØÖÆ£¬ËùÒÔ£¬ÎÒÃÇÑ¡¶¨ AI ÁÐ (Auto Increment——×ÔÔöÁ¿).
 
AI ÊÇ MySQL Êý¾Ý¿âµÄÒ»¸öÌØÐÔ¡£
ÄãÒ²¿ÉÒÔÖ¸¶¨±íµÄÆäËûÎïÀíÊôÐÔ£¬ÀýÈçËüµÄ Collation ÊôÐÔ£»µ±È»¿ÉÒÔÖ¸¶¨±íµÄÆäËû¸ß¼¶Ñ¡ÏÀýÈç trigge


Ïà¹ØÎĵµ£º

ÈçºÎ¸ü¸ÄMySQLÊý¾Ý¿â´æ´¢Î»ÖÃ

$sudo nano /etc/apparmor.d/usr.sbin.mysqld
ÔÚgeditÖÐÕÒµ½/var/lib/mysql/ÕâÁ½ÐУ¬×¢Ê͵ôÕâÁ½ÐУ¬ÔÚÕâÁ½ÐÐÇ°·Ö±ðÌí¼ÓÒ»¸ö·ûºÅ“#”¼´¿É×¢ÊÍ£¬ÔÚÕâÁ½ÐÐ֮ǰ»ò
Ö®ºó¼ÓÉÏÏÂÃæÄÚÈÝ£º
/home/mysql/ r,
/home/mysql/** rwk,
±£´æºóÍ˳ö£¬Ö´ÐÐÃüÁ
$sudo /etc/init.d/apparmor reload
·µ»ØReloading AppArmo ......

MySQL²éѯµÄÐÔÄÜÓÅ»¯

²éѯÊÇÊý¾Ý¿â¼¼ÊõÖÐ×î³£ÓõIJÙ×÷¡£²éѯ²Ù×÷µÄ¹ý³Ì±È½Ï¼òµ¥£¬Ê×ÏÈ´Ó¿Í»§¶Ë·¢³ö²éѯµÄSQLÓï¾ä£¬Êý¾Ý¿â·þÎñ¶ËÔÚ½ÓÊÕµ½ÓÉ¿Í»§¶Ë·¢À´µÄSQLÓï¾äºó£¬Ö´ÐÐÕâÌõSQLÓï¾ä£¬È»ºó½«²éѯµ½µÄ½á¹û·µ»Ø¸ø¿Í»§¶Ë¡£ËäÈ»¹ý³ÌºÜ¼òµ¥£¬µ«²»Í¬µÄ²éѯ·½Ê½ºÍÊý¾Ý¿âÉèÖ㬶ԲéѯµÄÐÔÄܽ«»áÓкÜÔÚµÄÓ°Ïì¡£
Òò´Ë£¬±¾ÎľÍÔÚMySQLÖг£ÓõIJéѯÓÅ»¯¼¼Êõ½ø ......

linuxÏÂapache£¬php,mysqlÕûºÏtomcat

1.Ç°ÃæһƪÎÄÕÂÏêϸ½éÉÜÁËÈçºÎÔÚWindowsÏÂÕûºÏapache+mysql+php+tomcat,ºÜ¼òµ¥£¬µ«ÊÇÔÚLinuxϾÍûÕâôÈÝÒ×ÁË£¬ÐèÒªÊÖ¹¤µÄȥдÅäÖÃÎļþ£¬ÍøÉϵÄ×ÊÁÏÓкܶ࣬µ«ÊÇÎÒ¸ù¾ÝËûÃǵÄд·¨£¬Ò»²½Ò»²½µÄÅäÖû¹ÊÇûÄÜsuccess!£¨¿ÉÄÜÊÇÎÒ¸öÈ˵ÄÔ­Òò£¬²»¹ý£¬ÎÞÂÛÔÚGoogle»¹ÊÇbaiduËѵ½µÄÎÄÕ¾ÍÄÇô¼¸Æª£¬Õâ¸öתһÏ£¬ÄǸöתһÏ£¬×îºó¶¼² ......

LinuxÏÂMysql°²×°ºÍÅäÖÃ2

 LinuxÏÂmysqlµÄ°²×°²½Ö裨·Çrpm°²×°£©
1 ÏÂÔØmysql-standard-5.0.27-linux-i686-glibc23.tar.gz °ü
2 ½âѹµ½°²×°Ä¿Â¼£º tar -zxvf /edass/db/mysql-standard-5.0.27-linux-i686-glibc23.tar.gz
3 ½«  mysql-standard-5.0.27-linux-i686-glibc23Á´½Óµ½mysql : ln –s mysql-standard-5.0.27-linux-i686 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ