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

mysqlÂÒÂëÎÊÌâ

ÔÚPHP´úÂë¶ÎÇ°ÃæÔËÐÐÒÔÏÂÓï¾ä
@mysql_connect($host,$user,$password);
@mysql_query('SET NAMES "UTF8"');
@mysql_query('SET COLLATION_CONNECTION=utf8_general_ci'); 
»òÕßÔÚMYSQLÖÐÔËÐÐÒ»´Î:
SET NAMES "UTF8";
SET COLLATION_CONNECTION=utf8_general_ci
Ò»ÀÍÓÀÒÝ


Ïà¹ØÎĵµ£º

MySQL server has gone away µÄ½â¾ö°ì·¨

ÓÐʱºòʹÓÃMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ÃüÁîÐе¼È뱸·Ýʱ»á³öÏÖ“MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ) server has gone away”´íÎó£¬Õâ¿ÉÄÜÊÇÒòΪÆäÖÐһЩinsertÓï¾äµÄ´óС³¬³öÁËMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)ĿǰÉèÖõĻº³åÇø´óС¡£
½â¾ö°ì·¨
1.ʹÓÃphpmyadmin ±¸·ÝMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)µÄʱºò£¬Ö»Ñ¡Ôñ
Êý¾Ý: ......

Linux Ï mysql µÄÏà¹ØÃüÁî

1.µÇ¼£º mysql -uroot -p
2.LinuxÏÂmysql ²»ÄÜÍâÍø·ÃÎÊ
  
   ÒѾ­ÔÚMYSQLÀïgrantÁËȨÏÞÁË¡£ÔÚÍâÍø»¹ÊDz»ÄÜ·ÃÎÊ .
   ÎÊÌ⣺
   cat  /etc/mysql/my.conf
   ÕÒµ½ÏÂÃæÒ»ÐÐ
   bind-address   = 127.0.0.1
   Î ......

mysqlÖÐʱ¼ä²éѯº¯Êý£¨°üÀ¨Ê±¼ä´Á£©

ÕâЩº¯Êý¶¼ÊÇMySQL×Ô´øµÄ£¬¿ÉÒÔÖ±½ÓʹÓÃÔÚPHPдµÄMySQL²éѯÓï¾äÖÐŶ
1-CURDATE()»òCURRENT_DATE()ºÍCURTIME()»òCURRENT_TIME()
ÕâÁ½¸öº¯ÊýÊDZȽϳ£Óõ½µÄ£¬¹ËÃû˼Ò壬µÚÒ»¸ö·µ»Øµ±Ç°ÈÕÆÚ£¬µÚ¶þ¸ö·µ»Øµ±Ç°Ê±¼ä
¿ÉÒÔÔÚMySQL¿Í»§¶Ë»òÕßPHPÓï¾äÀïд"SELECT CURDATE(),CURTIME()"²é¿´Ïà¹ØÐÅÏ¢.
»¹ÓÐÒ»¸öºÜÖØÒªµÄº¯ ......

Ubuntu Öа²×°MySQL GUI Tools

±àÒëǰÐèÒª°²×°µÄ¿â£º
g++
libmysqlclient15-dev
libglade2-dev
libglib2.0-dev
libgtkmm-2.4-dev
libpcre3-dev
libxml2-dev
È»ºóÖ´ÐÐ
cd mysql-gui-common
./configure
make
sudo make install
cd ../mysql-administrator
./configure
make
sudo make install
°²×°MySQL Administrator
°²×°Íê³Éºómysql- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ