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

MySQL³£ÓÃÓï¾ä

/*²éѯÊý¾Ý¿â*/
show databases;
/*´´½¨Êý¾Ý¿â*/
create database dengheping;
/*ʹÓÃÊý¾Ý¿â*/
use dengheping;
/*´´½¨±í*/
create table user(id int primary key auto_increment,name char(255));
/*²éѯ±í*/
show tables;
/*ÏÔʾ±í½á¹¹*/
desc user;
/*²åÈë×Ö¶Î*/
alter table user add password varchar(64);
/*ÐÞ¸Ä×Ö¶Î*/
alter table user modify password varchar(64) not null;
/*ɾ³ý×Ö¶Î*/
alter table user drop password;
ÉèÖñàÂë
 alter database mybbs default character set 'gbk';


Ïà¹ØÎĵµ£º

½â¾öÔ¶³ÌÁ¬½Ómysql´íÎó1130´úÂëµÄ·½·¨


ÒÔÏÂÕª×ÔÍøÂç
----------------------------------------
½ñÌìÔÚÓÃÔ¶³ÌÁ¬½ÓMysql·þÎñÆ÷µÄÊý¾Ý¿â£¬²»¹ÜÔõôŪ¶¼ÊÇÁ¬½Ó²»µ½£¬´íÎó´úÂëÊÇ1130£¬ERROR 1130: Host 192.168.2.159 is not allowed to connect to this MySQL server
²ÂÏëÊÇÎÞ·¨¸øÔ¶³ÌÁ¬½ÓµÄÓû§È¨ÏÞÎÊÌâ¡£½á¹ûÕâÑù×Ó²Ù×÷mysql¿â£¬¼´¿É½â¾ö¡£ÔÚ±¾»úµÇÈëmysqlº ......

MySqlѧϰ±Ê¼Ç

MySqlѧϰ±Ê¼Ç MySql¸ÅÊö£ºMySqlÊÇÒ»¸öÖÖ¹ØÁªÊý¾Ý¿â¹ÜÀíϵͳ£¬Ëùν¹ØÁªÊý¾Ý¿â¾ÍÊǽ«Êý¾Ý±£´æÔÚ²»Í¬µÄ±íÖУ¬¶ø²»Êǽ«ËùÓÐÊý¾Ý·ÅÔÚÒ»¸ö´óµÄ²Ö¿âÖС£ÕâÑù¾ÍÔö¼ÓÁËËÙ¶ÈÓëÌá¸ßÁËÁé»îÐÔ¡£²¢ÇÒMySqlÈí¼þÊÇÒ»¸ö¿ª·ÅÔ´ÂëÈí¼þ¡£ ×¢Ò⣬MySqlËùÖ§³ÖµÄTimeStampµÄ×î´ó·¶Î§µÄÎÊÌ⣬ÔÚ32λ»úÆ÷ÉÏ£¬Ö§³ÖµÄȡֵ·¶Î§ÊÇÄê·Ý×îºÃ²»Òª³¬¹ý2030Äê ......

PHP session ´íÎó¼°mysql close ´íÎó´¦Àí

ÔÚа²×°ºÃµÄmysql £¬apahce£¬php µÄʱºò£¬Èç¹ûÔÚ´úÂëÖÐʹÓÃÁËsessions_start() µÄʱºò»á³öÏÖÀàËÆÒÔϵĴíÎó£º
Warning: session_start() [function.session-start]: Cannot send session cooki µÈµÄ´íÎó¡£
Çë°²×°ÈçϵÄ˼·ȥÐÞÕý£º
1.ÔÚphp.ini ÖÐÅäÖÃ session.savepath='/tmp'
2.¿ªÆôsession.auto_start=1
3.°Ñ¸ü¸Ä ......

mysql: Too many connections

½ñÌ쿪¶àÒ»¸öÓ¦ÓÃÔÚ APP SERVER ÉÏ£¬±¨¸æÒ»¸ö´íÎó:
ERROR 1040 (00000): Too many connections
Õâµ¹ÊÇ´ÓÀ´Ã»Åöµ½¹ý£¬²»¹ýÔÚ console Ï¿ÉÒÔÓà root µÇ¼ £¨console ÏÂÓÃÆäËûÓû§Ò²²»¿ÉµÇ¼£¬Too many connections£©
mysql -uroot -p
mysql > show processlist;
... 
ÕâÀïÁÐÁË100¸öÁ´½Ó£¡£¡ÆäÖÐÖ»ÓÐ2¸öÁ´½ÓÊÇQ ......

mysql¶à±íÁªºÏ²éѯ²¢Í³¼Æ

ÍÆ¹ãµØµã±ípromotion_addr×ֶΣºname£¬id
µç»°±¨¿¢±íunicom_record×ֶΣºdate, sheet_id£¨¹ØÁªsheet±íid£©
±¨µ¥±ísheet×ֶΣºid,promotion_addr_id£¨¹ØÁªpromotion_addr±íid£©
ÒªÇóͳ¼ÆÄ³¸öÔÂÒѱ¨¿¢¸÷ÍÆ¹ãµØµãµÄÍÆ¹ã¸öÊý£»
SELECT
p.name, count(*)
from
unicom_record AS ur
Left Join sheet AS s ON ur.sheet_id ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ