Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Â¥£¬ÄãµÄ·½·¨ÊÇÕýÈ·µÄ£¬ÈçºÎÌí¼ÓÄã×öºÃÓÑÄØ£¿



Ïà¹ØÎÊ´ð£º

Çómysql+php ÖÐÎÄÈ«ÎÄËÑË÷

×ö¸öÕ¾ÄÚËÑË÷£¬ÏÖÔÚÓÃlike ÕâÑùµÄЧÂÊʵÔÚÌ«µÍÁË£¬Ïë¸Ä³ÉÈ«ÎÄËÑË÷·½Ê½¡£

µ«¿´ÁËÍøÉÏ˵µÄÖÐÎÄÖ§³Ö²»ºÃ£¬ÏëÎÊһϸ÷λÐÖµÜÊÇÈçºÎ½â¾öÕâ¸öÎÊÌâµÄ£¿
µ¥¶À½¨Á¢Ö÷Ìâ±íºÍÄÚÈÝ±í ¼ìË÷Ö÷Ìâ

È»ºó¸ù¾ÝÖ÷Ìâ¼ìË÷Ä ......

javaÁ¬½Ómysql±»¾Ü¾ø

ÎÒÔÚ³ÌÐòÀïÃæÐ´ÁËÒ»¸ö¼àÌýÆ÷£¬TomcatÆô¶¯µÄʱºò¾Í»áÈ¥¼ì²âÊý¾Ý¿âÊÇ·ñÁ¬½ÓÉÏÁË£¬µ«ÊDZ¨ÁË´í
Access denied for user 'root'@'localhost' (using password: YES)
·ÃÎʱ»¾Ü¾ø£¬ÔõÑùÐ޸ķÃÎÊÓû§µ ......

MYSQLÖÐÒÑ´æÔÚÓû§±ä¸üȨÏÞ

ÎÒÔÚ°²×°ÂÛ̳µÄʱºò£¬Ð½¨ÁËÒ»¸öMYSQLÓû§£¬È¨ÏÞÊÇALL£¨grant all ¡­¡­£©£¬ÏÖÔÚÂÛ̳°²×°ºÃÁË£¬ÎÒÏëÈÃÕâ¸öÓû§Ö»ÄܲÙ×÷ÌØ¶¨Êý¾Ý¿â£¨·ÃÎʺÍÐ޸쬰üÀ¨´´½¨É¾³ý±í£¬×îºÃ²»ÄÜɾ³ýÊý¾Ý¿â£¬µ«×ö²»µ½¾ÍËãÁË£©£¬ÀýÈçtestÊý¾Ý ......

Mysql²éѯÎÊÌâ¡£¡£¡£

  ÎÒÏëÔÚmysqlÖн«t_flow_card_detail±íÖеÄclient_id×ֶθÄΪÍâ¼ü£¬ÒýÓÃt_client±íÖеÄclient_id×ֶΣº
  ÎÒµÄsqlÓï¾äÊÇ£º alter table t_flow_card_detail add constraint FK_flowcard_client foreig ......

Çó¾ÈMySqlÄ£ºý²éѯÎÊÌâ

Java code:

Ä£ºý²éѯÊé°´ÕÕÊéÃû-------------------
java.sql.SQLException: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
at com.mys ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ