Winform+MySQL×öÏîÄ¿
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔCS¶þÑÔ£¬Èç¹ûÄãÒªÌá¸ßÐÔÄÜ£¬¾¡Á¿¼õÉÙDBÉϵĸ´ÔÓ²Ù×÷£¬°Ñ¼ÆËãѹÁ¦´«¸øCS³ÌÐò¡£ºÜ¶àÈ˶¼Ï°¹ß°ÑһЩ¸´ÔӵļÆËãͳ¼Æ¶¼×öÔÚDBÉÏ£¬Õâ¶ÔCS¶þÑÔÊǸö×îʧ°ÜµÄÉè¼Æ¡£
2.CSÉϵÄÐÔÄÜÌáÉý¹Ø¼üÔÚÓÚ2¸ö£¬1¸öÊÇËã·¨£¬Áí1¸ö¾ÍÊÇÌåÑéЧ¹û¡£Ëã·¨¹ýÓÚ¸´ÔӵĿÉÒÔ²ð·Ö¶àÏ̴߳¦Àí£¬¶ÔÓÚËã·¨¹ý¶àºÄʱµÄ£¬ÊµÔÚûÓÐÓÅ»¯µÄ¿ÉÄÜÁË£¬¶à¼ÓUIÌåÑéЧ¹û£¬±ÈÈç½ø¶ÈÌõµÈ´ý£¬ÌáÐÑ£¬ÕâЩ²Ù×÷¶¼ÓÐÀûÓÚÔö¼ÓÈËÃǶÔÄãµÄ³ÌÐòµÄºÃ¸Ð¶È
Êý¾Ý¿âÓÅ»¯, »º´æ, ¶àÏß³Ì ... ...
·¹ý
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º
create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;
±£´æÎªindex ......
ÏÖÔÚÓÐÒ»¸öÍøÕ¾£¬ÏëÔÚÁíÍâһ̨·þÎñÆ÷ÉÏ×öÒ»¸öÕâ¸öÍøÕ¾µÄ¾µÏñ¡£
ÔÚÖ÷ÍøÕ¾ÉϵÄÊý¾Ý¸üÐÂҪͬ²½µ½¾µÏñ·þÎñÆ÷ÉÏ
ͬʱÓû§·ÃÎʾµÏñ·þÎñÆ÷ʱµÄÊý¾Ý¸üÐÂҲҪͬ²½µ½Ö÷ÍøÕ¾ÉÏ
ÆäÖÐÊý¾Ý¸üРÖ÷Òª°üÀ¨ MysqlÊý¾Ý¿âµ ......
¸ßÊÖ£¬ÏÖÔÚÓöµ½Ò»¸ömysql±¸·ÝµÄÎÊÌâ¡£
ÎÒµÄÊý¾Ý¿âÀïÓÐһЩÓÃcreate function½¨Á¢µÄ×Ô¶¨Ò庯Êý¡£µ±ÎÒÓÃmysqldump±¸·Ý¸ÃÊý¾Ý¿âÈ»ºóµ¼Èëµ½ÁíÍâÒ»¸ö·þÎñÆ÷BÉÏ£¬·¢ÏÖ·þÎñÆ÷BÉÏÖ»ÓÐÊý¾Ý£¬¶øÃ»ÓÐÄÇЩ×Ô¶¨ÒåµÄº¯Êý¡£Î ......
ÔÚmysqlÖÐÓÐÒ»ÕÅ±í£¬ÓÐÈý¸ö×Ö¶Îtotal,max, min£¬¶¼ÊÇintÐ͵ÄÖµ£¬¿ÉÒÔдһ¸ösqlÓï¾äÍê³É¹¦ÄÜ£º
¸ù¾ÝÿÌõ¼Ç¼ÖУ¬Èç¹ûtotal>max,·µ»Ø2£¬Èç¹ûtotal <min·µ»Ø1£¬Èç¹û¶¼Ìõ¼þ¶¼²»·ûºÏ·µ»Ø0¡£¼±Ç󣡣¡£¡£¡
mysql? ......
ϵͳµÄʼþ²é¿´Æ÷ÖпÉÒÔ¿´µ½Å¶
ÔØ£ºTable 'mysql.host' doesn't existµÄ´íÎó
»¹ÊDz»Äܽâ¾öÎÊÌâ
²Î¿¼ÈçÏÂ
indowsÏÂÐÞ¸ÄMySQL°²×°Ä¿Â¼ºÍMySQLÊý¾ÝĿ¼
2009-04-04 08:49:20
¡¡± ......