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

MySql²Ù×÷ÒªµãÕûÀí

TINYINT 1 ×Ö½Ú
SMALLINT 2 ¸ö×Ö½Ú
MEDIUMINT 3 ¸ö×Ö½Ú
INT 4 ¸ö×Ö½Ú
INTEGER 4 ¸ö×Ö½Ú
BIGINT 8 ¸ö×Ö½Ú
FLOAT(X) 4 Èç¹û X < = 24 »ò 8 Èç¹û 25 < = X < = 53
FLOAT 4 ¸ö×Ö½Ú
DOUBLE 8 ¸ö×Ö½Ú
DOUBLE PRECISION 8 ¸ö×Ö½Ú
REAL 8 ¸ö×Ö½Ú
DECIMAL(M,D) M×Ö½Ú(D+2 , Èç¹ûM < D)
NUMERIC(M,D) M×Ö½Ú(D+2 , Èç¹ûM < D)
ÈÕÆÚºÍʱ¼äÀàÐÍ
ÁÐÀàÐÍ ÐèÒªµÄ´æ´¢Á¿
DATE 3 ¸ö×Ö½Ú
DATETIME 8 ¸ö×Ö½Ú
TIMESTAMP 4 ¸ö×Ö½Ú
TIME 3 ¸ö×Ö½Ú
YEAR 1 ×Ö½Ú
´®ÀàÐÍ
ÁÐÀàÐÍ ÐèÒªµÄ´æ´¢Á¿
CHAR(M) M×Ö½Ú£¬1 <= M <= 255
VARCHAR(M) L+1 ×Ö½Ú, ÔÚ´ËL <= MºÍ1 <= M <= 255
TINYBLOB, TINYTEXT L+1 ×Ö½Ú, ÔÚ´ËL< 2 ^ 8
BLOB, TEXT L+2 ×Ö½Ú, ÔÚ´ËL< 2 ^ 16
MEDIUMBLOB, MEDIUMTEXT L+3 ×Ö½Ú, ÔÚ´ËL< 2 ^ 24
LONGBLOB, LONGTEXT L+4 ×Ö½Ú, ÔÚ´ËL< 2 ^ 32
ENUM(’value1′,’value2′,…) 1 »ò 2 ¸ö×Ö½Ú, È¡¾öÓÚö¾ÙÖµµÄÊýÄ¿(×î´óÖµ65535£©
SET(’value1′,’value2′,…) 1£¬2£¬3£¬4»ò8¸ö×Ö½Ú, È¡¾öÓÚ¼¯ºÏ³ÉÔ±µÄÊýÁ¿(×î¶à64¸ö³ÉÔ±£©
mysql²»Çø·Ö´óСд£¡
1.#service mysqld start Æô¶¯mysql
2.(´òmysql½øÈëºó)show databases; ÏÔʾËùÓпâ
3.use(»òconnect) ¿âÃû ʹÓôËÊý¾Ý¿â
4.show tables; ÏÔʾËùÓбí
5.GRANT ALL ON ¿âÃû.* TO Óû§Ãû; root¿ÉÖ´ÐУ¬¸ø²»Í¬µÄÊý¾Ý¿â²»Í¬µÄÓû§¹ÜÀí
6.CREATE DATABASE пâÃû; н¨Ò»¸öÊý¾Ý¿â
7.quit Í˳ömysql,ÁíÍâµÄ²Î¼ûsql/9
mysqladmin -uroot password “youpassword” Ð޸ĹÜÀíÔ±ÃÜÂë
GRANT ALL ¡¡¡¡ON ¿âÃû.* ¡¡¡¡TO user IDENTIFIEDBY “password” ¡¡¡¡WITH GRANT OPTION;
WITH GRANT OPTION ×Ó¾äÊÇ¿ÉÑ¡µÄ¡£Èç¹û°üº¬¸Ã×Ӿ䣬¸ÃÓû§¿ÉÒÔ½«GRANT Óï¾äÊÚÓèµÄÈκÎȨÏÞÊÚÓèÆäËûµÄÓû§¡£¿ÉÒÔʹÓøÃ×Ӿ佫ÊÚȨµÄÄÜÁ¦ÊÚÓèÆäËûµÄÓû§¡£
GRANT ALL ¡¡¡¡ON ¿âÃû.* ¡¡¡¡TO user IDENTIFIEDBY “password” ¡¡¡¡WITH GRANT OPTION;
WITH GRANT OPTION ×Ó¾äÊÇ¿ÉÑ¡µÄ¡£Èç¹û°üº¬¸Ã×Ӿ䣬¸ÃÓû§¿ÉÒÔ½«GRANT Óï¾äÊÚÓèµÄÈκÎȨÏÞÊÚÓèÆäËûµÄÓû§¡£¿ÉÒÔʹÓøÃ×Ӿ佫ÊÚȨµÄÄÜÁ¦ÊÚÓèÆäËûµÄÓû§¡£
³·È¨²¢É¾³ýÓû§
ҪȡÏûÒ»¸öÓû§µÄȨÏÞ£¬Ê¹ÓÃREVOKEÓï¾ä¡£REVOKEµÄÓï·¨·Ç³£ÀàËÆÓÚGRANTÓï¾ä£¬³ýÁËTOÓÃfromÈ¡´ú²¢ÇÒûÓÐINDETIFED BYºÍWITH GRANT OPTION×Ӿ䣺
======================


Ïà¹ØÎĵµ£º

mysql alter Óï¾äÓ÷¨,Ìí¼Ó¡¢Ð޸ġ¢É¾³ý×ֶεÈ


//Ö÷¼ü
alter table tabelname add new_field_id int(5) unsigned default 0 not null auto_increment ,add primary key (new_field_id);
//Ôö¼ÓÒ»¸öÐÂÁÐ
alter table t2 add d timestamp;
alter table infos add ex tinyint not null default '0';
//ɾ³ýÁÐ
alter table t2 drop column c;
//ÖØÃüÃûÁÐ
......

MYSQLÓû§È¨ÏÞ¹ÜÀí(Grant,Revoke)

MySQL¿ÉÒÔΪ²»Í¬µÄÓû§·ÖÅäÑϸñµÄ¡¢¸´ÔÓµÄȨÏÞ¡£ÕâЩ²Ù×÷´ó¶à¶¼¿ÉÒÔÓÃSQLÖ¸ÁîGrant£¨·ÖÅäȨÏÞ£©ºÍRevoke£¨»ØÊÕȨÏÞ£©À´ÊµÏÖ¡£ Grant¿ÉÒÔ°ÑÖ¸¶¨µÄȨÏÞ·ÖÅä¸øÌØ¶¨µÄÓû§£¬Èç¹ûÕâ¸öÓû§²»´æÔÚ£¬Ôò»á´´½¨Ò»¸öÓû§¡£
 Grant ³£Óøñʽ:
grant ȨÏÞ1,ȨÏÞ2,…ȨÏÞn on Êý¾Ý¿âÃû³Æ.±íÃû³Æ to Óû§Ãû@Óû§µØÖ· ide ......

ÐÞ¸Äͨ´ïOA MysqlÊý¾Ý¿âÃÜÂë


ÓеÄÓû§£¬³öÓÚʹÓÃmysqlÊý¾Ý¿â¿ª·¢ÆäËû³ÌÐòµÄÐèÒª£¬¿ÉÄÜÏ£ÍûÐÞ¸ÄMysqlÊý¾Ý¿âµÄrootÓû§ÃÜÂ룬
ÏÖ×öÒÔϼòҪ˵Ã÷¡£
ÓÉÓÚOAʹÓõÄMysqlÊý¾Ý¿â±»É趨ΪֻÄÜ´Ó±¾»ú·ÃÎÊ£¬ËùÒÔÆÕͨÓû§²»½¨ÒéÐÞ¸ÄÊý¾Ý¿âÃÜÂ룬
ÐÞ¸ÄÊý¾Ý¿âÃÜÂë²¢²»ÊÇΪÁ˸ÄÉÆÏµÍ³°²È«ÐÔµÄÄ¿µÄ¡£
windows-¡µ¿ªÊ¼—¡µÔËÐУ¬ÊäÈëcmd½øÈëÃüÁîÐÐģʽ£¬²¢Ê¹Ó ......

MysqlµÄ´æ´¢ÒýÇæ


<!--
/* Font Definitions */
@font-face
{font-family:ËÎÌå;
panose-1:2 1 6 0 3 1 1 1 1 1;
mso-font-alt:SimSun;
mso-font-charset:134;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:3 135135232 16 0 262145 0;}
@font-face
{font-family:"\@ËÎÌå" ......

MysqlÊýѧº¯Êý½âÎö

ËùÓеÄÊýѧº¯ÊýÔÚÒ»¸ö³ö´íµÄÇé¿öÏ·µ»ØNULL¡£ 

µ¥Ä¿¼õ¡£¸Ä±ä²ÎÊýµÄ·ûºÅ¡£ 
mysql> select - 2; 
×¢Ò⣬Èç¹ûÕâ¸ö²Ù×÷·ûÓëÒ»¸öBIGINTʹÓ㬷µ»ØÖµÊÇÒ»¸öBIGINT£¡ÕâÒâζ×ÅÄãÓ¦¸Ã±ÜÃâÔÚÕûÊýÉÏʹÓÃ-£¬ÄÇ¿ÉÄÜÓÐÖµ-2^63£¡ 
ABS(X)
·µ»ØXµÄ¾ø¶ÔÖµ¡£ 
mysql> select ABS(2);&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ