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