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

°²×°¡¢ÉèÖÃÓëÆô¶¯MySqlÂÌÉ«°æµÄ·½·¨

1¡¢½âѹ mysql-noinstall-5.1.30-win32.zip
2¡¢ÔÚ F Å̽¨Á¢Ä¿Â¼ MySql\MySqlServer5.1\
3¡¢°Ñ½âѹµÄÄÚÈݸ´ÖƵ½  F:\MySql\MySqlServer5.1\
4¡¢ÔÚ F:\MySql\MySqlServer5.1\ ÖÐÕÒ my-large.ini °ÑËü¸´ÖÆ³É my.ini
5¡¢ÔÚ my.ini ÖÐÕÒ [mysqld] £¬Ìí¼ÓÒÔÏÂÓï¾ä;
basedir="F:/MySql/MySqlServer5.1/"
datadir="F:/MySql/MySqlServer5.1/data/"
default-character-set=latin1      #utf8
default-storage-engine=innodb
max_allowed_packet =12M 
#skip-networking            #//  Õâ¾ä»áºöÂÔÍøÂçµÇ½
#bind-address=192.168.0.72  #//  Èç¹û¼ÓÉÏÕâ¾ä localhost ¾ÍÓò»ÁË Ö»Òª¸Ä user ±íµÄ 127.0.0.1 Ϊ % ÖØÆô·þÎñ ¾Í¿ÉÒÔÔ¶³ÌµÇ½
6¡¢°²×° MySQL_Administrator_1.2 ÂÌÉ«°æ£º°Ñ mysql-gui-tools-noinstall-5.0-r14-win32.zip ½âѹµ½ F:\MySql\MySQL GUI Tools 5.0
6.5¡¢¿ÉÒÔ³¢ÊÔÊÖ¶¯Æô¶¯ MySql ·þÎñÆ÷£¬²¢Óà MySQL_Administrator_1.2 ºÍ console µÇ½£º
     1¡¢ÊÖ¶¯Æô¶¯·þÎñ£ºcmd --> F:\MySql\MySqlServer5.1\bin\mysqld --console
        »á¿´µ½ InnoDB: The first specified datafile c:\ibdata\ibdata1 did not exist:
            InnoDB: a new database to be created£¡
            InnoDB: Setting file c:\ibdata\ibdata1 size to 209715200
            InnoDB: Database physically writes the file full: wait...  µÈ ºÜ³¤µÄ
        ×îºó¿´µ½ mysqld: ready for connections
                 Version: '5.1.2-alpha'  socket: ''  port: 3306
        ±íʾ MySql ·þÎñÒѾ­Æô¶¯£¬¿ÉÒԵǽÁË£¬Õâʱ£º µÇ½ÃûÊÇ root £¬ÃÜÂëΪ¿Õ£¬IP µØÖ·Ö»ÄÜд localhost »ò 127.0.0.1 £¬ÒòΪÏÖÔÚ
        root µÄȨÏÞÖ»ÔÊÐí±¾µØµÇ½£¬Ô¶³ÌµÇ½²»¿ÉÒÔ£¬ÔÚ±¾»úд±¾


Ïà¹ØÎĵµ£º

Apache + PHP + MySql °²×°


ËùÐèÈí¼þ£¨×¢Òâ°æ±¾£¡£©£º
Apache2.2.3 
PHP5.1.5 
MySQL5.0.24
ÕâÈý¸öÈí¼þ¶¼ÊÇÃâ·ÑµÄ£¬¿É´Ó¹ÙÍøÉÏÏÂÔØ£¬Ä¿Ç°ÎÒËùÓеÄÈí¼þÃûΪ£º
apache_2.2.3-win32-x86-no_ssl.msi 
mysql-5.0.24-win32.zip 
php-5.1.5-Win32.zip
»ùÓÚwindows²Ù×÷ϵͳ£¬ÔÚWindows XPϰ²×°Ê¹Óãº
1¡¢°²×°¹ý³Ì£º  ......

MySQL×Ö·û´®´¦Àíϵͳ

ÒÔÏÂÊÇÍêÕûµÄÀý×Ó¡£
1¡¢Ð½¨±í
#title: ×Ô¶¨Òå×Ö·û
#auther: Ð¡Ç¿(Õ¼²·Ê¦) 
#date: 
2008
-
01
-08
drop
 
table
 
if
 
exists
 Category;
create
 
table
 Category
(
   cateId       &nbs ......

[ת]Mysql Sourceµ¼ÈëÂÒÂëÎÊÌâ

      1¡¢È·¶¨Êý¾Ý¿âĬÈϱàÂ룬±ÈÈç±àÂëΪutf8,½«¶ÁÈë;¾¶±àÂëͬÑùÉèΪutf8£¬ÃüÁîΪ£ºset names utf8;
      2¡¢source d:/20080613.sql µ¼ÈëÊý¾Ý¡£ÑéÖ¤Êý¾Ý¿âÖеÄÊý¾ÝÊÇ·ñ´æÔÚÂÒÂë¡£
      3¡¢Èç¹ûÈÔÈ»´æÔÚÂÒÂëÎÊÌ⣬Õâʱºò¾ÍÒª¿¼ÂǸı䵼ÈëÎļþµÄ±à ......

mySQLÑÓ³Ù

 ÔÚÖ÷Íâ¼ü±í´æÔÚ¹ØÏµµÄʱºòÈç¹û¼ÓÉÏ"lazy=true"µÄ»°£¬Ôò±íÃ÷ÑÓ³Ù£¬¼´Ö»²éѯÖ÷±íÖеÄÄÚÈÝ£¬¶ø²»²éѯÍâ¼ü±íÖеÄÄÚÈÝ¡£
Àý£º
<hibernate-mapping>
    <class name="com.pojo.Sortp" table="sortp" catalog="shjdc">
        <id name="id" type= ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ