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

°²×°mysql£¬Çë°ï棡

±¾ÈËÐÂÊÖ ÏÂÔØÁ˸ömysql ÇëÎÊÈçºÎ°²×°
mysql-5.1.32-linux-i686-glibc23.tar.gz
ÄãÊÇʲôϵͳ£¿

redhatµÄ»°¾ÍÈ¥ÏÂrpm£¬Ö±½Órpm -i xxxx.rpm¾ÍOKÁË


²»¹ý±¾ÈË»¹ÊÇÍÆ¼öʹÓð²×°µÄ°æ±¾

ÒýÓÃ
ÎÒ¿´ÁË ÄãÕâ¸öÊÇÃâ°²×°°æ±¾µÄmysql
ÓÃtar -xzvf mysql-5.1.32-linux-i686-glibc23.tar.gz½âѹËõ
È»ºó cd mysql-5.1.32-linux-i686-glibc23
²é¿´Ò»¸ö½ÐINSTALL-BINARYµÄÎļþ ÕÕ×ÅÕâ¸öÎļþÅäÖþͿÉÒÔÁË

°´ÕÕÄã˵µÄ ÔÚÍøÉÏÒ²²éÁË²é °²×°ºÃÁË Ð»Ð»ÁË


Ïà¹ØÎÊ´ð£º

oracle ¶ÔÓ¦µÄMySQLÓï¾ä

orcle Óï¾ä create table book1(name, price) as select book_name, price form book;
¶ÔÓ¦µÄMySQLµÄÓï¾äÊÇʲô

create table book1 as select book_name, price form book; ÕâÑùÔÚMySQLÀï¿ÉÒÔ£¬µ«ÊÇÈ´² ......

½ô¼±ÇóÖú£ºmysql´´½¨Ë÷Òý³öÎÊÌâÁË

´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º

create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;

±£´æÎªindex.s ......

ÎÒÒª°Ñ×¢²áÐÅÏ¢Ìá½»µ½mysqlÖУ¬ÒªÔõô°ìÄØ£¿

ÎÒÔÚ×¢²áÒ³ÃæÐ´ÈëÁËÈçÏ´úÂ룺
<?php
    $conn=mysql_connect("localhost","root","614510")or die("Êý¾Ý¿â·þÎñÆ÷Á¬½Ó´íÎó".mysql_error());
& ......

ÈçºÎÔÚWindowsÉϰ²×°Á½¸öMysql·þÎñ



Çå²Î¿¼

×î½üÖ»ÊÇºÃÆæ£¬ÏëÖªµÀÔÚwinÏÂÄܲ»ÄÜͬʱÔËÐÐÁ½¸ömysql £¬ÎÒÖ»ÊǾõµÃÉèÖõÄʱºòmysqlµÄ·þÎñ¶Ë¿Ú²»ÄÜÒ»Ñù£¬ÉèÖò»Í¬µÄ¶Ë¿ÚºóÓ¦¸Ã¿ÉÒÔ£¬¿ÉÊǾßÌå·½·¨»¹ÊDz»ÖªµÀ£¬ºóÀ´¾­¹ý²éѯ×ÊÁÏ×Ü

×î½ü ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ