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µÄtestÊý¾Ý¿âÖн¨Á¢Ò»ÕÅÐÂ±í£ºtbl_user,½¨±íÓï¾äÈçÏ£º
DROP TABLE IF EXISTS `user`;
CREATE TABLE `tbl_user` (
`userid` varchar(50) NOT NULL,
`name` varchar(50) default '',
`blog` varchar(50) default '',
  ......
¿ÉÒÔÊÊÓÃÈκÎsql , ×Ô¶¯Ê¶±ð×Ö¶ÎÃû£¬ gzipѹËõ , ´øÊä³öbuffer , Ö§³Ö·Ö¿â·Ö±í
ÐèÒª¸¨Öú´úÂëºÍMakefie , ÏÂÃæÊÇÖ÷³ÌÐò´úÂ룬
/**
* mysqlÊý¾Ý±ídump³ÌÐò
* @author : cheng limin
* @date : 2010-1-18
*
* ʹÓÃÑùÀý:
*./dump_mysql -c ../conf/dump.conf
* -t xml
* -s ......
# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
#
#
# Installation Instructions
# ----------------------------------------------------------------------
#
# On Li ......
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ÈÃä ......
Win2003server ϼÜÉèPHPWind²úÆ·»·¾³
°²×°Ç°×¼±¸:1¡¢°²×°ºÃiis6
&nbs ......