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

mysql »ù´¡


Ò» . °²×°ÓëÅäÖÃMYSQL
¶þ . ³£ÓÃmysqlÃüÁîÐÐÃüÁî
1 .mysqlµÄÆô¶¯ÓëÍ£Ö¹
Æô¶¯MYSQL·þÎñ net start mysql
Í£Ö¹MYSQL·þÎñ net stop mysql
2 . netstat –na | findstr 3306 ²é¿´±»¼àÌýµÄ¶Ë¿Ú , findstrÓÃÓÚ²éÕÒºóÃæµÄ¶Ë¿ÚÊÇ·ñ´æÔÚ
3 . ÔÚÃüÁîÐÐÖеǽMYSQL¿ØÖÆÌ¨ , ¼´Ê¹Óà MYSQL COMMEND LINE TOOL
    Óï·¨¸ñʽ mysql –user=root –password=123456 db_name
       »ò mysql –u root –p123456 db_name
4 . ½øÈëMYSQLÃüÁîÐй¤¾ßºó , ʹÓÃstatus; »ò\s ²é¿´ÔËÐл·¾³ÐÅÏ¢
5 . Çл»Á¬½ÓÊý¾Ý¿âµÄÓï·¨ : use new_dbname;
6 . ÏÔʾËùÓÐÊý¾Ý¿â : show databases;
7 . ÏÔʾÊý¾Ý¿âÖеÄËùÓбí : show tables;
8 . ÏÔʾij¸ö±í´´½¨Ê±µÄÈ«²¿ÐÅÏ¢ : show create table table_name;
9 . ²é¿´±íµÄ¾ßÌåÊôÐÔÐÅÏ¢¼°±íÖи÷×ֶεÄÃèÊö
Describe table_name; ËõдÐÎʽ : desc table_name;
Èý ¡£ MySqlÖеÄSQLÓï¾ä
1 . Êý¾Ý¿â´´½¨ : Create database db_name;
Êý¾Ý¿âɾ³ý : Drop database db_name; ɾ³ýʱ¿ÉÏÈÅжÏÊÇ·ñ´æÔÚ£¬Ð´³É : drop database if exits db_name
2 . ½¨±í : ´´½¨Êý¾Ý±íµÄÓï·¨ : create table table_name (×Ö¶Î1 Êý¾ÝÀàÐÍ , ×Ö¶Î2 Êý¾ÝÀàÐÍ);
   Àý : create table mytable (id int , username char(20));
   ɾ±í : drop table table_name; Àý : drop table mytable;
8 . Ìí¼ÓÊý¾Ý : Insert into ±íÃû [(×Ö¶Î1 , ×Ö¶Î2 , ….)] values (Öµ1 , Öµ2 , …..);
Èç¹ûÏò±íÖеÄÿ¸ö×ֶζ¼²åÈëÒ»¸öÖµ,ÄÇÃ´Ç°Ãæ [ ] À¨ºÅÄÚ×Ö¶ÎÃû¿ÉдҲ¿É²»Ð´
   Àý : insert into mytable (id,username) values (1,’zhangsan’);
9 . ²éѯ : ²éѯËùÓÐÊý¾Ý : select * from table_name;
²éѯָ¶¨×ֶεÄÊý¾Ý : select ×Ö¶Î1 , ×Ö¶Î2 from table_name;
Àý : select id,username from mytable where id=1 order by desc;¶à±í²éѯÓï¾ä------------²ÎÕÕµÚ17ÌõʵÀý
10 . ¸üÐÂÖ¸¶¨Êý¾Ý , ¸üÐÂijһ¸ö×ֶεÄÊý¾Ý£¨×¢Ò⣬²»ÊǸüÐÂ×ֶεÄÃû×Ö£©
Update table_name set ×Ö¶ÎÃû=’ÐÂÖµ’ [, ×Ö¶Î2 =’ÐÂÖµ’ , …..][where id=id_num] [order by ×ֶΠ˳Ðò]
Àý : update mytable set username=’lisi’ where id=1;
OrderÓï¾äÊDzéѯµÄ˳Ðò , Èç : order by id desc(»òasc) , ˳ÐòÓÐÁ½ÖÖ : de


Ïà¹ØÎĵµ£º

MySQL´æ´¢ÒýÇæ

MySQLÓжàÖÖ´æ´¢ÒýÇæ£º
MyISAM¡¢InnoDB¡¢MERGE¡¢MEMORY(HEAP)¡¢BDB(BerkeleyDB)¡¢EXAMPLE¡¢FEDERATED¡¢ARCHIVE¡¢CSV¡¢BLACKHOLE¡£
MySQLÖ§³ÖÊý¸ö´æ´¢ÒýÇæ×÷Ϊ¶Ô²»Í¬±íµÄÀàÐ͵Ĵ¦ÀíÆ÷¡£MySQL´æ´¢ÒýÇæ°üÀ¨´¦ÀíÊÂÎñ°²È«±íµÄÒýÇæºÍ´¦Àí·ÇÊÂÎñ°²È«±íµÄÒýÇæ£º
¡ô MyISAM¹ÜÀí·ÇÊÂÎñ±í¡£ËüÌṩ¸ßËÙ´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡ ......

ÈçºÎÑ¡ÔñºÏÊʵÄmysql´æ´¢ÒýÇæ

    ÔÚÑ¡Ôñ´æ´¢ÒýÇæÊ±£¬Ó¦¸ù¾ÝÓ¦ÓÃÌØµãÑ¡ÔñºÏÊʵĴ洢ÒýÇæ£¬¶ÔÓÚ¸´ÔÓµÄÓ¦ÓÃϵͳ¿ÉÒÔ¸ù¾Ýʵ¼ÊÇé¿öÑ¡Ôñ¶àÖÖ´æ´¢ÒýÇæ½øÐÐ×éºÏ¡£
ÏÂÃæÊdz£Óô洢ÒýÇæµÄÊÊÓû·¾³¡£
¡ñMyISAM:ĬÈϵÄMysql²å¼þʽ´æ´¢ÒýÇæ¡£Èç¹ûÓ¦ÓÃÊÇÒÔ¶ÁдºÍ²åÈë²Ù×÷ΪÖ÷£¬Ö»ÓкÜÉÙ¸üкÍɾ³ý²Ù×÷£¬²¢ÇÒ¶ÔÊÂÎñÍêÕûÐÔ£¬²¢·¢ÐÔÒªÇó²»ÊǺܸߣ¬ÄÇÃ´Ñ ......

ÕûºÏfreeBSDÏÂnginx+php+mysql°²×°·½°¸£¨ports°²×°£©

  ×î½üÒ»Ö±ÔÚÑо¿freeBSDÏÂnginx+php+mysqlµÄ°²×°£¬¿´Á˺ܶàÍøÉϵÄ×ÊÁÏÊÕ»ñ²»Ð¡£¬²»¹ý´ó²¿·Ö¶¼ÊDZàÒë°²×°£¬Ïà¶Ô³õѧÕßÀ´Ëµ±È½Ï¸´ÔÓ£¬²»ÈÝÒ×Àí½â£¬ËùÒÔÎÒÕûºÏÁËһЩports°²×°µÄ×ÊÁÏ£¬¶¼ÊǾ­¹ý×Ô¼ºÑéÖ¤ºóµÄ£¬°²×°³É¹¦Ò²±È½ÏÈÝÒ×Àí½â£¬ÏÂÃæÊÇÁ½Öֳɹ¦µÄ°¸Àý£¬ÆäÖÐÓÐÒ»¸öÊÇApache´úÌænginxµÄ°²×°£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
° ......

C#Á¬½ÓMySQLÊý¾Ý¿â·½·¨

C#Á¬½ÓMySQLÊý¾Ý¿â·½·¨
1¡¢ÓÃMySQLDriverCSÁ¬½ÓMySQLÊý¾Ý¿âÏÈÏÂÔØºÍ°²×°MySQLDriverCS£¬µØÖ·£º
http://sourceforge.net/projects/mysqldrivercs
ÔÚ°²×°Îļþ¼ÐÏÂÃæÕÒµ½MySQLDriver.dll£¬È»ºó½«MySQLDriver.dllÌí¼ÓÒýÓõ½ÏîÄ¿ÖÐ
×¢£ºÎÒÏÂÔØµÄÊǰ汾ÊÇ MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe
using System; ......

²é¿´MySQL¼Ç¼ִÐйýµÄSQL

µÚÒ»ÖÖ:²éSlow queryµÄSQLÓï·¨:
 
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2 (³¬¹ý2ÃëµÄSQLÓï·¨¼Ç¼ÆðÀ´,Éè¶ÌÒ»µãÀ´¼Ç¼³ý´íÒ²ÊÇÒ»ÖÖ·½·¨.)
 
µÚ¶þÖÖ:ÉèMySQL ReplicationÓÃbinlog:
 
log_bin = /var/log/mysql/mysql-bin.log (´ËµµÒªÓÃmysqlbinlog½âÀ´¿´£¬
mysqlbinl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ