MySqlÃâ°²×°°æµÄÏà¹ØÅäÖÃ
1)¡¢È¥sunµÄ¹ÙÍøÏÂÔØÒ»¸ömysqlµÄѹËõ°ü£¬ÎÒÏÂÔØµÄÊÇmysql-noinstall-5.5.0-m2-win32.zip¡£
2)¡¢°ÑÉÏÃæÏÂÔØµÄѹËõ°ü½âѹµ½£ºD:\Program Files\mysqlÏÂÃæ¡£
3)¡¢ÔÚ D:\Program Files\mysql\ ÖÐÕÒ my-large.ini °ÑËü¸´ÖÆ³É my.ini¡£
4)¡¢ÔÚ my.ini ÖÐÕÒ [mysqld] £¬Ìí¼ÓÒÔÏÂÓï¾ä£º
[mysqld]
basedir="D:\Program Files\mysql\"
datadir="D:\Program Files\mysql\data\"
#ÉèÖÃMySQLÖÐÎÄ×Ö·û¼¯(MySQLÕý³£ÏÔʾÖÐÎÄ)
#ÅäÖ÷þÎñÆ÷¶Ë£¬ÐÞ¸Ämy.iniÎļþ£¬Ê¹ÓÃÖÐÎÄ×Ö·û¼¯´æ´¢¼Ç¼£¬Í¬Ê±ÓÃÖÐÎÄÅÅÐò±È½Ï·½Ê½¡£
default-character-set=GBK
default-storage-engine=innodb
default-collation=gbk_chinese_ci
#skip-networking #// Õâ¾ä»áºöÂÔÍøÂçµÇ½
#bind-address=192.168.0.72 #// Èç¹û¼ÓÉÏÕâ¾ä localhost ¾ÍÓò»ÁË Ö»Òª¸Ä user ±íµÄ 127.0.0.1 Ϊ % ÖØÆô·þÎñ ¾Í¿ÉÒÔÔ¶³ÌµÇ½
5)¡¢#Èç¹ûÒªÔÚÖÐÎÄ»·¾³µÄ·þÎñÆ÷¶ËʹÓÃmysqlÃüÁîÐУ¬¸Ä±ämy.iniÎļþÖÐmysqlµÄĬÈÏ×Ö·û¼¯¡£
[mysql]
# set character set
default-character-set=gbk
6)¡¢ÔÚ¿Í»§¶Ë³ÌÐòÖУ¬ÉèÖÃÖÐÎÄ×Ö·û¼¯¡£ÒÔDelphi + ADO + MyODBCΪÀý£º
procedure InitConn;
var
nRows: Integer;
begin
 
Ïà¹ØÎĵµ£º
1. MySQLÊÇÒ»¸öСÐ͹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ
2. MySQLµÄÊý¾ÝÀàÐÍ£º
ÕûÊýÐÍ£ºTINYINT£¬SMALLINT£¬INT£¬BIGINT
СÊýÐÍ£ºFLOAT£¬DOUBLE£¬DECIMAL(M,D)
×Ö·ûÐÍ£ºCHAR£¬VARCHAR
ÈÕÆÚÐÍ£ºDATETIME £¬DATE£¬TIMESTAMP
±¸×¢ÐÍ£ºTINYTEXT £¬TEXT £¬LONGTEXT
£¨°´php100µÄ½Ì³ÌÀï·ÖµÄ£©
3.MySQLµÄ»ù±¾Óï¾ä
´´½¨Êý¾Ý¿â C ......
mysqlµÄ´æ´¢ÒýÇæÓм¸ÖÖ£¬µ«ÊÇ´Ó5.0¿ªÊ±´ó²¿·ÖÊÇĬÈϲÉÓà innodb´æ´¢ÒýÇæ¡£innodb´æ´¢ÒýÇæÖ§³Ö ÊÂÎñ£¬Íâ¼ü£¬ÐÐÊý¾ÝËø¶¨£¨µ±È»ÊÇÏà¶ÔmyisamµÄ±íËø¶¨£©¡£magento°²×°µÄʱºòÓмì²é mysqlÊÇ·ñÖ§³Öinnodb´æ´¢ÒýÇæ£¬Èç¹û²»Ö§³ÖÔò²»ÄܼÌÐø°²×°¶øÌáʾÈçÏ´íÎ󣬾¡¹Üinnodb´æ´¢²¢Ã»Óб»ÁÐΪ°²×°magentoµÄǰÌáÌõ¼þÖ®Ò»¡£
Database&nbs ......
InnoDB ¸ø MySQL ÌṩÁ˾ßÓÐÊÂÎñ(commit)¡¢»Ø¹ö(rollback)ºÍ±ÀÀ£ÐÞ¸´ÄÜÁ¦(crash recovery capabilities)¡¢¶à°æ±¾²¢·¢¿ØÖÆ(multi-versioned concurrency control)µÄÊÂÎñ°²È«(transaction-safe (ACID compliant))ÐÍ±í¡£InnoDB ÌṩÁËÐм¶Ëø(locking on row level)£¬ÌṩÓë Oracle ÀàËÆµÄ²»¼ÓËø¶ÁÈ¡(non-locking read in SELEC ......
1.°²×°MySQL£¨ÂÔ£©
2.Æô¶¯¶à¸öMySQL·þÎñÆ÷
ҪʵÏÖÔÚµ¥»úÉÏÆô¶¯¶à¸öMySQL·þÎñÆ÷£¬ÓÐÁ½ÖÖ·½·¨£¬Ò»ÖÖÊÇÖ±½ÓʹÓÃmysqld_safeÀ´ÔËÐжà¸ö·þÎñÆ÷
µ±È»ÕâÑù·Ö±ð±à¼ÅäÖÃÎļþ£¬¶øÇҹرշþÎñÆ÷µÄʱºòÒ²Òª¶ÁÈ¡ÅäÖÃÎļþ£¬ËùÒԱȽÏÂé·³£¬ÁíÒ»ÖÖ·½·¨ÊÇʹÓÃ
MySQLÌṩµ½¹¤¾ßmysqld_multi½Å±¾À´¹ÜÀí¶à¸ö·þÎñÆ÷£¬ÏÂÃæ ......
×î½üÏëÔÚ·þÎñÆ÷ÉÏÊÔÊÔMySQL5.1µÄ·ÖÇø£¬ÓÚÊǾÍÏë×Å×°¸öMySQL5.1£¬¾¹ýÍ´¿àµÄÒ»¶Î¾Àúºó£¬ÖÕÓÚÕÒ¸öÏÂÃæ×°¸öºÜºÃµÄ½Ì³Ì£¬ÌûÉÏÀ´±¸Íü¡£
1¡¢MySQLÃâ°²×°°æ/¶þ½øÖưæÈí¼þ£¬²»ÓñàÒ룬ÏÂÔØµØÖ·£º
http://dev.mysql.com/downloads/
Îļþ¸ñʽ£ºMYSQL-VERSION-OS.tar.gz
2¡ ......