mysqlÂÒÂëÎÊÌâ
´´½¨µÄһЩ±í»á³öÏÖÕâÑùµÄÎÊÌ⣺ӢÎIJåÈëµ½±íÖÐûÓÐÈκÎÎÊÌâ¡£µ«ÊDzåÈëÖÐÎĵÄʱºò¾Í³öÏÖ Data truncation: Data too long for column 'name' at row 1 ÀàËÆµÄÎÊÌâ¡£
mysqlÄܰÑÓ¢ÎÄ×ֶβåÈçÊý¾Ý¿âÁË¡¡µ±ÎÒÊäÈëÖÐÎÄʱËû¾Í³öÏÖ×Ö¶ÎData truncation: Data too long for column 'name' at row 1
ÎÒʹÓÃÅóÓѵÄÕâ¸ö·½·¨£º(1)ÐÞ¸Ä $mysql_path$\my.ini(MySQL Server Instance Configuration Îļþ)
ÉèÖÃdefault-character-set=gbk(×¢Ò⣬ÓÐ2´¦)
(2)ÐÞ¸ÄdataĿ¼ÖÐÏàÓ¦Êý¾Ý¿âĿ¼ÏµÄdb.optÅäÖÃÎļþ
default-character-set=gbk
default-collation=gbk_chinese_ci
ÖØÆðmysql,¾ÍokÁË.
(×¢£ºÈç¹û±íÊÇÔÚûÓиÄ֮ǰµÄ£¬Ò»¶¨ÒªÖØÐ´´½¨£¬·ñÔò±í»¹ÊÇÒÔǰµÄ±àÂ룬»¹ÊDz»ÄܲåÈë
ÖÐÎÄÊý¾Ý£©
Ïà¹ØÎĵµ£º
PHP³ÌÐòºÍMySqlÊý¾ÝÂÒÂëÎÊÌâÔÒò¼°½â¾ö
ÂÒÂëÎÊÌâ¼òµ¥Ëµ¾ÍÊÇÊý¾Ý¿âдÈë¶ÁÈ¡£¬ÍøÒ³Îļþ£¬ÍøÒ³ÏÔʾʱ¼¸¸ö»·½ÚµÄ±àÂë²»Ò»ÖÂÔì³ÉµÄ¡£
ÂÒÂëÎÊÌâ
дÈëʱ£ºÒ³ÃæÌáȡдÈëÊý¾Ý±àÂëºÍдÈëÊý¾Ý¿âʱ±àÂë²»Ò»ÖÂ
¶Áȡʱ£º¶ÁÈ¡ºóËùÓñàÂëÓëÊý¾Ý¿âдÈëʱ²»Ò»ÖÂ
ÏÔʾʱ£º±àÂëÓëÊý¾Ý¿â¶ÁÈ¡ºóµÄÊý¾Ý²»Ò»ÖÂ
ºÜÏÔȻֻÓÐÈýÕß¶¼Í³Ò»²ÅÐУ ......
ÍüÁËOracleµÄsysÓû§ºÍMySQLµÄrootÓû§ÃÜÂ룬½â¾ö·½·¨
2007Äê03ÔÂ16ÈÕ ÐÇÆÚÎå 09:44
×÷Õߣºhexiong¡¡
°æÈ¨ÉùÃ÷£º¿ÉÒÔÈÎÒâ×ªÔØ£¬×ªÔØÊ±ÇëÎñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂÔʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡£
http://hi.baidu.com/hexiong/blog/item/b4acd72a85272d2cd42af1b1.html
¾³£Åöµ½ÓÐÈËÔÚÂÛ̳ÉÏÎÊÕâ¸öÎÊÌ⣬¸É´àÔÚÕâÀï×ܽáÒ ......
ÔÚ×ÀÃæÉÏн¨Ò»¸ö¿ÕµÄÎı¾Îļþmysql.txt,ÖØÃüÃûΪmysql.udl,Ë«»÷Õâ¸ömysql.udlÎļþ£¬´ò¿ª“Êý¾Ý¿âÁ¬½ÓÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ìṩ³ÌÐò”ҳѡÔñ”Micrsoft Ole DB Provider for ODBC Drivers“£¬ µã»÷ÏÂÒ»²½£¬ÔÚ“Á¬½Ó”Ò³µÄ,"Ö¸¶¨Êý¾ÝÔ´"Ñ¡Ôñ"ʹÓÃÁ¬½Ó×Ö·û´®",µã» ......
[Ô´´] MySQLÊý¾Ý¿â´æ´¢ÒýÇæºÍ·ÖÖ§ÏÖ×´
ÔÚMySQL¾ÀúÁË2008ÄêSunµÄÊÕ¹ººÍ2009ÄêOracleÊÕ¹ºSunµÄ¹ý³ÌÖУ¬»ù±¾´¦ÓÚÍ£ÖÍ·¢Õ¹µÄÇé¿ö£¬ÔÚ¿ÉÒÔÔ¤¼ûµÄδÀ´£¬MySQLÊǿ϶¨»á±»Oracle¸éÖò¢ÇÒÖð²½Ñ©²ØÏûÃðµôµÄ¡£MySQLËæ×ÅÏàÓ¦µÄ¸÷Ö÷´´ºÍÄÚ²¿¿ª·¢ÈËÔ±µÄÀëÈ¥£¬µÞÔìÁ˸÷¸ö²»Í¬µÄÒýÇæºÍ·ÖÖ§£¬ÈÃMySQLÓÐÏ£Íû¼ÌÐø·¢Ñï¹â´óÆðÀ´¡£
±¾ ......
(1)ʵÏÖÈýá¹û¼¯A-½á¹û¼¯B£º--ÀûÓÃnot
exists£¬ºÏ²¢Ôò¿ÉÓÃunion
exists,not
exists£ºÓÃÓÚÅжÏÇÒ»ñÈ¡½á¹û¼¯AÊÇ·ñ´æÔڵؽá¹û¼¯BÖÐ!
==========½á¹û¼¯A£º
SELECT
d.Device_ID,d.Device_Name,a.App_ID,a.App_Name
from
T_ ......