Á¬½ÓMySQLÕÒ²»µ½mysql.sockÎļþµÄ½â¾ö°ì·¨
ÔËÐгÌÐò¿ÉÄܻᱨ´í£ºCan’t connect to local MySQL Server through socket ‘/tmp/mysql.sock’
Õâ¸ö´íÎóµÄÌáʾÊÇ˵£¬²»ÄÜͨ¹ý’/tmp/mysql.sock’Á¬½Óµ½·þÎñÆ÷¡£Mysql.sockÊÇ´´½¨Óëmysqld·þÎñÆ÷Ïà¹ØµÄMySQLͨÐŶ˵ãËùʹÓõÄÌ×½Ó×Ö¡£¶øPHP±ê×¼ÅäÖÃÕýÊÇͨ¹ý’/tmp/mysql.sock’À´Á¬½ÓÊý¾Ý¿â£¬¿ÉÄÜÊÇһЩmysqlµÄ°²×°·½·¨½«mysql.sock·Åµ½Á˱ðµÄµØ·½£¬¿ÉÒÔͨ¹ýÐÞ¸Ä/etc/mysql/my.cnfÎļþ£¨»òÕß/etc/my.confÎļþ£¬ºÍmysql°²×°µÄ·½·¨Óйأ¬¸ÃÅäÖÃÎļþµÄ·¾¶¿ÉÄÜ»áÓÐËù²»Í¬£©À´ÐÞ¸ÄËü£¬´ò¿ªÎļþ¿ÉÒÔ¿´µ½ÈçϵÄÓï¾ä£º
[mysqld]
Socket = /var/lib/mysql/mysql.sock
˵Ã÷mysqld.sockÎļþ·ÅÔÚÁË/var/lib/mysql/Îļþ¼ÐÏ£¬ËùÒÔ²»ÄÜÔÚ/tmp·¾¶ÏÂÕÒµ½¸ÃÎļþ£¬Í¨¹ý×öÒ»¸öÁ´½ÓÎļþ¾Í¿ÉÒÔ½â¾öÕâ¸öÎÊÌ⣺
Äú¿ÉÒÔÔÚÃüÁîÐÐÏÂÊÖ¶¯ÊäÈëÈçÏÂÃüÁ
ln -s /var/lib/mysqld/mysqld.sock /tmp/mysql.sock
ÐÞ¸ÄÍêÖ®ºó£¬³ÌÐò¾Í¿ÉÒÔÕý³£Æô¶¯ÁË¡£
Èç¹û»¹ÊDz»ÄÜÆô¶¯µÄ»°£¬¿ÉÄÜÊÇÓÉÓÚMySQL·þÎñÆ÷ûÓдò¿ª£¬Èç¹ûMySQL·þÎñÆ÷ûÓдò¿ªµÄ»°£¬ÔÚ/var/lib/mysql/Ŀ¼Ï¾Ͳ»»áÓÐmysql.sockÕâ¸öÎļþ£¬ËùÒÔ¼´Ê¹×öÁËÁ´½ÓÎļþ¾ÍûÓÐÓã¬ÒòΪËü¸ù±¾ÕÒ²»µ½/var/lib/mysql/mysql.sockÎļþ¡£ËùÒÔʹÓÃÃüÁÆôMySQL·þÎñÆ÷£º
$service mysqld start
Èç¹ûÏëÈÃMySQL·þÎñÆ÷ÔÚÿ´Î¼ÆËã»úÖØÆôʱÆô¶¯£¬¼üÈëÈçÏÂÃüÁrootÓû§Éí·Ý£©£º
$chkconfig mysqld on
Ïà¹ØÎĵµ£º
Ò»¡¢³£ÓÃ×Ö·û´®º¯Êý
1.CONCAT(str1,str2,...)
mysql> ? concat;
mysql> SELECT CONCAT('My', 'S', 'QL');
+-------------------------+
| CONCAT('My', 'S', 'QL') |
+-------------------------+
| MySQL ......
Ê×Òª²½Öè(Ò»°ã¿ÉÊ¡ÂÔ):
¿ªÆômysql·þÎñ(ĬÈÏÊÇ¿ª»úʱ¾Í×Ô¶¯ÔËÐÐÁË):
¿ØÖÆÃæ°å
-->¹ÜÀí¹¤¾ß-->·þÎñ,ÔÚÀïÃæÕÒµ½Ãû³ÆΪmysqlµÄÏî,Ë«»÷¾Í¿É¿´ËüµÄ·þÎñ״̬ÊÇÆô¶¯»¹ÊÇÍ£Ö¹,°ÑËüÉèΪÆô¶¯
Á¬½Ómysql:
ÔÚÃüÁîÐÐÏÂÊäÈë mysql -h
localhost -u root -p»Ø³µ,È»ºóÊäÈëÃÜÂë¼´¿É;»òÖ±½ÓÔËÐÐmysql×Ô´øµÄÁ¬½Ó¹¤¾ß,È»ºóÊäÈëÃÜÂë¼ ......
×î½üÁ˽âÁËÒ»ÏÂMYSQL×¢È룬Ҳʵ¼Ê²Ù×÷ÁËһϣ¬È·Êµ·¢ÏÖÁËËûµÄÍþÁ¦¡£
Ò»¸ö×¢È멶´¿ÉÒÔÈÃÈËÖ±½ÓÄõ½·þÎñÆ÷ȨÏÞ¡£
×ܽáһϣº
1£¬Ä¿Â¼µÄȨÏÞ²»ÄÜÌ«¸ß£¬²»È»±ðÈËÄÜÍùÀïдÎļþ£¬ÒÔÇ°ÓÃ0777ÕæÊÇÌ«ÓÞ´ÀÁË¡£
2£¬Ñϸñ¹ýÂËÊý¾Ý£¬ÕûÐÎÒ»ÂÉתint»òÓÃmysql_escape_string
3£¬ÉèÖúÏÀíµÄÊý¾Ý¿âȨÏÞ£¬²»ÒªÓÃROOT,²»È»»áËÀµÃºÜ²Ò¡£
4 ......
ÏîÄ¿´ÓmysqlǨÒƵ½ORACLEÖÐÓöµ½ÒÆÖ²ÎÊÌ⣬mysqlÖÐÖ§³Ölimit ¶øORACLE say no .
½â¾ö·½·¨ ÀûÓÃORACLEµÄαÁÐ rownumÀ´¿ØÖÆ¡£¡£
Mysql : select * from table limit 10
equl
ORACLE£º select * from table where rownum <= 10
ORACLE αÁнéÉÜ£º
ËæÊý¾Ý×ÖµäÒ»Æð×Ô¶¯´´½¨µÄÒ»¸ö±í,ÊôÓÚsysģʽ,ÈκÎÓû§¶¼¿ÉÒÔ·ÃÎÊ,&nbs ......
Ê×ÏÈÐèÒª²é¿´Ò»Ï´´½¨º¯ÊýµÄ¹¦ÄÜÊÇ·ñ¿ªÆô£º
X:\proper\mysql\bin>mysql -h localhost -u root -p
Enter password: **********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12 to server version: 5.0.22-community-nt-log
Type 'help;' or '\h' for help. Type ' ......