Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 µÄȨÏÞÖ»ÔÊÐí±¾µØµÇ½£¬Ô¶³ÌµÇ½²»¿ÉÒÔ£¬ÔÚ±¾»úд±¾


Ïà¹ØÎĵµ£º

mysqlÃÜÂë

MYSQL ÐÞ¸ÄrootÃÜÂëÃüÁî
cmdÏÂÇл»µ½ mysql °²×°Ä¿Â¼
Àý
d:/mysql/bin
Ç°Ì᣺mysqlÓû§rootÃÜÂëΪ¿Õ.
ÊäÈë mysql -u root mysql
mysql> ״̬ÏÂÊäÈë update user set password=password('ÐÂÃÜÂë') where user='root';
»ØÏÔ
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
......

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

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

MySQLµ¼³öµ¼ÈëÃüÁîµÄÓÃÀý

1.µ¼³öÕû¸öÊý¾Ý¿â
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc > wcnc.sql
2.µ¼³öÒ»¸ö±í
¡¡¡¡mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû ±íÃû> µ¼³öµÄÎļþÃû
¡¡¡¡mysqldump -u wcnc -p smgp_apps_wcnc users> wcnc_users.sql
3.µ¼³öÒ»¸öÊý¾Ý¿â½á¹¹
¡¡¡¡mysql ......

mysql´æ´¢¹ý³ÌµÄ¼òµ¥Ó¦ÓÃ

¶Ômysql´æ´¢¹ý³ÌµÄ¼òµ¥Ó¦ÓÃ
Ïò±íÖвåÈëÄ£ÄâÊý¾Ý£¬¼ì²é·ÖҳЧ¹ûÊÇ·ñ³ö´í¡£
create procedure dowhile()
begin
   declare cnt INT default 0;
   while cnt<100 do
 INSERT INTO `test`.`news` (`F_ID` ,`F_TITLE` ,`F_CLASSID` ,`F_ISUP` ,`F_CONTENT` ,`F_SOURCE` ,`F_DATETIME` ,`F_RE ......

mysql UDF+triggerµÄÉñÆæħÁ¦

  1.ʲôÊÇUDF? UDF(user-defined function)ÊÇmysqlΪÓû§ÌṩµÄ×Ô¶¨Ò庯ÊýµÄÀ©Õ¹½Ó¿Ú¡£Ëü±¾ÖÊÉϺÍmysqlÌṩµÄmax¡¢minºÍcountµÈº¯ÊýÀàËÆ¡£ 2.UDF¿ÉÒÔ×öʲô? UDFÊÇ×Ô¶¨Ò庯Êý£¬ËùÒÔËüÄÜ×öʲôÍêÈ«È¡¾öÓÚÄãµÄʵÏÖ¡£UDF¿ÉÒÔÔÚÆÕͨµÄsql¡¢triggerÒÔ¼°store procedure±»µ÷ÓᣠÈç¹û×Ô¶¨ÒåÒ»¸ötcp_send(ip,port,msg)µ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ