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Â¥£¬ÄãµÄ·½·¨ÊÇÕýÈ·µÄ£¬ÈçºÎÌí¼ÓÄã×öºÃÓÑÄØ£¿
Ïà¹ØÎÊ´ð£º
select time from table
time
2009-09-12 12
2009-09-12 13
2009-09-12 14
2009-09-12 15
Ôõô½« ²éѯµÄÊý¾Ý±äΪ
time
2009-09-12 12ʱ
2009-09-12 13ʱ
2009-09-12 14ʱ
......
ÎÒÔÚ°²×°ÂÛ̳µÄʱºò£¬Ð½¨ÁËÒ»¸öMYSQLÓû§£¬È¨ÏÞÊÇALL£¨grant all ¡¡£©£¬ÏÖÔÚÂÛ̳°²×°ºÃÁË£¬ÎÒÏëÈÃÕâ¸öÓû§Ö»ÄܲÙ×÷ÌØ¶¨Êý¾Ý¿â£¨·ÃÎʺÍÐ޸쬰üÀ¨´´½¨É¾³ý±í£¬×îºÃ²»ÄÜɾ³ýÊý¾Ý¿â£¬µ«×ö²»µ½¾ÍËãÁË£©£¬ÀýÈçtestÊý¾Ý ......
Á¬½ÓÊý¾Ý¿âʱÔõô³öÏÖÕâÑùµÄ´íÎó£º[localhost] ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
ÔΣ¬Óï¾äÌùÀ´¿´¿´
ÄãÃÜÂëÄØ
ÃÜÂë´íÁ˰ɡ£
¸Õѧmysql,ÕÕ×ÅÊ ......
ÏÖÓеķþÎñÆ÷ÊÇ4ºË£¬ÄÚ´æÎª4G£¬Êý¾Ý¿âֻʹÓÃinnodbÊý¾ÝÒýÇæ¡£Á´½ÓÊý¿ÉÄܱȽϸߣ¬ÏÈÉèÖÃΪ500°É£¬¶øÇÒÊý¾Ý¿âÖеÄÊý¾Ý²åÈë¡¢¸üкÍɾ³ý²Ù×÷»á·Ç³£µÄƵ·±¡£
ÓÐûÓиßÈ˰ïæÅäÖÃÒ»ÏÂmy.cnf
Õâ¸öûÓж¨Â۵쬾ßÌå ......