mysqlÖеĺº×ÖÎÊÌ⣿£¿£¿£¿
´ó¼ÒºÃ£º
ÎÒ×î½üÔÚ¸ãÓÃCÁ¬½ÓMYSQL£¬ÔÚVCÏ£¬ÎÒÓÃINSERT²åÈëÓï¾ä£¬¾Í±¨Ò»¸ö´íÎó£¬ÎÒGOOGLEÁËһϣ¬ËµÊÇʲô²»ºº×ÖÎÊÌ⣬µ«´ó¶àÊý¶¼ÊÇÓëPHPµÄÎÊÌ⣬ҲûÓн²Ò»Ð©ÓëCµÄÓ÷¨£¬ÄÄλ¸ßÊÖÄܰïÎÒһϣ¬Ð»Ð»£¿£¿£¿
±¨Ê²Ã´´íÎóÒ²²»Ìù³öÀ´Ñ½
ÎÒ³öÏֵĴíÎóÊÇ£º
Incorrect string value: '\xc2\xde' for columu 'name' at row 1
Ò²¾ÍÊÇÎÒÔÚnameÖвåÈëÁ˺º×Ö¡£¡£¡£
²»»áMYSQL
²»¶®MYSQL²»¶®C
Â¥Ö÷½áÌùÂÊÉõµÍ£¬ÎÒÒ²²»¹ÜÁË
°²×°mysqlµÄʱºòÑ¡GB2312ÁËû
okÁË¡£
Ïà¹ØÎÊ´ð£º
Winform+MySQL×öÏîÄ¿£¬ÔÚ×¢ÖØÐÔÄܵÄÇé¿öÏ£¬ÎÒ¸ÃÈçºÎÈ¥Íê³ÉÕâÀàÐ͵ÄÏîÄ¿ÄØ£¡
Çë¸÷λ¸øÒÔÌáʾ¡£
ÄãÕâ¸ö·¶Î§Ì«¹ãÁË£¬ÎÒ˵2µãÖØÒªµÄ°É
1.WINFORM³ÌÐòÊǵ¥¶ÀÔËÐеÄCS³ÌÐò£¬ºÍBS²»Í¬£¬BSµÄѹÁ¦Ê¼ÖÕ¶¼ÔÚSERVERÉϵ쬶ÔC ......
MySQLÈëÃÅ
¿ÉÒÔÏÈ¿´Ê²Ã´Êé¼®°¡£¿
ÏȶÁÈý±é¡¶Êý¾Ý¿âϵͳ¸ÅÂÛ¡·,ÕÆÎÕÊý¾Ý¿âµÄ»ù´¡ÀíÂÛ¡£
È»ºóÔÙ´Ö¿´Ò»±éMYSQLµÄ¹Ù·½Îĵµ¡£ MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc/refman/5.1/zh/index.html
¾ÍÕÒÒ»±¾ºÜ»ù´ ......
SELECT a.tguildname ,SUM(a.ct) + if (SUM(b.ct) IS NULL ,0,SUM(b.ct)) from (
SELECT tg.tguildname,c.cid, (
cf.fbb + cf.fgjbb + cf.fjybb + cf.fqb + cf.fgjqb + cf.fjyqb + cf.fqib + cf. ......
ÎÒÓÐÒ»¸öjava»·¾³ÏµijÌÐò£¬ÔÚ±¾»úÔËÐÐÕý³££¬µ«·¢²¼µ½ÍøµÄÐéÄâÖ÷»úʱ²»ÄÜÁ¬½ÓÊý¾Ý¿âÁ¬½Ó³Ø
jdk 1.6 tomcat6.0.18 mysql5 mysqljdbc5.1.5
ÐéÄâÖ÷»úµÄ¼¼ÊõÈËԱ˵£¬Ö»ÄÜÅäÖþÖÓòµÄÊý¾Ý¿âÁ¬½Ó³Ø£¬Ò²¾ÍÊÇÔÚM ......
ÓÉÓÚÒÔǰûÓÐinnodbµÄÓ¦ÓþÑ飬ÔÚÅäÖÃinnodbµÄinnodb_data_file_pathÑ¡ÏîʱÓõÄÊÇĬÈÏÅäÖã¨ibdata1:10M:autoexte
nd£© ,½ñÌì·¢ÏÖ´ËÊý¾Ý¿âÔÚͬ²½Ö÷Êý¾Ý¿âÊý¾Ýʱ£¨´ËinnodbÊÇ×÷Ϊһ̨myisam dbµÄÀ䱸»úÆ÷£©£¬ibda ......