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

mysql ѧϰÊÖ¼Ç(1)

1.ÉèÖñäÁ¿
    set @x = 2;
    »ò:
    select @x := max(fields) as max from table;
2.Éú³Éhtml»òxml
    mysql -H -uroot -p databaseName        Éú³ÉhtmlÎļþ
    mysql -x -uroot -p databaseName        Éú³ÉxmlÎļþ
3.mysql»á»°ÖеļǼ¹¦ÄÜ
    msyql -ee=/usr/log -uroot -p
    ÔÚ mysql> ÖпÉÒÔÓà \t À´È¡Ïû£¬Óà \T À´ÉèÖô˹¦ÄÜ
4.show status like '%connections%' À´²é¿´×î´óÁ¬½ÓÊý
  show status like '%Uptime%' ²é¿´½ø³Ì
  show processlist ²é¿´µ±Ç°Ö´ÐеÄsqlÓï¾ä
  sqlµÄÂý²éѯÈÕÖ¾µÄ¿ÉÒÔ¿´³öÀ´ÊÇÄÄÒ»¸öÒ³Ãæ³öÁËÎÊÌâ
5.show character set    ²é¿´×Ö·ûÉèÖÃ
  show colllation like '%utf8%'    ²é¿´collation(УÑé)£¬ci,cs,bin·Ö±ð´ú±íºöÂÔ´óСд£¬²»ºöÂÔ´óСд£¬¶þ½øÖÆ
6.create table t1 select * from t2    ÒÔt2Ϊ±ê×¼´´½¨Ð±ít1£¬²¢½«ËùÓÐÊý¾Ý×ªÒÆ¹ýÈ¥
7.alter table t1 engine = myisam     ¸ü¸Ä engine Ϊ myisam


Ïà¹ØÎĵµ£º

MySQLÊý¾Ý¿â±àÂëÎÊÌâ

      ÔÚ³ÌÐò¿ª·¢ÖУ¬ÓÐʱ»á±»×Ö·ûÂÒÂëµÄÎÊÌâËùÀ§ÈÅ¡£¶Ô´Ë£¬±ØÐëÀí½â MySQL µÄ×Ö·û¼¯±àÂëÉèÖõÄÔ­Àí£ºÔÚMySQLÖУ¬Ä¬ÈÏʹÓõÄÊÇlartin1£¬Ò²¾ÍÊÇISO8859-1×Ö·û¼¯±àÂë¡£ÕâÊÇÒ»ÖÖ8λµÄ±àÂ룬ÊÊÓÃÓÚËùÓÐÎ÷Å·×Ö·û¡£¶ø¶ÔÓÚºº×ÖµÈÊDz»ºÏÊʵġ£×îºÃ¡¢×îͨÓõıàÂë¸ñʽÊÇutf-8£¬UTF-8£¨8 λԪ Universal Cha ......

MySqlÖеÄTimestampÀàÐÍ×ֶεÄʹÓÃ

TIMESTAMPÁÐÀàÐÍÌṩһÖÖÀàÐÍ£¬Äã¿ÉÒÔʹÓÃËü×Ô¶¯µØÓõ±Ç°µÄÈÕÆÚºÍʱ¼ä±ê¼ÇINSERT»òUPDATEµÄ²Ù×÷¡£Èç¹ûÄãÓжà¸öTIMESTAMPÁУ¬Ö»ÓеÚÒ»¸ö×Ô¶¯¸üС£
  ×Ô¶¯¸üеÚÒ»¸öTIMESTAMPÁÐÔÚÏÂÁÐÈκÎÌõ¼þÏ·¢Éú£º
ÁÐûÓÐÃ÷È·µØÔÚÒ»¸öINSERT»òLOAD   DATA   INFILEÓï¾äÖÐÖ¸¶¨¡£     
ÁÐûÓÐÃ÷È·µØÔÚÒ ......

MySQL ´æ´¢ÒýÇæInnoDB/MYISAM

Ò»¡¢MYSQL´æ´¢ÒýÇæ´óÈ«£º
·MyISAM£ºÄ¬ÈϵÄMySQL²å¼þʽ´æ´¢ÒýÇæ£¬ËüÊÇÔÚWeb¡¢Êý¾Ý²Ö´¢ºÍÆäËûÓ¦Óû·¾³ÏÂ×ʹÓõĴ洢ÒýÇæÖ®Ò»¡£×¢Ò⣬ͨ¹ý¸ü¸ÄSTORAGE_ENGINEÅäÖñäÁ¿£¬Äܹ»·½±ãµØ¸ü¸ÄMySQL·þÎñÆ÷µÄĬÈÏ´æ´¢ÒýÇæ¡£
·InnoDB£ºÓÃÓÚÊÂÎñ´¦ÀíÓ¦ÓóÌÐò£¬¾ßÓÐÖÚ¶àÌØÐÔ£¬°üÀ¨ACIDÊÂÎñÖ§³Ö¡£
·BDB£º¿ÉÌæ´úI ......

MySQLÊý¾Ý¿â²Ù×÷ÖÐÎÄÂÒÂë

½â¾öÂÒÂë×îºÃµÄ·½·¨ÊÇÔÚÏîÄ¿Éè¼ÆÖ®³õ£¬Í³Ò»ËùÓеÄ×Ö·û¼¯£¬ÀýÈçÒ³Ãæ¡¢request¶ÔÏóÒÔ¼°Êý¾Ý¿âµÈµÈ¡£
Ò»¡¢ ¼¸ÖÖ³£¼ûµÄÂÒÂëÏÖÏó£º
1¡¢Ò³ÃæÂÒÂë
    µ¥´¿µÄÒ³ÃæÂÒÂëÊǺܺýâ¾öµÄ£¬Ö»ÒªÐÞ¸ÄÍ·²¿ÊʺϵÄ×Ö·û¼¯¼´¿É£¬Èç¹ûÒ³ÃæÖÐÎÄÏÔʾÂÒÂ룬Äã¿ÉÒÔ°Ñ×Ö·û¼¯ÐÞ¸ÄΪ£ºgb2312»ògbk¡£
2¡¢Ò³ÃæÖ®¼ä´«µÝµÄ²ÎÊýÊÇÂÒÂë ......

MySQLƽ̨Êý¾Ý¿â±¸·Ý·½°¸Ïêϸ˵Ã÷

À´Ô´£ºccidnet.com ×÷ÕߣºSabine¡¡ ʱ¼ä£º2006-10-09
ÔÚÊý¾Ý¿â±í¶ªÊ§»òË𻵵ÄÇé¿öÏ£¬±¸·ÝÄãµÄÊý¾Ý¿âÊǺÜÖØÒªµÄ¡£Èç¹û·¢Éúϵͳ±ÀÀ££¬Äã¿Ï¶¨ÏëÄܹ»½«ÄãµÄ±í¾¡¿ÉÄܶªÊ§×îÉÙµÄÊý¾Ý»Ö¸´µ½±ÀÀ£·¢ÉúʱµÄ״̬¡£ÓÐʱ£¬ÕýÊÇMySQL¹ÜÀíÔ±Ôì³ÉÆÆ»µ¡£¹ÜÀíÔ±ÒѾ­ÖªµÀ±íÒÑÆÆ»µ£¬ÓÃÖîÈçvi»òEmacsµÈ±à¼­Æ÷ÊÔͼֱ½Ó±à¼­ËüÃÇ£¬Õâ¶Ô±í¾ø¶Ô²»ÊǼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ