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¼à¿ØÆ÷ÖÐÖ´Ðеģº
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 ......
×öÊý¾Ý¿âµ÷ÓÅ£¬Ò»¸ö¼òµ¥µÄtip¾ÍʹÐÔÄÜÌáÉýÒ»´ó¿éʱ£¬±»°ïÖúµÄÈË×ÔÈ»ÊǸßÐ˶øÇҸм¤£¬ÎÒÒ²ÊÇÂúÐÄ»¶Ï²¡£ÓÃËùѧ°ïÖúÁËËûÈË£¬Ò²ËµÃ÷»¹ÊÇÓÐÒ»¼¼Ö®³¤µÄ£¬ÓÐÒ»ÃÅÄܹ»Ñø»î×Ô¼ºµÄÊÖÒÕ¡£Ò²ËãÊÇÊÖÒÕÈË°¡¡£
ͬÊÂÈÃÎÒ°ïÖúÓÅ»¯£¬ÔÚslow query logÀï·¢ÏÖÓÐÁ½¸öSQLÖ´ÐеĴÎÊý×î¶à£¬²¢ÇÒÿ´Î¶¼ÔÚÁ½ÃëÒÔÉÏ¡£ÓÃexplain¿´ÁË£¬Ò²Î´·¢ÏÖË÷ÒýʹÓ÷ ......
MySQLµÄtimestampÀàÐÍ×Ô¶¯¸üÐÂÎÊÌâ
½ñÌ콨ÁËÒ»¸ö±í£¬ÀïÃæÓÐÒ»¸öÁÐÊÇtimestampÀàÐÍ£¬ÎÒ±¾ÒâÊÇÔÚÊý¾Ý¸üÐÂʱ£¬Õâ¸ö×ֶεÄʱ¼äÄÜ×Ô¶¯¸üС£ÆñÖª¶ÔÕâ¸öÀàÐ͵ÄÖµ»¹²»ÉõÁ˽⣬µ¼Ö³ö´í¡£·¢ÏÖÕâ¸ö×Ö¶ÎÖ»ÊÇÔÚÕâÐÐÊý¾Ý½¨Á¢µÄʱºòÓÐÖµ£¬ÔÚ¸üеÄÈ´Îޱ仯¡£
²éÕÒ×ÊÁÏ£¬·¢ÏÖÊÇÎÒ½¨±íµÄÓï¾äÓÐÎÊÌ⣺
ÒÔÏÂÊÇ´ú ......
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 ......