mysql»ù´¡ÖªÊ¶
1. MySQLÊÇÒ»¸öСÐ͹ØϵÐÍÊý¾Ý¿â¹ÜÀíϵͳ
2. MySQLµÄÊý¾ÝÀàÐÍ£º
ÕûÊýÐÍ£ºTINYINT£¬SMALLINT£¬INT£¬BIGINT
СÊýÐÍ£ºFLOAT£¬DOUBLE£¬DECIMAL(M,D)
×Ö·ûÐÍ£ºCHAR£¬VARCHAR
ÈÕÆÚÐÍ£ºDATETIME £¬DATE£¬TIMESTAMP
±¸×¢ÐÍ£ºTINYTEXT £¬TEXT £¬LONGTEXT
£¨°´php100µÄ½Ì³ÌÀï·ÖµÄ£©
3.MySQLµÄ»ù±¾Óï¾ä
´´½¨Êý¾Ý¿â CREATE DATABASE Êý¾Ý¿âÃû
ɾ³ýÊý¾Ý¿â DIOP DATABASE Êý¾Ý¿âÃû
´´½¨Êý¾Ý±í CREATE TABLE ±íÃû
ɾ³ýÊý¾Ý±í DROP TABLE ±íÃû
ÐÞ¸ÄÒ»¸ö×Ö¶ÎÃû³Æ RENAME TABLE `Ô×Ö¶ÎÃû`TO`ÐÂ×Ö¶ÎÃû`;
ɾ³ýÒ»¸ö×ֶΠALTER TABLE `±í`DROP`Ô×Ö¶Î`;
²åÈëÒ»¸ö×ֶΠALTER TABLE `±í`ADD`ÐÂ×Ö¶Î`...AFTER`Ô×Ö¶Î`;
4.²éѯÓï¾ä ²åÈëÓï¾ä ¸üÐÂÓï¾ä ɾ³ýÓï¾ä
²éѯÓï¾ä
SELECT ²éѯ×ֶΠfrom ±íÃû WHERE Ìõ¼þ
²éѯ×ֶΣº¿ÉÒÔʹÓÃͨÅä·û* ¡¢×Ö¶ÎÃû¡¢×ֶαðÃû
±íÃû£ºÊý¾Ý¿â.±íÃû£¬±íÃû
³£ÓÃÌõ¼þ£º = µÈÓÚ¡¢<>²»µÈÓÚ¡¢in °üº¬¡¢ not in ²»°üº¬¡¢ like Æ¥Åä
BETWEENÔÚ·¶Î§¡¢ not BETWEEN²»ÔÚ·¶Î§< ¡¢>
Ìõ¼þÔËË㣺 and ¡¢ or ¡¢ ( )
²åÈëÓï¾ä
insert into ±íÃû (×ֶ΅,…) values(Öµ…,…)
¸üÐÂÓï¾ä
UPDATE ±íÃû SET ×Ö¶Î=Öµ WHERE Ìõ¼þ limit
³£ÓÃÌõ¼þ£º = µÈÓÚ¡¢<>²»µÈÓÚ¡¢in °üº¬¡¢ not in ²»°üº¬¡¢ like Æ¥Åä
BETWEENÔÚ·¶Î§¡¢ not BETWEEN ²»ÔÚ·¶Î§
ɾ³ýÓï¾ä
DELETE from ±íÃû WHERE Ìõ¼þ limit
³£ÓÃÌõ¼þ£º = µÈÓÚ¡¢<>²»µÈÓÚ¡¢in °üº¬¡¢ not in ²»°üº¬¡¢ like Æ¥Åä
BETWEENÔÚ·¶Î§¡¢ not BETWEEN ²»ÔÚ·¶Î§
Ïà¹ØÎĵµ£º
¸ÃÁ¬½Ó·½Ê½²ÉÓÃRPCÀ´·µ»ØÊý¾Ý¿â²éѯ½á¹û¡£
1.Ê×ÏÈÊÇ´´½¨ÆÕͨµÄGWT-EXT¹¤³Ì¡£¿ÉÒԲο¼1http://www.ibm.com/developerworks/cn/java/j-lo-gwtext1/#resources
ϵÁÐ Èë ÃÅ ½Ì³Ì¡£¾ßÌåͨѶ¹ý³Ì·þÎñÒ²¿É²Î¿¼ÉÏÊöµÄ×îºó²¿·Ö˵Ã÷¡£
2. ½ÓÏÂÀ´¾ÍÊÇÒª´´½¨GWT Remote ServiceÁË£¬ÔÚÔÓй¤³ÌÉÏnew-&g ......
Linux ±àÒë°²×° MYSQL 5.1 Óë Innodb
±àÒëmysql5
´úÂë:
./configure \
--prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \
--with-extra-charsets=all \
--with-charset=utf8 \
- ......
·Ò룺
InnoDB±í»á°üº¬Ò»¸ö¾Û¼¯Ë÷Òý£¨Êý¾Ý±íµÄÎïÀí´æ´¢Ë³ÐòºÍ±íµÄÂß¼´æ´¢Ë³ÐòÒ»Ö£©
Ò»°ãÊÇ°´ÕÕÏÂÃæµÄ¹æÔòÀ´É趨¾Û¼¯Ë÷ÒýµÄ£º
1£¬¼ÙÈç±í°üº¬PRIMARY KEY£¬InnoDBʹÓÃËü×÷Ϊ¾Û¼¯Ë÷Òý
2£¬¼ÙÈç±íûÓж¨ÒåPRIMARY KEY£¬InnoDB½«µÚÒ»¸öÖ»°üº¬NOT NULLÊôÐÔÁеÄUNIQUE index×÷ΪÖ÷¼ü²¢ÇÒ½«ËüÉèÖÃΪ¾Û¼¯Ë÷Òý
3£¬Ç°Á½Õ߶¼²»Âú× ......
ËùÓеÄÊýѧº¯ÊýÔÚÒ»¸ö³ö´íµÄÇé¿öÏ·µ»ØNULL¡£
-
µ¥Ä¿¼õ¡£¸Ä±ä²ÎÊýµÄ·ûºÅ¡£
mysql> select - 2;
×¢Ò⣬Èç¹ûÕâ¸ö²Ù×÷·ûÓëÒ»¸öBIGINTʹÓ㬷µ»ØÖµÊÇÒ»¸öBIGINT£¡ÕâÒâζ×ÅÄãÓ¦¸Ã±ÜÃâÔÚÕûÊýÉÏʹÓÃ-£¬ÄÇ¿ÉÄÜÓÐÖµ-2^63£¡
ABS(X)
·µ»ØXµÄ¾ø¶ÔÖµ¡£
mysql> select ABS(2);&n ......
drop table student;
create table student
(sno int not null unique,
sname varchar(8) not null,
ssex char(2) not null,
sage int ,
sdept varchar(20));
select * from student;
alter table student drop uniq ......