ʹÓà 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
Ïà¹ØÎĵµ£º
1¡¢½øÈëmysql£¬´´½¨Ò»¸öÐÂÓû§xuys£º
¸ñʽ£ºgrant ȨÏÞ on Êý¾Ý¿âÃû.±íÃû Óû§@µÇ¼Ö÷»ú identified by "Óû§ÃÜÂë";
grant select,update,insert,delete on *.* to xuys@192.168.88.234 identified by "xuys1234";
²é¿´½á¹û£¬Ö´ÐУº
use mysql;
select host,user,p ......
MySql¼òÒױʼÇ
1£º°²×°http://download.mysql.cn/src/2006/0710/5543.html£»
2£º´ò¿ªmysqlµÄCMD
3£º´´½¨Ò»¸öÊý¾Ý¿â¼°±í£º
mysql> CREATE DATABASE bbs;
mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHA ......
write by ¾ÅÌìÑãôá(JTianLing) -- blog.csdn.net/vagrxie ÌÖÂÛÐÂÎÅ×é¼°Îļþ ½ñÌì¿´µ½CSDNÉϵÄÒ»ÔòÐÂÎÅ¡¶Å·ÃËÕýʽ·ñ¾ö¼×¹ÇÎÄÊÕ¹ºSun ¼×¹ÇÎľÝÀíÁ¦Õù¡·ºóÕæÊǸÐ̾°¡¡£¡£¡£¡£ SunÒ²ËãÊÇÊ¢¼«Ò»Ê±µÄ´ó¹«Ë¾ÁË£¬ÒòΪJAVAÓïÑÔ¶øÎÅÃûÓÚÊÀ£¬ºóÀ´¹ÉƱ´úÂ붼¸Ä³ÉJAVAÁË£¬ËäÈ»JAVAʵ¼ÊÉÏûÓÐΪÆä´øÀ´Ì«¶àµÄÀûÈ󣬵«ÊÇSunÒ²ËãÊÇÄܹ»×Ô¼ ......
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 ......
ÕâÀ½éÉÜÒ»ÏÂCentOSÏÂMySQLÊý¾Ý¿â·þÎñÆ÷µÄ¹¹½¨·½·¨¡£
°²×°MySQL¼°Ïà¹Ø×é¼þ
¡¡¡¡Ê×ÏÈ£¬°²×°MySQL¡£
[root@sample ~]#
yum
-y install mysql-server
¡¡ ← °²×°MySQL
Setting up Install Process
Setting up repositories
dag 100% |=========================| 1.1 kB 00:00
update ......