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

mysql °²×°°ü

MySQL-client-community-5.0.41-0.rhel4.i386.rpm                    # ¿Í»§¶Ë
MySQL-devel-community-5.0.82-0.rhel4.i386.rpm                    #¿ª·¢Ê±ÒªÓõÄÍ·ÎļþºÍCÎļþ
MySQL-server-community-5.0.41-0.rhel4.i386.rpm                   #·þÎñ¶Ë
MySQL-shared-community-5.0.82-0.rhel4.i386.rpm                  #һЩ¿âÎļþ
perl-DBD-MySQL-2.9004-3.1.i386.rpm                        
 perl-DBI-1.40-5.i386.rpm


Ïà¹ØÎĵµ£º

MySQLɾ³ýÖ¸¶¨ÐÐ

mysql> select * from tx;
+------+
| id   |
+------+
|    4 |
|    7 |
|    3 |
|    9 |
|    5 |
+------+
5 rows in set (0.05 sec)
mysql> delete a from tx a inner join (select * from tx limit 2,2) b ......

Mysql·ÖÇø


http://dev.mysql.com/doc/refman/5.1/zh/partitioning.html
²é¿´ÊÇ·ñÖ§³Ö·ÖÇø£ºSHOW VARIABLES LIKE '%partition%';
·ÖÇøÓï¾äCREATE TABLE ti (id INT, amount DECIMAL(7,2), tr_date DATE)
ENGINE=INNODB
PARTITION BY HASH(MONTH(tr_date))
PARTITIONS 6; 
---------------------------------- ......

¡¾×ª¡¿mysqlÖÐDATETIME¡¢DATEºÍTIMESTAMPµÄÇø±ð

DATETIME¡¢DATE ºÍ TIMESTAMP ÀàÐÍÊÇÏàËÆµÄ¡£±¾ÆªÃèÊöÁËËüÃǵÄÌØÐÔÒÔ¼°ËüÃǵÄÏàËÆµãÓ벻ͬµã¡£
DATETIME ÀàÐÍ¿ÉÓÃÓÚÐèҪͬʱ°üº¬ÈÕÆÚºÍʱ¼äÐÅÏ¢µÄÖµ¡£MySQL ÒÔ 'YYYY-MM-DD HH:MM:SS' ¸ñʽ¼ìË÷ÓëÏÔʾ DATETIME ÀàÐÍ¡£Ö§³ÖµÄ·¶Î§ÊÇ '1000-01-01 00:00:00' µ½ '9999-12-31 23:59:59'¡£(“Ö§³Ö”µÄº¬ÒåÊÇ£¬¾¡¹Ü¸üÔ ......

ת£ºApache+mysql+phpÔÚwindowsϵÄÅäÖÃ(³É¹¦)

http://hi.baidu.com/fish124423/blog/item/c6f9f310190dd779ca80c456.html½â¾öerror trying access httpd. conf file.you will need to manually configure theµÄÅäÖÃÎÊÌâ
Apache+mysql+phpÔÚwindowsϵÄÅäÖÃ(³É¹¦)
2008-12-16 14:49
ApcheÏÂÔØµØµã£ºhttp://www.apache/org
Or   http://www.51cto.com/html/ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ