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';
Ïà¹ØÎĵµ£º
¿ÉÒÔÊÊÓÃÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃû£¬ gzipѹËõ , ´øÊä³öbuffer , Ö§³Ö·Ö¿â·Ö±í
ÐèÒª¸¨Öú´úÂëºÍMakefie , ÏÂÃæÊÇÖ÷³ÌÐò´úÂ룬
/**
* mysqlÊý¾Ý±ídump³ÌÐò
* @author : cheng limin
* @date : 2010-1-18
*
* ʹÓÃÑùÀý:
*./dump_mysql -c ../conf/dump.conf
* -t xml
* -s ......
ÔÚа²×°ºÃµÄ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µÄ×Ö·û¼¯ÊDZȽÏÂé·³µÄ,ĬÈϵĶÔÎÒÃÇÀ´Ëµ¸ù±¾¾ÍûʲôÓÃ,ÎÒÃÇÊÇÒªÓõ½ÖÐÎĵÄ,ËùÒÔÒ»¶¨µÃ¸Ä×Ö·û¼¯,Èç¹û×Ö·û¼¯²»¶Ô»áÓкܶàµÄÎÊÌâ,ÓÐÂÒÂ뻹ÓоÍÊÇÎÒÃÇÔÚ³ÌÐòÀï²åÈëÖÐÎÄʱ»á¸øÄã˵mysql Data truncation: Data too long for column,ÄãǧÍò±ðÒÔΪÊÇÄãµÄ×Ö¶ÎÉèµÃ²»¹»³¤,ÄãÉèµÃÔÙ³¤Ëû¶¼»á±¨´í,ËùÒÔ¸Ä×Ö·û¼¯°É
ÎÒÃÇÒ»°ã×°ºÃÊý ......
ÔÚmysqlÖÐÊäÈëSHOW variables like "have_%"²é¿´£¬ÏÔʾÈçÏ£º
mysql> SHOW variables like "have_%";
+-----------------------+----------+
| Variable_name | Value |
+-----------------------+----------+
| have_archive   ......
1.ʵÏÖTAB¼ü²¹È«
SHELL>vi /etc/my.cnf
[mysql]
#no-auto-rehash
auto-rehash
SHELL>reboot mysqld
note: 1.ÒªÏÈuseµ½Ä³¸öÊý¾Ý¿âÏ£»2.Òª²¹È«µÄ¹Ø¼ü×ÖÐèÒª´óд¡£
2.promptÈòÙ×÷¸ü¼ÓÇå³þ
mysql>prompt \u@\h(\d) \r:\m:\s (ÁÙʱ)
[mysql] £¨³¤¾Ã£©
prompt=\\u@\\h
3.pagerÈÃä ......