°²×°¡¢ÉèÖÃÓëÆô¶¯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 ÐÞ¸Ä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
......
ÒÔÏÂÊÇÍêÕûµÄÀý×Ó¡£
1¡¢Ð½¨±í
#title: ×Ô¶¨Òå×Ö·û
#auther: Сǿ(Õ¼²·Ê¦)
#date:
2008
-
01
-08
drop
table
if
exists
Category;
create
table
Category
(
cateId &nbs ......
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´æ´¢¹ý³ÌµÄ¼òµ¥Ó¦ÓÃ
Ïò±íÖвåÈëÄ£ÄâÊý¾Ý£¬¼ì²é·ÖҳЧ¹ûÊÇ·ñ³ö´í¡£
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 ......
1.ʲôÊÇUDF? UDF(user-defined function)ÊÇmysqlΪÓû§ÌṩµÄ×Ô¶¨Ò庯ÊýµÄÀ©Õ¹½Ó¿Ú¡£Ëü±¾ÖÊÉϺÍmysqlÌṩµÄmax¡¢minºÍcountµÈº¯ÊýÀàËÆ¡£ 2.UDF¿ÉÒÔ×öʲô? UDFÊÇ×Ô¶¨Ò庯Êý£¬ËùÒÔËüÄÜ×öʲôÍêÈ«È¡¾öÓÚÄãµÄʵÏÖ¡£UDF¿ÉÒÔÔÚÆÕͨµÄsql¡¢triggerÒÔ¼°store procedure±»µ÷ÓᣠÈç¹û×Ô¶¨ÒåÒ»¸ötcp_send(ip,port,msg)µ ......