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

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Â¥£¬ÄãµÄ·½·¨ÊÇÕýÈ·µÄ£¬ÈçºÎÌí¼ÓÄã×öºÃÓÑÄØ£¿



Ïà¹ØÎÊ´ð£º

jsp±¸·ÝmysqlÖ»ÓпÕÎļþ

ÓÃjsp×ö¶«Î÷¸øÍêÈ«²»¶®mysqlµÄÈËÓ㬿ÉÊDZ¸·ÝʱֻÓпÕÎļþ£¬ÕâÊÇʲôÇé¿ö£¬
×îºÃÓÐÔ´´úÂ룬лл
Æäʵ±¸·ÝµÄ¹ý³ÌÎÒÏë´ó¸ÅÊÇÕâÑùµÄ£º
½«±íAÖеÄÊý¾Ý·Åµ½ArrayListÖУ¬È»ºó½«Õâ¸öArrayListÖеÄÊý¾ÝÔÙ´æµ½±íBÖС£ ......

MYSQL °²È«ÎÊÌâ

×î½üÔÚÑо¿Êý¾Ý¿âµÄ°²È«ÎÊÌ⣬·¢ÏÖMYSQLÓкܶలȫ©¶´£¬ÏëÇë½Ì´ó¼Ò£¬ÔÚ¹ÜÀí·½ÃæÈçºÎÀ´·ÀÖ¹°²È«Òþ»¼¡£

ÎÒÁ˽⵽ÓÐ×¢Èë¹¥»÷£¬¸ÃÈçºÎ·ÀÖ¹£¿

»¹ÓйØÓÚÕ˺š¢ÃÜÂëµÄ¹ÜÀí¡¢ÎļþÊôÐÔµÈ
1. ²Ù×÷ϵͳµÄ°²È«£¬ ......

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

mysqlÁ¬½ÓÎÊÌâ

Á¬½ÓÊý¾Ý¿âʱÔõô³öÏÖÕâÑùµÄ´íÎó£º[localhost] ERROR 1045: Access denied for user 'root'@'localhost' (using password: YES)
ÔΣ¬Óï¾äÌùÀ´¿´¿´
ÄãÃÜÂëÄØ

ÃÜÂë´íÁ˰ɡ£

¸Õѧmysql,ÕÕ×ÅÊ ......

C#¶ÁÈ¡mysqlÊý¾Ý¿âÎÊÌâ

ÎÒʹÓÃC#Á¬½ÓmysqlÊý¾Ý¿â¶ÁÈ¡ÆäÖеÄÊý¾Ý£¬
¶ÁÈ¡Êý¾Ý±íÖеÄVarcharÀàÐ͵ÄÊý¾Ý£¬Èç¹ûÊÇÓ¢ÎÄÄܹ»Õý³£¶ÁÈ¡³öÀ´£¬
¶øÈç¹ûÊÇÖÐÎÄ£¬¾Í»áÏÔʾΪ¡°£¿£¿¡±£¬

Èç¹û°ÑvarcharÀàÐÍ»»³ÉbinaryÀàÐÍ£¬Asp.net³ÌÐòÄܹ»Õý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ