MySQL´´Ê¼ÈË·¢ÓʼþѰÇóÖйú°ïÖú!
Ç×°®µÄÕü¾ÈMySQLµÄÖйúÇ©ÃûÖ§³ÖÕß:
Å·ÃË¿ÉÄÜÎÞ·¨Õü¾ÈMySQL, ÖйúºÍ¶íÂÞ˹¿ÉÄÜÊÇÕü¾ÈMySQLµÄÏ£ÍûÖ®ËùÔÚ¡£ÖйúÓµÓÐÇ¿´ó¡¢¶ÀÁ¢ÒÔ¼°×ÔÐŵķ´Â¢¶ÏÖ÷¹Ü»ú¹Ø£¬Òò´Ë£¬ÎÒ±¾ÈËÔÚ´ËÇëÇóÄúµÄ°ïÖú¡£¶ÔÓÚÄúÔÚ http://helpmysql.org/cn/petition
µÄÇ©Ãû£¬ÎÒÃÇÉî±í¸Ðл¡£Èç¹û¿ÉÒԵϰ£¬ÎÒÃÇÐèÒªÄúµÄ½øÒ»²½°ïÖú£º
£¨1£©ÉÌÎñ²¿·´Â¢¶Ï¾Ö http://fldj.mofcom.gov.cn/index.shtml
ÊDz¢¹º·´Â¢¶ÏÉó²éµÄÖ÷¹Ü»ú¹Ø£¬°üÀ¨±¾´Î¶Ô¼×¹ÇÎÄÊÕ¹ºÌ«Ñô΢µç×ӵķ´Â¢¶ÏÉó²é¡£Èç¹ûÄúÕýÔÚʹÓÃMySQL£¬ÄúµÄÒâ¼û½«¶ÔÓÚÉÌÎñ²¿·´Â¢¶Ï¾ÖµÄÉó²é·Ç³£ÖØÒª¡£ÎÒ
ÃDz»ÄÜÏêϸµÄָʾÄú¸ÃÈçºÎÈçºÎ¶ÔÖ÷¹Ü»ú¹Ø·´Ó³Çé¿ö£¬ÒòΪÕâÊDz»Í×µ±µÄ¡£µ«ÊÇÎÒÃÇÈÏΪ£¬Èç¹ûÄúÄܸæËßÖ÷¹Ü»ú¹ØÄúµÄ¹«Ë¾ÈçºÎʹÓÃMySQL
£¨Ê²Ã´ÏîÄ¿£¬Ê²Ã´¹æÄ£¡¢Êý¾ÝÁ÷Á¿ÒÔ¼°Ê¹ÓÃÕßÊýÁ¿µÈ£©ÒÔ¼°ÄúÈÏΪ¼×¹ÇÎÄÊÕ¹ºMySQLÖ®ºó»á²úÉúʲôÑùµÄÓ°Ï죬½«»á·Ç³£ÓÐÓá£Èç¹ûÄúÖªµÀMySQLÊǰº¹óµÄ
¼×¹ÇÎÄÊý¾Ý¿âµÄÃâ·ÑÌæ´úÆ·£¬¾ÙÀýÏòÉÌÎñ²¿·´Â¢¶Ï¾Ö˵Ã÷½«»áºÜÓаïÖú¡£ÌرðÊÇ£¬ÄúÖªµÀ»òʹÓÃMySQL×÷Ϊ³ïÂ룬»òÉù³Æ½«Ê¹ÓÃMySQL£¬ÒÔ´ËÒªÇó¼×¹ÇÎÄÊý
¾Ý¿â½µµÍ¼Û¸ñµÄÇé¿ö£¬ÇëÒ»¶¨ÏòÉÌÎñ²¿ËµÃ÷¡£ÎÒÃÇÏ£ÍûÄúÄÜÖ±½ÓдПøÉÌÎñ²¿·´Â¢¶Ï¾Ö£¬´«Õæ010-65198998¡£¼øÓÚʱ¼ä½ôÆÈ£¬ÎÒÃǹÄÀøÄúÖ±½Ó´òµç»°¸ø
ÉÌÎñ²¿·´Â¢¶Ï¾Ö£¬µç»°ÊÇ010-65198680¡£
ÉÌÎñ²¿·´Â¢¶Ï¾Ö»á±£»¤MySQLÒÔ¼°Äú×÷ΪʹÓÃÕߣ¬¿Í»§ºÍÏû·ÑÕßµÄÀûÒæ¡£ÔÚÓëÉÌÎñ²¿µÄ¹µÍ¨¹ý³ÌÖУ¬ÇëÄú¼òµ¥Ã÷Á˵ØËµÃ÷Äú¾ßÌåÐèҪʲôÑùµÄ°ïÖú¡£
£¨2£©¸ÐлÐíÐí¶à¶àÏñÄúÒ»ÑùÖ§³ÖÎÒÃǵÄÈË£¬ÎÒÃÇÔÚÖйúÒѾÊÕ¼¯µ½ÁË650 ¸öÇ©Ãû£¬Çë¼û£ºhttp://helpmysql.org/cn/stats
¡£ ÕâÊÇÒ»¸öºÜºÃµÄ¿ªÊ¼¡£µ«ÊÇÏñÖйúÕâÑùÒ»¸öÖ§³Ö¿ªÔ´µÄ´ó¹ú£¬Ó¦¸Ã»áÓиü¶àÈ˵ÄÇ©Ãû¡£ÎÊÌâ¿ÉÄÜÔÚÓںܶàÈË¿ÉÄÜÈÏΪÕâÊÇÅ·ÃËίԱ»áÉó²é¾ö¶¨µÄÊÂÏÖйú¿ÉÄÜÎÞ·¨¸Ä±äʲô¡£ÊÂʵÉÏ£¬ÖйúÉÌÎñ²¿·´Â¢¶Ï¾Ö¿ÉÒÔ×ö³ö×Ô¼ºµÄ¾ö¶¨¡£
ÔÚÖйú£¬ÖªµÀ´ËʵÄÈË¿ÉÄÜ»¹²»¶à£¬ÐÂÎű¨µÀÒ²±È½ÏÓÐÏÞ£¬±ÈÈçhttp://tech.sina.com.cn/it/2010-01-04/21153736195.shtml ¡£Èç¹ûÄúÓÐÐËȤ£¬¿ÉÒÔ°ïÎÒÃÇÁªÏµÖйúÓÐÓ°ÏìÁ¦ITÍøÕ¾»òÔÓÖ¾£¬¸æËßËûÃÇÕâ´ÎÇ©Ãû»î¶¯¡£
Èç¹ûÓиü¶àµÄÍøÕ¾²ÎÓë½øÀ´£¬¾Í»áÓиü¶àµÄÈËÇ©ÊðÇëÔ¸Ê飬ËäÈ»ÕâÖ»ÊǵÚÒ»²½¡£ÇмÇÈ·±£ÎÄÕÂÖлòÍøÕ¾ÖÐÌáµ½helpmysql.org£¬»òÕßÌṩһ¸öÁ´½Óhttp://helpmysql.org/cn/theissue/customerspaythebill
Ïà¹ØÎĵµ£º
To support MySQL Cluster, you will need to update
my.cnf
as shown in the following example.
You may also specify these parameters on the command line when
invoking the executables.
Note
The options shown here should not be confused with thos ......
ÕâÀïÊ×ÏÈ˵ÏÂoracle·ÖÒ³²»Ïñmysql·ÖÒ³ÄÇô¼òµ¥Ö±½Ólimit ¾Í¿ÉÒÔÁË.
mysql£ºsql ="select * from talbe limit 0,10";
µÚÒ»¸öÊý±íʾϱ꣬¾ÍÊÇ´ÓµÚ¼¸ÌõÊý¾Ý¿ªÊ¼£¬
µÚ¶þ¸öÊý±íʾÿҳÏÔʾ¶àÉÙÌõÊý¾Ý£¬¿ÉÒÔ˵Êǵ±ÄãÈ·¶¨Ã¿Ò³ÏÔʾ¶àÉÙÐÐʱºò£¬Ëü¾ÍÊÇÒ»¸ö¹Ì¶¨µÄÊý¡£
ÕâÀïÐèҪעÒâµÄÊÇ£¬mysqlµÄ·ÃÎÊϱêÊÇ´Ó0¿ªÊ¼µÄ¡£Õ ......
°²×°µÄOSΪSolaris10,mysql °æ±¾ÊÇ5.1.38
Ò»¡¢Ê¹ÓÃRPM°ü½øÐа²×°
Ê×ÏÈ¿ÉÒÔ´Ó°²×°¹âÅÌÖлòÕßµ½mysqlµÄÍøÕ¾ÉÏÏÂÔØ¶ÔÓ¦°æ±¾µÄrpm°üÈçÏ£º
MySQL-server-community-5.1.38-0.rhel5.i386.rpm
MySQL-client-community-5.1.38-0.rhel5.i386.rpm
½Ó×ÅÎÒÃÇ¿ÉÒÔʹÓÃrpmÃü ......
1.select max(id) from user;
2.select last_insert_id() as id from user limit 1;
(Õâ¸ö²âÊԵķµ»ØidÒ»Ö±ÊÇ0£¬ÓеãÎÊÌâ)
3.´¢´æ¹ý³Ì
1£©
oracelÖÐ
create sequence seqID
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
nocache
order;
create or replace procedure ......