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

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 ²»ÔÚ·¶Î§


Ïà¹ØÎĵµ£º

UbuntuϳöÏÖMysql error(2002)µÄ½â¾ö·½·¨

      ¹ýÁËÒ»Õó×Óºó£¬ÎªÁËд·Ö²¼Ê½×÷Òµ£¬ÖØÐÂʹÓÃMysqlʱ£¬·¢ÏÖËäÈ»Æô¶¯³É¹¦ÁË£¬µ«ÊÇÁ¬½ÓµÄʱºòÈ¥³öÏÖÈçÏ´íÎó
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
¸ù¾ÝÌáʾÊÇ/var/run/mysqld/mysqld.sockÎļþ²»´æÔÚ¡£
Ϊʲô»áÕâÑùÄØ£¿
  ......

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


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

MysqlÖÐÎÄÂÒÂëÎÊÌâµÄС½á

¸ÅÊö£º
1.ÂÒÂëÎÊÌâ¹é¸ùµ½µ×ÊÇ×Ö·û¼¯µÄÎÊÌâ,ÄǾʹÓ×Ö·û¼¯ÉèÖ÷½Ã濼ÂÇ,²»ÍâºõÏÂÃæ¼¸·½Ã棺
  server(Mysql·þÎñÆ÷),client,database(Êý¾Ý¿â),connection(Á¬½Ó),result
  MySQLµÄ×Ö·û¼¯´¦ÀíÊÇÕâÑùµÄ£º
 £¨1£©·¢ËÍÇëÇó
      ¿Í»§¶Ë(character_set_client£©=¡·Êý¾ ......

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 ......

MySQL°²裝Ö¸ÄÏ

Òª°²裝 MySQL£¬¿ÉÒÔÔÚ終¶ËÌáʾ·ûºó運ÐÐÏÂÁÐÃüÁ
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install php5-mysql
// °²×°php5-mysql Êǽ«phpºÍmysqlÁ¬½ÓÆðÀ´
Ò»µ©°²裝Íê³É£¬MySQL ·þ務Æ÷應該×Ô動啟動¡£Äú¿ÉÒÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ