MySQLÓÅ»¯×ܽá
±íÉè¼Æ·½Ã棺
1¡¢×Ö¶ÎÃû¾¡Á¿¼ò»¯£¬²»Òª³¬¹ý18¸ö×Ö·û
2¡¢Ê¹Óþ¡Á¿Ð¡µÄÊý¾ÝÀàÐÍ£¬ÀýÈ磺MEDIUMINT±ÈINTÉÙÕ¼ÓÃ25%¿Õ¼ä
3¡¢×Ö¶ÎÀàÐÍÓ¦¾¡Á¿±ÜÃâÉèÖóɿɱ䳤¶È£¬È磺VARCHAR¡¢BLOB¡¢TEXT
4¡¢ÓÃÓڱȽϵIJ»Í¬×ֶΣ¬Ó¦ÉèÖÃÏàͬµÄÀàÐͼ°³¤¶È
5¡¢¾¡¿ÉÄܽ«×Ö¶ÎÉùÃ÷ΪNOT NULL£¬²¢Ö¸¶¨DEFAULT
6¡¢Ö÷Ë÷Òý¾¡¿ÉÄܶÌ
7¡¢½ö´´½¨ÕæÕýÓõ½µÄË÷Òý£¨Ë÷Òý»á¼õÂý´æ´¢Êý¾ÝµÄËٶȣ©
8¡¢Èç¹ûÒ»¸ö×Ö·û´®ÀàÐÍ×Ö¶ÎÓÐΨһǰ׺£¬¿ÉÒÔʹÓÃÕâ¸öǰ׺×÷ΪË÷Òý¡£Èçǰ׺Ϊ1¸ö×Ö·û£¬Ôò¿ÉÒÔÕâÑùÉèÖÃË÷Òý INDEX( text( 1 ) )
9¡¢¿ÉÒ԰Ѿ³£É¨ÃèµÄ±í²ð·ÖΪÁ½¸ö±í
²éѯ·½Ã棺
1¡¢WHEREÌõ¼þµÄÓÅ»¯£ºÈ¥µô²»±ØÒªµÄÀ¨ºÅ£»³£Á¿ºÏ²¢£»³£Á¿×´Ì¬Çå³ý
2¡¢¸üÐÂƵ·±µÄMyISAM±íÖУ¬¾¡Á¿±ÜÃ⸴ÔÓµÄSELECT²éѯ
ÆäËû·½Ã棺
1¡¢Çå¿Õ±íʹÓÃTRUNCATE TABLE tablename ±È DELETE from tablename ¿ì
2¡¢INSERTʱ£¬Ö»ÓÐÔÚÒª²åÈëÊýÖµÓëĬÈÏÊýÖµ²»Í¬Ê±²ÅÖ´ÐвåÈë²Ù×÷
3¡¢Ò»´Î²åÈë¶àÐÐʱ£¬¾¡Á¿Ê¹Óöà¸öVALUESÁбíµÄINSERTÓï¾ä
4¡¢´Ó±íÖÐɾ³ý´óÁ¿Ðкó£¬ÔËÐÐOPTIMIZE TABLE tablename ½øÐÐËéƬÕûÀí
5¡¢Ê¹ÓÃANALYZE TABLE tablename ¸üÐÂË÷Òý·Ö²¼
Ïà¹ØÎĵµ£º
Each MySQL Cluster host computer running an SQL node must have
installed on it a MySQL binary. For management nodes and data
nodes, it is not necessary to install the MySQL server binary, but
management nodes require the management server daemon
......
ÓкܶàÅóÓÑËäÈ»°²×°ºÃÁË MySQL µ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâƪÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½Ó MySQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð© MySQL µÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMySQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡£
¡¡¡¡Ê×ÏÈÔÚ´ò¿ª DOS ´°¿Ú£¬È»ºó½øÈëĿ¼ mysql\bin£¬ÔÙ¼üÈëÃüÁîmysql -u ......
ÔÚlinuxÏÂÃæ°²×°mysql£¬Ê×ÏàÒª¸ù¾Ý²Ù×÷ϵͳµÄ°æ±¾£¬Ñ¡Ôñ¶ÔÓ¦µÄmysqlµÄ°æ±¾£¬¹Ù·½ÍøÕ¾ÉÏÓзdz£Ã÷È·µÄ·ÖÀà
http://dev.mysql.com/downloads/
ÔÚÕâÀïÎÒʵÑéµÄ²Ù×÷ϵͳÊÇredhat linux
mysql ÓÃÁËÁ½¸ö°²×°°ü£¬Ò»¸öÊÇserver¶Ë£¬Ò»¸öÊÇclient,ÎÒÓõÄÊÇrpm°ü£¬°²×°µÄÖ¸Áî±È½Ï¼òµ¥¡£
MySQL-server-community-5.1.42-0.rhel4.i38 ......
Oracle 8 資ÁÏ庫º¯Ê½庫
OCIDefineByName
讓 SELECT Ö¸Áî¿ÉʹÓà PHP 變數¡£
語·¨: boolean OCIDefineByName(int stmt, string ColumnName, mixed &variable, int [type]);
傳»ØÖµ: ²¼ÁÖÖµ
º¯Ê½種類: 資ÁÏ庫¹¦ÄÜ
內È ......
1¡¢Ñ¡È¡×îÊÊÓõÄ×Ö¶ÎÊôÐÔ
MySQL
¿ÉÒԺܺõÄÖ§³Ö´óÊý¾ÝÁ¿µÄ´æÈ¡£¬µ«ÊÇÒ»°ã˵À´£¬Êý¾Ý¿âÖеıíԽС£¬ÔÚËüÉÏÃæÖ´ÐеIJéѯҲ¾Í»áÔ½¿ì¡£Òò´Ë£¬ÔÚ´´½¨±íµÄʱºò£¬ÎªÁË»ñµÃ¸üºÃµÄÐÔÄÜ£¬ÎÒÃÇ¿ÉÒÔ½«
±íÖÐ×ֶεĿí¶ÈÉèµÃ¾¡¿ÉÄÜС¡£ÀýÈ磬ÔÚ¶¨ÒåÓÊÕþ±àÂëÕâ¸ö×Ö¶Îʱ£¬Èç¹û½«ÆäÉèÖÃΪCHAR(255),ÏÔÈ»¸øÊý¾Ý¿âÔö¼ÓÁ˲»±ØÒªµÄ¿Õ¼ä£¬É ......