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×Ӿ䣺
======================
Ïà¹ØÎĵµ£º
//Ö÷¼ü
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;
//ÖØÃüÃûÁÐ
......
¸ÃÁ¬½Ó·½Ê½²ÉÓÃRPCÀ´·µ»ØÊý¾Ý¿â²éѯ½á¹û¡£
1.Ê×ÏÈÊÇ´´½¨ÆÕͨµÄGWT-EXT¹¤³Ì¡£¿ÉÒԲο¼1http://www.ibm.com/developerworks/cn/java/j-lo-gwtext1/#resources
ϵÁÐ Èë ÃÅ ½Ì³Ì¡£¾ßÌåͨѶ¹ý³Ì·þÎñÒ²¿É²Î¿¼ÉÏÊöµÄ×îºó²¿·Ö˵Ã÷¡£
2. ½ÓÏÂÀ´¾ÍÊÇÒª´´½¨GWT Remote ServiceÁË£¬ÔÚÔÓй¤³ÌÉÏnew-&g ......
1 MySQLÖ§³Öenum,ºÍsetÀàÐÍ£¬SQL Server²»Ö§³Ö
¡¡¡¡2 MySQL²»Ö§³Önchar,nvarchar,ntextÀàÐÍ
¡¡¡¡3 MySQLµÄµÝÔöÓï¾äÊÇAUTO_INCREMENT£¬¶øMS SQLÊÇidentity(1,1)
¡¡¡¡4 MS SQLĬÈϵ½´¦±í´´½¨Óï¾äµÄĬÈÏÖµ±íʾÊÇ((0)),¶øÔÚMySQLÀïÃæÊDz»ÔÊÐí´øÁ½À¨ºÅµÄ
¡¡¡¡5 MySQLÐèҪΪ±íÖ¸¶¨´æ´¢ÀàÐÍ
¡ ......
TINYINT
-128 - 127
TINYINT UNSIGNED
0 - 255
SMALLINT
-32768 - 32767
SMALLINT UNSIGNED
0 - 65535
MEDIUMINT
-8388608 - 8388607
MEDIUMINT UNSIGNED
0 - 16777215
INT »ò INTEGER
-2147483648 - 2147483647
INT UNSIGNED »ò INTEGER UNSIGNED
0 - 4294967295
BIGINT
-9223372036854775808 - 92233720 ......