Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ²»ÔÚ·¶Î§


Ïà¹ØÎĵµ£º

Linux ±àÒë°²×° MYSQL 5.1 Óë Innodb

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

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

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

MySQLÊý¾Ý¿â±¸·ÝÓë»Ö¸´

·½·¨Ò»£º
1.µ¼³öÕû¸öÊý¾Ý¿â
ÃüÁîÐнøÈëµ½mysql°²×°Ä¿Â¼µÄbinĿ¼ÏÂ
¼ÙÉè×°ÔÚD:/mysql/bin
¼´£º¿ªÊ¼ ÔËÐÐ ÊäÈëcmd
d:
cd mysql/bin
È»ºóÖ´ÐÐÏÂÃæÓï¾ä
mysqldump -u Óû§Ãû -p Êý¾Ý¿âÃû > µ¼³öµÄÎļþÃû  
ʾÀý£ºmysqldump -u root -p sq_wcnc > d:\wcnc.sql
2.»Ö¸´Êý¾Ý¿â
   ³£ÓÃsource ÃüÁî ......

mysql¼ÓÃܽâÃܺ¯ÊýAES_ENCRYPTÓëAES_DECRYPT

mysqlϵļÓÃܺ¯ÊýÓÐÈçϼ¸¸ö
PASSWORD()£º´´½¨Ò»¸ö¾­¹ý¼ÓÃܵÄÃÜÂë×Ö·û´®£¬ÊʺÏÓÚ²åÈëµ½MySQLµÄ°²È«Ïµ
ͳ¡£¸Ã¼ÓÃܹý³Ì²»¿ÉÄæ£¬ºÍunixÃÜÂë¼ÓÃܹý³ÌʹÓò»Í¬µÄËã·¨¡£Ö÷ÒªÓÃÓÚMySQLµÄÈÏ֤ϵͳ¡£
 
ENCRYPT(£¬)£ºÊ¹ÓÃUNIX crypt()ϵͳ¼ÓÃÜ×Ö·û´®£¬ENCRYPT()º¯Êý½ÓÊÕÒª¼ÓÃܵÄ×Ö·û´®ºÍ£¨¿ÉÑ¡µÄ£©ÓÃÓÚ¼ÓÃܹý³ÌµÄsalt£¨Ò»¸ ......

MysqlÊý¾Ý±¸·ÝÒÔ¼°ÒìµØ´æ´¢

ÕûÀítuscany.org.cnµÄ·þÎñÆ÷£¬·¢ÏÖ3ÄêǰдµÄ½Å±¾»¹ÔÚÅÜ×Å :)
½Å±¾ÈçÏ£º
#==========================================================
#!/bin/bash
current_date=`date +%Y-%m-%d:%H:%M:%S`
/usr/local/mysql/bin/mysqldump -prootpass  dbname1 > ./DB_DIR/dbname1_"$current_date"_dump_file.sql 
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ