MySql °²×°½Ì³Ì ʵ¼
×÷ÕߣºÐûÕ×Åô
--------------------------------------------------------------------------------------------------------------------------------------------
½ñÌìÔÚ±¾±¾Éϰ²×°MYSQL£¬ÔÚ°²×°¹ý³Ì³öÏÖÁËÒ»Ð©Ææ¹ÖµÄÎÊÌ⣬Òò´ËÔÚÕâÀï·ÖÏíÕû¸ö°²×°Á÷³ÌÓë´íÎó½â¾ö·½·¨¡£
MySQL°æ±¾£º5.1.40-community
1¡¢ÏÂÔØ°²×°°ü²¢°²×°
Èç¹ûÊÇÆÕͨÓû§£¬ÇëÔÚ°²×°Ê±£¬Ñ¡Ôñ“Typical”£¬¼´µäÐÍÀàÐÍ£¬MYSQL½«°²×°µ½CÅÌÏÂProgram FilesϵÄMy SQLÎļþ¼ÐÄÚ¡£
2¡¢°²×°Íê±Ïºó£¬½øÐеÄÉèÖÃ
1£©½øÈëCMD
2£©CDµ½c:\program files\MySQL\MySQL Server 5.1\binÏÂ
3£©ÊäÈë“mysqld -install”,¼´MYSQL³ÉΪϵͳ·þÎñ£¬×÷Ϊ×Ô¶¯ÔËÐеķþÎñ¡£
4£©½øÈëMySQL Server Instance configure WizardÖУ¬½øÐÐÉèÖã¬Ñ¡Ôñ"Standard"ģʽ½øÐÐÉèÖ㬳ý·ÇÄãÊÇר¼Ò£¬¾ÍÑ¡"Detail"ģʽ¡£
5£©ÏÂÒ»²½ºó£¬»áÓÐÒ»¸öÒ³ÃæÈÃÄãÊäÈëÃÜÂ룬ÔʼµÄrootµÄÃÜÂëΪ¿Õ£¬ÕâÀï¼Ù¶¨ÄãÐèÒªÉèÖõÄÃÜÂëΪ"sa"
6£©ÏÂÒ»²½ºó£¬µã»÷execute£¬Èç¹û´ËʱÌáʾ“error 1045”£¬ËµÃ÷ÔʼµÄrootÃÜÂ벻Ϊ¿Õ
7£©finish
3¡¢½øÈëMySQL
1£©½øÈëCMD
2£©CDµ½ÉÏÒ»²½µÄĿ¼ÖÐ
3£©ÊäÈë“mysql -uroot -p”»áÌáʾÊäÃÜÂ룬ÃÜÂë¼´Äã¸Õ²ÅÉèÖõģ¬´Ë´¦Îª“sa”¡£
4£©½øÈ¥À²£¡
µÇ¼Êý¾Ý¿âʱ£¬ÓÐЩÈË¿ÉÄÜ»áÖ±½ÓÊäÈë mysql -p »ò mysql -root -p ÕâÑùµÄ»°¶¼²»Äܵǽµ½rootÓû§Ï£¬Òò´ËÄãÊäÈëµÄÃÜÂë¿Ï¶¨²»¶Ô£¬ËùÒÔ»áÌáʾ1045´íÎó¡£
»¶Òû·ÃÎÊ,²é¿´¸ü¶àÓйØJAVA·½ÃæµÄ¼¼ÊõÎÄÕ http://blog.csdn.net/robinlovesnow
Ïà¹ØÎĵµ£º
±¾ÊµÑéÍê³ÉÈçϽá¹û£º
0. testÊý¾Ý¿â,userinfo Óû§ÐÅÏ¢±í ºÍ userinfolog Óû§ÐÅÏ¢ÈÕÖ¾±í
1. ½¨Á¢Ò»¸öuserinfo±íÐÂÔö¼Ç¼ʱµÄ´¥·¢Æ÷,½«ÐÂÔöÈÕÖ¾¼ÓÈëµ½userinfolog
2. ½¨Á¢Ò»¸öÏòuserinfo±íÐÂÔö¼Ç¼µÄ´æ´¢¹ý³Ì
3. ¸ù¾ ......
×î½ü¹«Ë¾×¼±¸Ê¹ÓÃÏîÄ¿¹ÜÀíµÄÍøÕ¾DotProject£¬¹«Ë¾ËäÈ»²»´ó£¬µ«ÊÇÇ£Éæµ½µÄÒµÎñÒ²ÊǺܸ´Ôӵģ¬ËùÒÔÐèÒª¶¨Ê±È¥±£´æÊý¾Ý¿âµÄÐÅÏ¢ÒÔ·ÀÖ¹Êý¾Ý¿â±ÀÀ£»òÕ߯äËûµÄÔÒòÔì³ÉµÄÊý¾ÝËðʧ£¬ÕâÑù¾ÍÐèÒª½øÐÐÊý¾Ý¿âµÄ±¸·Ý¡£
DotProjectʹÓõÄÊÇMysqlÊý¾Ý¿â£¬±¸·ÝMysqlÊý¾Ý¿âµÄÒ»¸ö±È½ÏºÃµÄ·½·¨¾ÍÊÇ ......
±àÒëǰÐèÒª°²×°µÄ¿â£º
g++
libmysqlclient15-dev
libglade2-dev
libglib2.0-dev
libgtkmm-2.4-dev
libpcre3-dev
libxml2-dev
È»ºóÖ´ÐÐ
cd mysql-gui-common
./configure
make
sudo make install
cd ../mysql-administrator
./configure
make
sudo make install
°²×°MySQL Administrator
°²×°Íê³Éºómysql- ......
ÔÚPHP´úÂë¶ÎÇ°ÃæÔËÐÐÒÔÏÂÓï¾ä
@mysql_connect($host,$user,$password);
@mysql_query('SET NAMES "UTF8"');
@mysql_query('SET COLLATION_CONNECTION=utf8_general_ci');
»òÕßÔÚMYSQLÖÐÔËÐÐÒ»´Î:
SET NAMES "UTF8";
SET COLLATION_CONNECTION=utf8_general_ci
Ò»ÀÍÓÀÒÝ
......
ÔÚ
oracle
ÖУ¬
sequence
Ìṩ¶à±í¶à×ֶοɹ²ÓÃÒ»¸ö²»Öظ´Öµ¡£
Mysql
ÖдæÔÚ×ÔÔöÁУ¬»ù±¾¿ÉÒÔÂú×ã
PK
µÄÒªÇó¡£µ«×ÔÔöÁдæÔÚÏÞÖÆ£º
a.
Ö»ÄÜÓÃÓÚ±íÖеÄÒ»¸ö×ֶΣ¬Ò»ÕŲ»ÄÜͬʱ´æÔÚÁ½¸öÒÔÉϵÄ×ÔÔöÁÐ
;
b.
×ÔÔöÁбØÐë±»¶¨ÒåΪ
key
£¨
PK
»ò
FK
£©
;
c.
×ÔÔöÁв»Äܱ»¶à¸ö±í¹²ÓÃ
;
d.
µ±
insert
Óï¾ä² ......