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
 
Ïà¹ØÎĵµ£º
MySQLÊÇÒ»¸öÕæÕýµÄ¶àÓû§¡¢¶àÏß³ÌSQLÊý¾Ý¿â·þÎñÆ÷¡£MySQLÊÇÒÔÒ»¸ö¿Í»§»ú/·þÎñÆ÷½á¹¹µÄʵÏÖ£¬ËüÓÉÒ»
¸ö·þÎñÆ÷ÊØ»¤³ÌÐòmysqldºÍºÜ¶à²»Í¬µÄ¿Í»§³ÌÐòºÍ¿â×é³É¡£ÓÉÓÚÆäÔ´ÂëµÄ¿ª·ÅÐÔ¼°Îȶ¨ÐÔ£¬ÇÒÓëÍøÕ¾Á÷Ðбà徎ÓïÑÔPHPµÄÍêÃÀ½áºÏ£¬ÏÖÔںܶàÕ¾µã¶¼ÀûÓÃÆä
µ±×÷ºó¶ËÊý¾Ý¿â£¬Ê¹Æä»ñµÃÁ˹㷺ӦÓᣴ¦ÓÚ°²È«·½ÃæµÄ¿¼ÂÇ£¬ÐèҪΪà ......
SQL Injection with MySQL
±¾ÎÄ×÷Õߣºangel
ÎÄÕÂÐÔÖÊ£ºÔ´´
·¢²¼ÈÕÆÚ£º2004-09-16
±¾ÎÄÒѾ·¢±íÔÚ¡¶ºÚ¿Í·ÀÏß¡·7Ô¿¯£¬×ªÔØÇë×¢Ã÷¡£ÓÉÓÚдÁ˺ܾã¬Ëæ׿¼ÊõµÄ½ø²½£¬±¾ÈËÒ²·¢ÏÖ¸ÃÎÄÀïÓв»ÉÙ´íÎóºÍÂÞàµĵط½¡£Çë¸÷λ¸ßÊÖ¿´Á˲»ÒªÐ¦¡£±¾ÎÄдÓÚ¡¶Advanced SQL Injection with MySQL¡·Ö®Ç°Ò»¸öÔ¡£
ÉùÃ÷
¡¡¡¡±¾ÎĽöÓÃÓÚ½ ......
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 ÀàËƵIJ»¼ÓËø¶ÁÈ¡(non-locking read in SELEC ......
ÔÎÄ£ºhttp://blog.csdn.net/gnuhpc/archive/2010/01/01/5118123.aspx
½ö½öÊÇ¿´Ò»Ð©ÊéÊÇÁãÁãɢɢ¼Çϵģ¬¸ø×Ô¼º±¸Íü¶øÒÑ¡£½¨ÒéÈ¥¿´×¨ÒµÍøÕ¾µÄ±Ê¼Ç¡£
1.Ö÷¼üµÄÖµ±ØÐëÊÇΨһµÄ£¬²¢ÇÒ²»ÄÜΪ¿Õ£¬Õâ¿ÉÒÔÌá¸ßMySQL´Ó¶à¸ö±íÖÐÈ¡µÃÊý¾Ý»òÕßÈ¡µÃÖ¸¶¨¼üÖµ¶ÔÓ¦µÄÐеÄËٶȡ£MySQLͨ¹ýÒ»¸öÌØÊâµÄ³ÆΪIndexË÷ÒýµÄÊý¾Ý½á¹¹×öµ½ÕâÒ»µã£¬In ......