mysql×Ô¶¯¹Ø±ÕÎÊÌ⣨¼±£¡£¡£¡£©
ÎÒ×öºÃµÄÍøÕ¾·Åµ½·þÎñÆ÷ÉÏ£¬ÎÒÓõÄÊÇÁ¬½Ó³Ø£¬·þÎñÆ÷ÄDZߵÄmysqlÉèÖõÄÊÇ1·ÖÖÓ×Ô¶¯¹Ø±Õ£¬ËûÃÇÊÇÏëµÄÊý¾Ý¿âÁ¬½ÓÉêÇëÒ»¸ö¾Í¹Ø±ÕÒ»¸ö£¬Èç¹ûÓÃÁ¬½Ó³ØÒ»·ÖÖÓÖ®ºómysql¹Ø±Õ¾ÍÁ¬½Ó²»ÉÏÊý¾Ý¿â£¬Ö»ÓÐÖØÆôtomact£¬ÕâÑùµÄÎÊÌâÈçºÎ½â¾ö
mysqlΪºÎÒª×öÕâÑùµÄÉèÖÃÄØ£¬Èç¹û±ØÐëÒª×öÕâÑùµÄÉèÖõϰ£¬ÄǾͲ»ÒªÓÃÁ¬½Ó³ØÁË¡£
µÚÒ»´Î¼ûµ½ÕâÑùÅäÖÃÊý¾Ý¿âµÄ¡£
Á¬½Ó³Ø¾ÍÊÇÓÃÀ´¹ÜÀíÁ¬½ÓµÄ
·þÎñÆ÷ÄDZ߸ÉÂﻹҪÉèÖùرÕÁ¬½Ó£¿
ÓÃÁ¬½Ó³ØµÄ»°¾Í°Ñ·þÎñÆ÷ÄDZߵÄÉèÖÃÈ¡Ïû
ÕâÑù×öÎ¥±³ÁËÉè¼ÆÁ¬½Ó³ØµÄ³õÖÔÁË£¬µ½ÍøÉÏ¿´Ò»ÏÂJNDIÁ¬½Ó³ØµÄÅäÖã¬È»ºó·þÎñÆ÷ÄDZ߹رÕÁ¬½ÓµÄÉèÖÃÈ¡Ïû
ºÇºÇ£¬°Ù¶È»òggÏÂÊý¾Ý¿âÁ¬½Ó³ØµÄÅäÖðɡ£·þÎñÆ÷ÄDZ߰ѹرÕÁ¬½ÓµÄÉèÖÃÈ¡ÏûÁË¡£
Ïà¹ØÎÊ´ð£º
mysqlÓÐûÓÐÀàËÆsqlserverµÄÏûÏ¢´«µÝ¹¦ÄÜ
±ÈÈçÕë¶ÔdbÖ®¼äµÄ»¥Ïà·¢ÏûÏ¢¡¡£¨ÏûÏ¢´«µÝ£©
ûÓС£
³ý·ÇÄã×Ô¼º¸ÄдһÏÂMYSQLµÄÔ´´úÂëÈ»ºó±àÒëÔËÐС£
½èÖúÆäËûÓïÑÔ
ĿǰµÄmysqlÀïÃæÏÖ³ÉÕâÑùµÄ¹¦ÄÜ¡£
......
ÔÚmysqlÖÐÓÐÒ»ÕÅ±í£¬ÓÐÈý¸ö×Ö¶Îtotal,max, min£¬¶¼ÊÇintÐ͵ÄÖµ£¬¿ÉÒÔдһ¸ösqlÓï¾äÍê³É¹¦ÄÜ£º
¸ù¾ÝÿÌõ¼Ç¼ÖУ¬Èç¹ûtotal>max,·µ»Ø2£¬Èç¹ûtotal <min·µ»Ø1£¬Èç¹û¶¼Ìõ¼þ¶¼²»·ûºÏ·µ»Ø0¡£¼±Ç󣡣¡£¡£¡
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Àï¿ÉÒÔ£¬µ«ÊÇÈ´² ......
´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º
create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;
±£´æÎªindex.s ......