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

Winform+MySQL×öÏîÄ¿

Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵģ¬¶ÔCS¶þÑÔ£¬Èç¹ûÄãÒªÌá¸ßÐÔÄÜ£¬¾¡Á¿¼õÉÙDBÉϵĸ´ÔÓ²Ù×÷£¬°Ñ¼ÆËãѹÁ¦´«¸øCS³ÌÐò¡£ºÜ¶àÈ˶¼Ï°¹ß°ÑһЩ¸´ÔӵļÆËãͳ¼Æ¶¼×öÔÚDBÉÏ£¬Õâ¶ÔCS¶þÑÔÊǸö×îʧ°ÜµÄÉè¼Æ¡£
2.CSÉϵÄÐÔÄÜÌáÉý¹Ø¼üÔÚÓÚ2¸ö£¬1¸öÊÇËã·¨£¬Áí1¸ö¾ÍÊÇÌåÑéЧ¹û¡£Ëã·¨¹ýÓÚ¸´ÔӵĿÉÒÔ²ð·Ö¶àÏ̴߳¦Àí£¬¶ÔÓÚËã·¨¹ý¶àºÄʱµÄ£¬ÊµÔÚûÓÐÓÅ»¯µÄ¿ÉÄÜÁË£¬¶à¼ÓUIÌåÑéЧ¹û£¬±ÈÈç½ø¶ÈÌõµÈ´ý£¬ÌáÐÑ£¬ÕâЩ²Ù×÷¶¼ÓÐÀûÓÚÔö¼ÓÈËÃǶÔÄãµÄ³ÌÐòµÄºÃ¸Ð¶È

Êý¾Ý¿âÓÅ»¯, »º´æ, ¶àÏß³Ì ... ...

·¹ý


Ïà¹ØÎÊ´ð£º

Çó¾È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 ......

CÓïÑÔ Mysql ÒÉÎÊ

if(mysql_init(&mysql)==NULL)
{
sprintf(ErrMsg,"We are outof Memory");
return(false);
}

if(!mysql_real_connect(&mysql,"localhost","test" ......

MySQL´´½¨´æ´¢¹ý³Ì³ö´í

ÔÚMySQL5.0Öд¬½¢´æ´¢¹ý³Ìͨ²»¹ý£¬Ìáʾ£º
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ......

mysqlÖÐ repair table

ÔÚmysqlÖÐrepair table xxxxx;Ìáʾ

mysql> repair table recordTbl;
+-----------------+--------+----------+----------------------------------------------+
| Table        ......

mysql±¸·ÝÎÊÌâ¡£¼±£¡£¡£¡£¡£¡

¸ßÊÖ£¬ÏÖÔÚÓöµ½Ò»¸ömysql±¸·ÝµÄÎÊÌâ¡£

ÎÒµÄÊý¾Ý¿âÀïÓÐһЩÓÃcreate function½¨Á¢µÄ×Ô¶¨Ò庯Êý¡£µ±ÎÒÓÃmysqldump±¸·Ý¸ÃÊý¾Ý¿âÈ»ºóµ¼Èëµ½ÁíÍâÒ»¸ö·þÎñÆ÷BÉÏ£¬·¢ÏÖ·þÎñÆ÷BÉÏÖ»ÓÐÊý¾Ý£¬¶øûÓÐÄÇЩ×Ô¶¨ÒåµÄº¯Êý¡£Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ