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

mysql Ïà¹ØÍøÖ·...

£©MySql ÖÐÎÄÍø£ºhttp://imysql.cn/onlinedoc
£©MySQL ÖÐÎÄÉçÇø £ºhttp://www.mysql.net.cn/
£©MySql °Ù¶È°Ù¿Æ£ºhttp://baike.baidu.com/view/24816.htm
²Î¿¼×ÊÁÏ£º
MySql°æ±¾¹¹¼Ü¼°Ë÷ÒýÎļþ½éÉÜ 
Linux·þÎñÆ÷ÅäÖ÷½°¸MySQL 
WinodwsÏÂIIS/Apache PHP MySQLµÄ°²×°ÅäÖà
³õѧMySQLÄÄЩÐèÒªÄãÖªµÀ 
À©Õ¹ÔĶÁ£º 1.mysql¼¼Êõ http://www.52lamp.com.cn/mysql/ 2.·þÎñÆ÷°²È«¼¼Êõ:http://www.81yu.cn/forum-4-1.html 3.http://www.oschina.net/p/mysql ¿ªÔ´Öйúmysql ×ÊÁÏ/ÌÖÂÛÇø 4.http://www.cogodo.com/bbs Êé¼®¿â¼¼ÊõÌÖÂÛÇø 5.ÈçºÎÐÞ¸ÄÒÅʧMYSQLµÄROOTÓû§ÃÜÂë http://technic.xkq.com/20090225/27115.html 6.³õѧMySQLÄÄЩÐèÒªÄãÖªµÀ:http://technic.xkq.com/20090608/96474.html


Ïà¹ØÎĵµ£º

MySQL 4.1(»òÒÔÉÏ) ÖÐÎÄÂÒÂëÔ­Òò¼°½â¾ö·½·¨

ºÜ¶àÅóÓѶ¼ÓйýÕâÑùµÄ¾­Àú,½«mysqlÉý¼¶µ½4.1(»òÒÔÉÏ)°æ±¾ºó,¾ÉµÄ³ÌÐò´ÓÊý¾Ý¿â¶Á³öÀ´µÄ¶¼±ä³ÉÂÒÂëÁË.Õâ¸öÎÊÌâÍøÉϺܶàÕâ·½ÃæµÄÌÖÂÛ,ÆäʵÊÖ²áÉÏÒѾ­ÓйØÓÚÕâ·½ÃæµÄÏêϸ˵Ã÷,
ÒÔÏÂÄÚÈÝÕª×ÔmysqlÊÖ²á,
²úÉúÕâ¸öÎÊÌâµÄÔ­ÒòÊÇ:
MySQL 4.1.x¿ªÊ¼Ö§³ÖÒÔÏÂÕâЩÊÂÇé
·         ʹ ......

MySQL Proxy °²×°Óë¶Áд·ÖÀëÌåÑé


Ô­×÷£ºÑîÌÎ(ÉϵÛËû°Ö)
Ò»Ö±ÏëµÈµ½BETA°æ³öÀ´ÔÙÊÔÑéµÄ£¬¿É»¹ÊǾ­²»×¡ÓÕ»ó°¢,ÏÂÎçÖÕÓÚÓÐʱ¼ä²âÊÔÒ»ÏÂÁË¡£
£¨±¾ÎIJο¼µØÖ·£ºhttp://blog.chinaunix.net/u/8111/showart.php?id=451420£©
Ò»¡¢±Ø±¸Èí¼þ£º
1¡¢LUA
   ¿ÉÒÔÈ¥LUAµÄ¹Ù·½ÏÂÔØ£ºwww.lua.org
2¡¢MySQL Proxy
   ÕâÀïÓкöà¶þ½øÖÆ°æ±¾¡£
& ......

linuxÏÂmysqlµÄʹÓÃ


Æô¶¯mysql:  /etc/rc.d/init.d/mysql start
ÐÞ¸ÄÃÜÂë: ¸ñʽ£ºmysqladmin -uÓû§Ãû -p¾ÉÃÜÂë password ÐÂÃÜÂë
ʹÓÃÃÜÂëµÇ¼:  mysql -u root -p
ÏÔʾÊý¾Ý¿â:  show databases;
Ñ¡ÔñÊý¾Ý¿â:  use Êý¾Ý¿âÃû;
ÏÔʾ±í:  show tables;
ÏÔʾ±í½á¹¹:  descibe ±íÃû;
Ô¶³ÌµÇ¼mysqlÐèÒª¿ªÆôÈ ......

¸ü¸ÄMySqlÊý¾Ý¿âµÄĬÈϱàÂë¸ñʽ

Ò»¡¢ÉèÖÃÊý¾Ý¿â±àÂë
°²×°mysqlʱ¿ÉÑ¡Ôñ±àÂ룬Èç¹ûÒѾ­°²×°¹ý£¬¿ÉÒÔ¸ü¸ÄÎļþmy.ini(´ËÎļþÔÚmysqlµÄ°²×°Ä¿Â¼ÏÂ)ÖеÄÅäÖÆÒԴﵽĿµÄ£»´ò¿ªÎļþÕÒµ½Á½´¦£º
[client]
port=3306
[mysql]
default-character-set=gb2312
# The default character set that will be used when a new
schema or table is
# created and
n ......

MySQLѧϰ

»ù±¾µÄMySQLÓï¾äºÜ¼òµ¥£¬ÕâÀïÖ÷Ҫ̸̸һЩÈÝÒ×ÒÅÍüµÄ¡£
1.ÈçºÎÉèÖÃ×ֶεÝÔö
create table tb_User(Id int auto_increment
not null primary key,UserName varchar(50),Password varchar(20));
2.²é¿´±í½á¹¹
desc tb_User;
3.ÈçºÎÐ޸ıí½á
ÖØÃüÃû±í£ºalter table tb_User rename
tb_UserInfo;
Ìí¼ÓÒ»ÁУºalter ta ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ