±ísongµÄ±àÂëÊÇutf8£¬Ö´ÐÐinsert²Ù×÷ǰִÐÐÁËSET NAMES 'utf8'¼°SET sql_mode=''µÄ²Ù×÷£¬sqlÓï¾ä´òÓ¡³öÀ´×Ö¶Îspecialname¶ÔÓ¦µÄÒ²ÓÐÄÚÈÝ£¬ÊÇÈÕÎÄ(ÓеÄÈÕÎÄÄܱ£´æ£¬ÓеÄÈÕÎIJ»Äܱ£´æ)£¬µ«ÊDZ£´æÔÚÊý¾Ý¿âÖÐÒÔºó×Ö¶ÎspecialnameµÄÖµÊǿյ쬲»ÖªµÀΪʲô£¬Í¬ÑùµÄ£¬×Ö¶Îsongname¶ÔÓ¦µÄÖµÖÐÒ²ÓÐÖÐÎÄ£¬µ«ÊÇ´Ë×ֶεÄÖµ¼´¿ÉÒÔÕý³£±£´æ£¬Í¦Ææ¹ÖµÄ£¬Ï£Íû¸ßÊÖÄܰïÎÒ½â¾öһϣ¬¶àлÁË£¡
Ìáʾ£º×Ö¶ÎspecialnameµÄ³¤¶ÈÊÇ×ã¹»³¤µÄ¡£
2010-04-06 15:42:42 0.90594300 update_data new songid: |337430|
2010-04-06 15:42:42 0.90604500 Sql: INSERT INTO song (sengerid,specialid,songname,lrc,islrc,category_id,specialname,fid,isshow) VALUES ('7474','69363','¥ë¥Ê?¥ì¥¬ー¥í ~Ô¤«¤é¤Î贈¤êÎï~','','0','8','¥Ê?¥ì¥¬ー¥í ~Ô¤«¤é¤Î贈¤êÎï~ (Single)','92294160','1')
±ísongµÄ½á¹¹
create table
CREATE TABLE `song` (
`songid` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '¸èÇúid',
`songname` varchar(150) NOT NULL,
`specialname` varchar(100) NOT NULL DEFAULT '',
`lrc` text NOT NULL,
`specialid` mediumint(9) NOT NULL DEFAULT '0',
`sengerid` int(11) NOT NULL DEFAULT '0',
`isshow` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñ¿ÉÒÔʹÓÃ',
`islrc` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'ÊÇ·ñÊÇlrc¸è´Ê£¬1±íʾÊÇ£¬0±íʾ²»ÊÇ',
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......