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

Windowsƽ̨¶àMYSQLÅäÖÃ(¶àMy.ini)

    ×î½üÔÚѧϰSSH£¬ÓÉÓÚΪÁ˽ÚÔ¼Äڴ棬ËùÒÔ¾Í×¼±¸Ê¹ÓÃMYSQL´úÌæOracle£¬ÎªÁ˸üÉîÒ»²½µØÁ˽âMySQL£¬ÓÚÊǾͼƻ®°²×°noinstall°æ±¾£¬Õâ°æ±¾±È°²×°°æ¿ÉÂ鷳һЩ£¬ÌرðÊÇÅäÖ÷½Ã棬Èç¹ûÅäÖúõĻ°¾Í¿ÉÒÔÔÚһ̨»úÆ÷ÉÏÔËÐжà¸ö°æ±¾µÄMYSQL£¬ÔÚÍøÉÏÕÒÁËÇ°±²ÃǵıʼǺóѧϰÍê±ÏºóÔټǼһ±Ê£¬¾ÍÎÒÕâ¼ÇÐÔ£¬¹À¼ÆÃ÷¶ùÔçÉϾÍÈ«Íü¹âÁË¡£
    Ò»¸öƽ̨²¿Êð¶à¸öµÄÇé¿öÏÂ×î»ù±¾µÄ¾ÍÊÇÒª¸øÿ¸öƽָ̨¶¨²»Í¬µÄ my.ini Îļþ£¬µ±È»£¬ÔÚ ini ÎļþÖеÄÊý¾Ý¿âµÄ¶Ë¿ÚºÅÒ²»áÓв»Í¬£¬my.ini ÎļþµÄÄÚÈݾͰ´ÕÕ¸÷¸ö°æ±¾µÄ»ù±¾ÅäÖþͿÉÒÔ£¬²»ÐÐËæ±ãÕÒÒ»¸ö¸´ÖƹýÀ´¸Ä¸Ä¾ÍOKÁË£¬Ö÷ÒªÒªÐ޸ĵĵط½ÓÐÕâô¼¸¸ö£º1¡¢basedir = ¡ºµ±È»Òª×¢²áµÄ±¾°æµÄ¸ùĿ¼¡»2¡¢datadir = ¡ºÊý¾ÝĿ¼(dataÎļþ¼ÐλÖÃ)¡»3¡¢port = ¡º¶Ë¿ÚºÅ¡»¶à¸ö±ðÖظ´¾ÍÐÐÁË¡£Ö÷Òª¾ÍÊÇÕâ3¸öÖµµÄµØÖ·£¬ÒªÖ¸ÏòÄ㵱ǰÅäÖõÄmysql£¬µ±È»ÆäËûµÄÊôÐÔÒ²Ò»Ñù¡£
   
    È»ºó¾ÍÊÇ°²×°³É·þÎñ£¬Èç¹û²»°²×°³É·þÎñ£¬Ã¿´Î¶¼×Ô¼ºÆô¶¯Ò²Ò»Ñù£¬¼Óµã²ÎÊý¾Í¿ÉÒÔÁË¡£
    ²»°²×°³É·þÎñµÄÆô¶¯·½Ê½ÊÇ£ºbin>mysqld-nt --defaults-file="D:\xxx\old\mysql\my.ini" ÕâÑùÆô¶¯¾ÍÊÇÓÃÖ¸¶¨µÄini È¥Æô¶¯nt·þÎñ¡£
    °²×°³É·þÎñ£º     °²×°·þÎñÏà¶Ô¼òµ¥£¬X:\XXX\bin>mysqld-nt --install MySQLXXX --defaults-file="X:\XXX\my.ini"Ö»ÒªÔÚbinĿ¼ÏÂÔÚCMDÖÐʹÓà --installÃüÁָ¶¨·þÎñÃû³Æ£¬È»ºó×Ô¶¨Ä¬ÈϵÄiniÎļþÃû¼´¿É¡£     ³õʼ»¯Êý¾Ý¿â£º     ÔÚ·Ç°²×°°æÖÐÐèҪʹÓà mysqld-nt --console ³õʼ»¯Êý¾Ý¿â£¬ÔÚ¶àMYSQLÖУ¬°²×°µÚ¶þ¸öMYSQLʱҲÐèÒªÖ¸¶¨Ä¬ÈϵÄiniλÖã¬ÃüÁîΪX:\XXX\bin>mysqld-nt --defaults-file="X:\XXX\my.ini" --console ÕâÑù¾Í¿ÉÒÔÍê³É³õʼ»¯ÁË£¬ÆäËûµÄ²Ù×÷¶¼»ù±¾Ò»ÑùÁË¡£
ÔÚ¿ØÖÆ̨ÖÐÆô¶¯mysqlʱÐèÒª¼ÓÉϲÎÊý--port=#Ö®ÃûÐèÒªÖ¸¶¨µÄ¶Ë¿ÚºÅ ¡£


Ïà¹ØÎĵµ£º

mysql ÖÐshow ÃüÁîÓ÷¨Ïêϸ½éÉÜ

 ÒÔÏÂËùÓÐÃüÁÊÇÔÚ½øÈëmysql¼à¿ØÆ÷ÖÐÖ´Ðеģº
  a. show tables»òshow tables from database_name; // ÏÔʾµ±Ç°Êý¾Ý¿âÖÐËùÓбíµÄÃû³Æ
  b. show databases; // ÏÔʾmysqlÖÐËùÓÐÊý¾Ý¿âµÄÃû³Æ
  c. show columns from table_name from database_name; »òshow columns from databa ......

ÔÚSQLÖÐʹÓÃnow()µ¼ÖµÄÐÔÄÜϽµ(MySQL)

×öÊý¾Ý¿âµ÷ÓÅ£¬Ò»¸ö¼òµ¥µÄtip¾ÍʹÐÔÄÜÌáÉýÒ»´ó¿éʱ£¬±»°ïÖúµÄÈË×ÔÈ»ÊǸßÐ˶øÇҸм¤£¬ÎÒÒ²ÊÇÂúÐÄ»¶Ï²¡£ÓÃËùѧ°ïÖúÁËËûÈË£¬Ò²ËµÃ÷»¹ÊÇÓÐÒ»¼¼Ö®³¤µÄ£¬ÓÐÒ»ÃÅÄܹ»Ñø»î×Ô¼ºµÄÊÖÒÕ¡£Ò²ËãÊÇÊÖÒÕÈË°¡¡£
ͬÊÂÈÃÎÒ°ïÖúÓÅ»¯£¬ÔÚslow query logÀï·¢ÏÖÓÐÁ½¸öSQLÖ´ÐеĴÎÊý×î¶à£¬²¢ÇÒÿ´Î¶¼ÔÚÁ½ÃëÒÔÉÏ¡£ÓÃexplain¿´ÁË£¬Ò²Î´·¢ÏÖË÷ÒýʹÓ÷ ......

MySQLÔÓ

MySQLµÄtimestampÀàÐÍ×Ô¶¯¸üÐÂÎÊÌâ
 ½ñÌ콨ÁËÒ»¸ö±í£¬ÀïÃæÓÐÒ»¸öÁÐÊÇtimestampÀàÐÍ£¬ÎÒ±¾ÒâÊÇÔÚÊý¾Ý¸üÐÂʱ£¬Õâ¸ö×ֶεÄʱ¼äÄÜ×Ô¶¯¸üС£ÆñÖª¶ÔÕâ¸öÀàÐ͵ÄÖµ»¹²»ÉõÁ˽⣬µ¼Ö³ö´í¡£·¢ÏÖÕâ¸ö×Ö¶ÎÖ»ÊÇÔÚÕâÐÐÊý¾Ý½¨Á¢µÄʱºòÓÐÖµ£¬ÔÚ¸üеÄÈ´Îޱ仯¡£
    ²éÕÒ×ÊÁÏ£¬·¢ÏÖÊÇÎÒ½¨±íµÄÓï¾äÓÐÎÊÌ⣺
ÒÔÏÂÊÇ´ú ......

MySQL ×Ö·û´®º¯Êý£º×Ö·û´®½ØÈ¡

 MySQL ×Ö·û´®½ØÈ¡º¯Êý£ºleft(), right(), substring(), substring_index()¡£»¹ÓÐ mid(), substr()¡£ÆäÖУ¬mid(), substr() µÈ¼ÛÓÚ substring() º¯Êý£¬substring() µÄ¹¦Äܷdz£Ç¿´óºÍÁé»î¡£
1. ×Ö·û´®½ØÈ¡£ºleft(str, length)
mysql> select left('sqlstudy.com', 3);
+-------------------------+
| left('sq ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ