mysql:´´½¨Ë÷Òý³ö´í
´ó¼ÒºÃ£¬ÎÒÔÚ´´½¨Ë÷Òýʱ£¬³öÏÖ´íÎóÌáʾ£¬´úÂëÈçÏ£º
create uique index stu_cou_index on student_info.results (student_id, course_id);
show index from student_info.results;
±£´æÎªindex.sql£¬È»ºóÔËÐУ¬³öÏÖ´íÎó£º
mysql> c:\wamp\www\index.sql
show warnings disabled.
show warnings disabled.
error:
unknown command '\i'
->
²¢ÇÒûÓа취»Øµ½mysql>µÄÌáʾ·û״̬£¬Ö»ÄܹرÕmysqlÔËÐÐ̨£¬ÔÙ´ÓнøÈë¡£¡£¡£
лл¸÷λ´óϺ£¬°ïÎÒ¿´¿´¡£¡£
×¢ÒâÄãÃüÁîÐеÄÊéд£¬×îºÃתÒå\ºÅ£¬
mysql > c:\\wamp\\www\\index.sql
»òÕß
mysql > c:/wamp/www/index.sql
ÎÒÊÔ¹ýÁË£¬²»ÊÇÕâ¸ö´íÎ󡣡£¡£
create unique index stu_cou_index on student_info.results (student_id, course_id);
лл3Â¥µÄ¼°Ê±»Ø¸´£¬µ«ÊǸÄÁË»¹ÊDz»ÐУ¬»¹ÊdzöÏÖ´íÎóÌáʾ
mysql> c:\wamp\www\index.sql
show warnings disabled.
show warnings disabled.
error:
unknown command '\i'
->
²¢ÇÒûÓа취»Øµ½mysql>µÄÌáʾ·û״̬£¬Ö»ÄܹرÕmysqlÔËÐÐ̨£¬ÔÙ´ÓнøÈë¡£¡£¡£
5Â¥£¬ÄãµÄ·½·¨ÊÇÕýÈ·µÄ£¬ÈçºÎÌí¼ÓÄã×öºÃÓÑÄØ£¿
Ïà¹ØÎÊ´ð£º
±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......
ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......
ÎÒÔÚ³ÌÐòÀïÃæÐ´ÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......
ÎÒʹÓÃC#Á¬½ÓmysqlÊý¾Ý¿â¶ÁÈ¡ÆäÖеÄÊý¾Ý£¬
¶ÁÈ¡Êý¾Ý±íÖеÄVarcharÀàÐ͵ÄÊý¾Ý£¬Èç¹ûÊÇÓ¢ÎÄÄܹ»Õý³£¶ÁÈ¡³öÀ´£¬
¶øÈç¹ûÊÇÖÐÎÄ£¬¾Í»áÏÔʾΪ¡°£¿£¿¡±£¬
Èç¹û°ÑvarcharÀàÐÍ»»³ÉbinaryÀàÐÍ£¬Asp.net³ÌÐòÄܹ»Õý ......
ÏÖÓеķþÎñÆ÷ÊÇ4ºË£¬ÄÚ´æÎª4G£¬Êý¾Ý¿âֻʹÓÃinnodbÊý¾ÝÒýÇæ¡£Á´½ÓÊý¿ÉÄܱȽϸߣ¬ÏÈÉèÖÃΪ500°É£¬¶øÇÒÊý¾Ý¿âÖеÄÊý¾Ý²åÈë¡¢¸üкÍɾ³ý²Ù×÷»á·Ç³£µÄƵ·±¡£
ÓÐûÓиßÈ˰ïæÅäÖÃÒ»ÏÂmy.cnf
Õâ¸öûÓж¨Â۵쬾ßÌå ......