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

Mysql°²×°°æÓëÃâ°²×°°æµÄÇл»Ê¹ÓÃ

Èç¹ûͬÒâϵͳÖÐͬʱ´æÔÚinstall mysqlºÍno—install mysql£¬ÄÇôÔõÑù½øÐÐÁ½¸ö°æ±¾µÄÇл»Ê¹ÓÃÄØ£¿ÓÖ»áÓöµ½Ê²Ã´ÑùµÄÎÊÌâÄØ£¿
Ê×ÏÈ£¬install mysqlµÄmysql·þÎñÊÇĬÈÏÆô¶¯µÄ£¬ÔÚÈÎÎñ¹ÜÀíÆ÷½ø³ÌÖпÉÒÔ¿´µ½¼¸ÌõsqlµÄ×ÖÑÛ£¬Èçmysqld.exe,sqlbrowser¡£ÕâÊÇinstall mysqlµÄ·þÎñ¡£ÄÇôͨ¹ý¿ì½Ý·½Ê½»ònavicat¾ÍÄÜÆô¶¯Ê¹ÓÃinstall mysqlÁË¡£
Çл»no-install mysql£º
1¡¢°ÑÎñ¹ÜÀíÆ÷½ø³ÌÖÐmysqlld.exe,sqlbrowseµÈ½ø³Ì¹Øµô¡£
2¡¢ÕÒµ½no-install mysqlµÄ·¾¶½øÈë¸ùĿ¼£¬ÓÐStartMysql.batºÍStopMysql.bat,·Ö±ðÊÇÆô¶¯ºÍ¹Ø±ÕmysqlµÄÅú´¦ÀíÎļþ£¬Ë«»÷StartMysql.bat¡£
3¡¢´ò¿ªdosÔËÐд°¿Ú£¬½øÈëno-install mysqlµÄ·¾¶ÏµÄbinµÄÎļþ¼ÐÔËÐÐmysql -uroot -pÃüÁOkÊäÈëÃÜÂë°É¡£¿ÉÒÔ¿ªÊ¼Ê¹ÓÃno-install mysqlÁË¡£
Çл»»Øinstall mysql
1¡¢ÕÒµ½no-install mysqlµÄ·¾¶½øÈë¸ùĿ¼£¬ÓÐStartMysql.batºÍStopMysql.bat,·Ö±ðÊÇÆô¶¯ºÍ¹Ø±ÕmysqlµÄÅú´¦ÀíÎļþ£¬Ë«»÷StopMysql.bat¡£
2¡¢ÕÒµ½install mysqlµÄ°²×°Â·¾¶½øÈëbinÎļþ¼Ð£¬Ë«»÷mysqld.exe.
3¡¢okÓֻص½ÁËinstall mysql״̬


Ïà¹ØÎĵµ£º

Mysql¼¯ÈºÅäÖÃÎĵµ

¹ÜÀí½Úµã:192.168.50.211 Êý¾Ý½Úµã: 192.168.50.214 Êý¾Ý½Úµã: 192.168.50.215 SQL½Úµã: 192.168.50.212 SQL½Úµã: 192.168.50.213 ²Ù×÷ϵͳ:Red Hat Enterprise Linux AS release 5 ------------------------------------------°²×°Ç°±Ø¶Á---------------------------------------- µ±Ç°ÎĵµµÄ°æ±¾Îªmysql-cluster- ......

Ìí¼Ó/ɾ³ýMySQLÊý¾Ý¿â±íÖеÄ×Ö¶Î

Ìí¼Ó×ֶεĸñʽ
ALTER [ONLINE | OFFLINE] [IGNORE] TABLE tbl_name alter_specification [, alter_specification] ...alter_specification: table_option ... | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name ]
eg.
ALTER TABLE myTbl ADD COLUMN newItem VARCHAR(20) DEFAULT "0"  ......

mysql ×ÔÔöÁеĴ´½¨

1.½¨±íʱ¾Í´´½¨×ÔÔöÁУº
create table test
(
 id int auto_increment primary key,
 name varchar(20) not null,
 password varchar(20) not null
);
insert into test values(null,'aa','aa');
insert into test values(null,'bb','bb');
×¢Ò⣺
      ²åÈëÓï¾äʱ£¬×Ô ......

ÁªºÏMySQL Proxy ºÍMySQL Cluster£¬¹¹½¨¸ßÐÔÄÜÊý¾Ý¿â


ÁªºÏMySQL Proxy ºÍMySQL Cluster£¬¹¹½¨¸ßÐÔÄÜÊý¾Ý¿â
Ô­ÎÄ£ºhttp://blogs.mysql.com/kaj/2007/12/10/combining-mysql-proxy-with-mysql-cluster/
       ²»¾Ãǰ£¬ÎÒºÍStewart Smith, Vinay Joosery, Monty Taylor ÒÔ¼°ÆäËûµÄmysqlʹÓÃÕߣ¨ËûÃDZÈÎÒ¸üÊìϤMySQL Cluster £©Õ¹¿ªÁËÒ»´ÎÌÖÂÛ£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ