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

mysql×Ô¶¯¹Ø±ÕÎÊÌ⣨¼±£¡£¡£¡£©

ÎÒ×öºÃµÄÍøÕ¾·Åµ½·þÎñÆ÷ÉÏ£¬ÎÒÓõÄÊÇÁ¬½Ó³Ø£¬·þÎñÆ÷ÄDZߵÄmysqlÉèÖõÄÊÇ1·ÖÖÓ×Ô¶¯¹Ø±Õ£¬ËûÃÇÊÇÏëµÄÊý¾Ý¿âÁ¬½ÓÉêÇëÒ»¸ö¾Í¹Ø±ÕÒ»¸ö£¬Èç¹ûÓÃÁ¬½Ó³ØÒ»·ÖÖÓÖ®ºómysql¹Ø±Õ¾ÍÁ¬½Ó²»ÉÏÊý¾Ý¿â£¬Ö»ÓÐÖØÆôtomact£¬ÕâÑùµÄÎÊÌâÈçºÎ½â¾ö
mysqlΪºÎÒª×öÕâÑùµÄÉèÖÃÄØ£¬Èç¹û±ØÐëÒª×öÕâÑùµÄÉèÖõϰ£¬ÄǾͲ»ÒªÓÃÁ¬½Ó³ØÁË¡£
µÚÒ»´Î¼ûµ½ÕâÑùÅäÖÃÊý¾Ý¿âµÄ¡£

Á¬½Ó³Ø¾ÍÊÇÓÃÀ´¹ÜÀíÁ¬½ÓµÄ

·þÎñÆ÷ÄDZ߸ÉÂﻹҪÉèÖùرÕÁ¬½Ó£¿

ÓÃÁ¬½Ó³ØµÄ»°¾Í°Ñ·þÎñÆ÷ÄDZߵÄÉèÖÃÈ¡Ïû




ÕâÑù×öÎ¥±³ÁËÉè¼ÆÁ¬½Ó³ØµÄ³õÖÔÁË£¬µ½ÍøÉÏ¿´Ò»ÏÂJNDIÁ¬½Ó³ØµÄÅäÖã¬È»ºó·þÎñÆ÷ÄDZ߹رÕÁ¬½ÓµÄÉèÖÃÈ¡Ïû

ºÇºÇ£¬°Ù¶È»òggÏÂÊý¾Ý¿âÁ¬½Ó³ØµÄÅäÖðɡ£·þÎñÆ÷ÄDZ߰ѹرÕÁ¬½ÓµÄÉèÖÃÈ¡ÏûÁË¡£


Ïà¹ØÎÊ´ð£º

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ

±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£©

ûÓС£

³ý·ÇÄã×Ô¼º¸ÄдһÏÂMYSQLµÄÔ´´úÂëÈ»ºó±àÒëÔËÐС£

½èÖúÆäËûÓïÑÔ

ĿǰµÄmysqlÀïÃæÏÖ³ÉÕâÑùµÄ¹¦ÄÜ¡£ ......

MYSQLÖиù¾Ý×Ö¶ÎÖµÅжϷµ»Ø²»Í¬µÄÖµ

ÔÚmysqlÖÐÓÐÒ»ÕÅ±í£¬ÓÐÈý¸ö×Ö¶Îtotal,max, min£¬¶¼ÊÇintÐ͵ÄÖµ£¬¿ÉÒÔдһ¸ösqlÓï¾äÍê³É¹¦ÄÜ£º
¸ù¾ÝÿÌõ¼Ç¼ÖУ¬Èç¹ûtotal>max,·µ»Ø2£¬Èç¹ûtotal <min·µ»Ø1£¬Èç¹û¶¼Ìõ¼þ¶¼²»·ûºÏ·µ»Ø0¡£¼±Ç󣡣¡£¡£¡
mysql? ......

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ